public bool SaveSalemanInstituteWiseTargets(mdlSalemanInstitutionTargets obj_mdlSalemanInstitutionTargets) { bool Save = false; if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); SqlCommand cmd = new SqlCommand(); SqlTransaction transaction = con.BeginTransaction(); try { if (obj_mdlSalemanInstitutionTargets.dtSalemanInstitutionTargets.Rows.Count > 0) { cmd = new SqlCommand("Delete from D_Targets_Saleman_Institution where Fk_EmployeeID = '" + obj_mdlSalemanInstitutionTargets.EmployeeID + "' and TargetMonth = '" + obj_mdlSalemanInstitutionTargets.TargetMonth + "' and TargetYear = '" + obj_mdlSalemanInstitutionTargets.TargetYear + "'", con, transaction); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } for (int i = 0; i <= obj_mdlSalemanInstitutionTargets.dtSalemanInstitutionTargets.Rows.Count - 1; i++) { if (obj_mdlSalemanInstitutionTargets.dtSalemanInstitutionTargets.Rows[i].RowState != DataRowState.Deleted) { cmd = new SqlCommand("stp_ERP_INSERT_D_Targets_Saleman_Institute", con, transaction); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add("@Fk_EmployeeID", SqlDbType.VarChar, 6).Value = obj_mdlSalemanInstitutionTargets.EmployeeID; cmd.Parameters.Add("@TargetMonth", SqlDbType.VarChar, 2).Value = obj_mdlSalemanInstitutionTargets.TargetMonth; cmd.Parameters.Add("@TargetYear", SqlDbType.VarChar, 4).Value = obj_mdlSalemanInstitutionTargets.TargetYear; cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 16).Value = obj_mdlSalemanInstitutionTargets.AddUser; cmd.Parameters.Add("@AddComputer", SqlDbType.VarChar, 20).Value = obj_mdlSalemanInstitutionTargets.LoginComputer; cmd.Parameters.Add("@BMCTargetValue", SqlDbType.Decimal, 18).Value = obj_mdlSalemanInstitutionTargets.dtSalemanInstitutionTargets.Rows[i]["BMC Target"].ToString(); cmd.Parameters.Add("@ServiceTargetValue", SqlDbType.Decimal, 18).Value = obj_mdlSalemanInstitutionTargets.dtSalemanInstitutionTargets.Rows[i]["Service Target"].ToString(); cmd.Parameters.Add("@BMCRecoveryValue", SqlDbType.Decimal, 18).Value = obj_mdlSalemanInstitutionTargets.dtSalemanInstitutionTargets.Rows[i]["BMC Recovery"].ToString(); cmd.Parameters.Add("@ServiceRecoveryValue", SqlDbType.Decimal, 18).Value = obj_mdlSalemanInstitutionTargets.dtSalemanInstitutionTargets.Rows[i]["Service recovery"].ToString(); cmd.ExecuteNonQuery(); } } transaction.Commit(); Save = true; if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { transaction.Rollback(); MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error); Save = false; if (con.State == ConnectionState.Open) { con.Close(); } } return Save; }
public bool SaveSalemanInstituteWiseTargets(mdlSalemanInstitutionTargets obj_mdlSalemanInstitutionTargets) { return obj_dalSalemanInstituteWiseTargets.SaveSalemanInstituteWiseTargets(obj_mdlSalemanInstitutionTargets); }