public Boolean UpdateAgreement(mdlAgreement obj_mdlAgreement) { bool returnValue = false; try { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Open(); SqlCommand comm = new SqlCommand("stp_ERP_M_Agreement_Update", conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Add("@pk_DocNo", SqlDbType.Decimal).Value = obj_mdlAgreement.pk_DocNo; comm.Parameters.Add("@Draft", SqlDbType.Bit).Value = obj_mdlAgreement.Draft; comm.Parameters.Add("@Status", SqlDbType.VarChar, 15).Value = obj_mdlAgreement.Status; comm.Parameters.Add("@DocDate", SqlDbType.Date).Value = obj_mdlAgreement.DocDate; comm.Parameters.Add("@BPID", SqlDbType.VarChar, 10).Value = obj_mdlAgreement.BPID; comm.Parameters.Add("@CustomerID", SqlDbType.VarChar, 6).Value = obj_mdlAgreement.CustomerID; comm.Parameters.Add("@StartDate", SqlDbType.Date).Value = obj_mdlAgreement.StartDate; comm.Parameters.Add("@EndDate", SqlDbType.Date).Value = obj_mdlAgreement.EndDate; comm.Parameters.Add("@Remarks", SqlDbType.VarChar, 50).Value = obj_mdlAgreement.Remarks; comm.Parameters.Add("@OneTime", SqlDbType.Bit).Value = obj_mdlAgreement.OneTime; comm.Parameters.Add("@FY", SqlDbType.VarChar, 5).Value = obj_mdlAgreement.FY; if (comm.ExecuteNonQuery() > 0) { returnValue = true; } else { returnValue = false; } if (conn.State == ConnectionState.Open) { conn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERP - Babar Medicine Agreement Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error); if (conn.State == ConnectionState.Open) { conn.Close(); } } return returnValue; }
public Boolean UpdateAgreement(mdlAgreement obj_mdlAgreement) { return obj_dalAgreement.UpdateAgreement(obj_mdlAgreement); }
public Boolean SaveNewAgreementDetail(mdlAgreement obj_mdlAgreement, DataSet ds_AgreementDetail) { bool returnValue = false; try { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Open(); SqlCommand comm = new SqlCommand("stp_ERP_D_Agreement_Insert", conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Add("@DocNo", SqlDbType.VarChar, 15).Value = ds_AgreementDetail.Tables[0].Columns["pk_DocNo"].ToString(); comm.Parameters.Add("@ProductID", SqlDbType.VarChar, 15).Value = ds_AgreementDetail.Tables[0].Columns["ProductID"].ToString(); comm.Parameters.Add("@MRP", SqlDbType.Decimal).Value = ds_AgreementDetail.Tables[0].Columns["MRP"].ToString(); comm.Parameters.Add("@TP", SqlDbType.Decimal).Value = ds_AgreementDetail.Tables[0].Columns["TP"].ToString(); comm.Parameters.Add("@PurDisc", SqlDbType.Decimal).Value = ds_AgreementDetail.Tables[0].Columns["PurDisc"].ToString(); comm.Parameters.Add("@SaleTaxPer", SqlDbType.Decimal).Value = ds_AgreementDetail.Tables[0].Columns["SaleTaxPer"].ToString(); comm.Parameters.Add("@SaleTax", SqlDbType.Decimal).Value = ds_AgreementDetail.Tables[0].Columns["SaleTax"].ToString(); comm.Parameters.Add("@InvDays", SqlDbType.Decimal).Value = ds_AgreementDetail.Tables[0].Columns["InvDays"].ToString(); comm.Parameters.Add("@PurchaseRate", SqlDbType.Decimal).Value = ds_AgreementDetail.Tables[0].Columns["PurchaseRate"].ToString(); comm.Parameters.Add("@SaleRate", SqlDbType.Decimal).Value = ds_AgreementDetail.Tables[0].Columns["SaleRate"].ToString(); comm.Parameters.Add("@Draft", SqlDbType.Bit).Value = Convert.ToBoolean(ds_AgreementDetail.Tables[0].Columns["Draft"].ToString()); comm.Parameters.Add("@FY", SqlDbType.VarChar, 50).Value = ds_AgreementDetail.Tables[0].Columns["FY"].ToString(); if (comm.ExecuteNonQuery() > 0) { returnValue = true; } else { returnValue = false; } if (conn.State == ConnectionState.Open) { conn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERP - Babar Medicine Agreement Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error); if (conn.State == ConnectionState.Open) { conn.Close(); } } return returnValue; }
public Boolean SaveNewAgreement(mdlAgreement obj_mdlAgreement, DataSet ds_AgreementDetail) { return obj_dalAgreement.SaveNewAgreement(obj_mdlAgreement, ds_AgreementDetail); }