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