public int SaveFormValue(MVCModels.Form_Value objFormValue)
{
int rValue = 0;
try
{
int Form_Value_Id = 0;
using (IDbConnection connection = IDbOpenConnection())
{
string sql = "insert into tbl_sfa_Form_Value(Form_ID,Form_Custom_Name,Company_Code,Compnay_Id,Created_By,Created_Date)";
sql += "values(@Form_ID,@Form_Custom_Name,@Company_Code,@Compnay_Id,@user_code,getdate())";
sql += "SELECT convert(int,SCOPE_IDENTITY());";
Form_Value_Id = connection.Query <int>(sql, new { @Form_ID = objFormValue.Form_ID, @Form_Custom_Name = objFormValue.Form_Custom_name, @Company_Code = objFormValue.Company_Code, @Compnay_Id = objFormValue.Company_Id, @user_code = objFormValue.Created_By }).Single();
connection.Close();
}
using (IDbConnection connection = IDbOpenConnection())
{
foreach (var item in objFormValue.lsFormValueDetails)
{
string sql = "insert into tbl_sfa_Form_Value_Details(Form_Value_Id,Form_ID,Form_Control_Id,Form_Control_values,Company_Code,Compnay_ID)";
sql += "values(@Form_Value_Id,@Form_ID,@Form_Control_Id,@Form_Control_values,@Company_Code,@Compnay_ID)";
connection.Execute(sql, new { @Form_Value_Id = Form_Value_Id, @Form_ID = item.Form_ID, @Form_Control_Id = item.Form_Control_Id, @Form_Control_values = item.Form_Control_values, @Company_Code = objFormValue.Company_Code, @Compnay_ID = objFormValue.Company_Id });
connection.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(rValue);
}
public int SaveFormValue(MVCModels.Form_Value objFormValue)
{
objFormControls = new DAL_FormControls();
return(objFormControls.SaveFormValue(objFormValue));
}
