data is not inserting, i could not find the problem, please have a look
filename = System.IO.Path.GetFileName(upldphoto.PostedFile.FileName);
filename = GetUniqueFileName(filename);
bool a = obj.saveRecord(1,txtName.Text,txtPhone.Text,txtEmail.Text,txtAddress.Text,txtExpertise.Text,txtExp.Text,filename,txtQualification.Text);
this is function code
public bool saveRecord(int action,string name,string phone,string email,string address,string expertise,string experience,string image,string qualification)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand cmd = db.GetStoredProcCommand("SaveUpdateDocter");
db.AddInParameter(cmd, "@action", DbType.Int32, action);
db.AddInParameter(cmd,"@Name",DbType.String,name);
db.AddInParameter(cmd,"@Email",DbType.String,email);
db.AddInParameter(cmd,"@Address",DbType.String,address);
db.AddInParameter(cmd,"@Mobile",DbType.String,phone);
db.AddInParameter(cmd,"@Qualification",DbType.String,qualification);
db.AddInParameter(cmd,"@Expertise",DbType.String,expertise);
db.AddInParameter(cmd,"@Experience",DbType.String,experience);
db.AddInParameter(cmd,"@ImgName",DbType.String,image);
using (TransactionScope scope = new TransactionScope())
{
try
{
int a = cmd.ExecuteNonQuery();
scope.Complete();
if (a > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception e)
{
return false;
}
finally
{
cmd.Dispose();
}
}
}