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)); }