public PaymentTermVM SavePayment(PaymentTermVM Payment)
{
return(_PaymentRepo.SavePayment(Payment));
}
public PaymentTermVM SavePayment(PaymentTermVM Payment)
{
try
{
if (!Payment.EditFlag)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select count(*) as [count1] from PaymentTerms where CmpyCode='" + Payment.CmpyCode + "' and Code='" + Payment.Code + "'");
dt = ds.Tables[0];
int Payment1 = 0;
foreach (DataRow dr in dt.Rows)
{
Payment1 = int.Parse(dr["count1"].ToString());
}
if (Payment1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + Payment.CmpyCode + "',");
sb.Append("'" + Payment.Code + "',");
sb.Append("'" + Payment.Name + "',");
sb.Append("'" + Payment.NoOfDays + "')");
_EzBusinessHelper.ExecuteNonQuery("insert into PaymentTerms(CmpyCode,Code,Name,NoOfDays) values(" + sb.ToString() + "");
_EzBusinessHelper.ActivityLog(Payment.CmpyCode, Payment.UserName, "Add Payment", Payment.Code, Environment.MachineName);
Payment.SaveFlag = true;
Payment.ErrorMessage = string.Empty;
}
else
{
Payment.SaveFlag = false;
Payment.ErrorMessage = "Duplicate Record";
}
return(Payment);
}
var PaymentEdit = _EzBusinessHelper.ExecuteNonQuery("Select * from PaymentTerms where CmpyCode='" + Payment.CmpyCode + "' and Code='" + Payment.Code + "'");
if (PaymentEdit != 0)
{
_EzBusinessHelper.ExecuteNonQuery("update PaymentTerms set CmpyCode='" + Payment.CmpyCode + "',Code='" + Payment.Code + "',Name='" + Payment.Name + "',NoOfDays='" + Payment.NoOfDays + "' where CmpyCode='" + Payment.CmpyCode + "' and Code='" + Payment.Code + "'");
_EzBusinessHelper.ActivityLog(Payment.CmpyCode, Payment.UserName, "Update Payment", Payment.Code, Environment.MachineName);
Payment.SaveFlag = true;
Payment.ErrorMessage = string.Empty;
}
else
{
Payment.SaveFlag = false;
Payment.ErrorMessage = "Record not available";
}
}
catch
{
Payment.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(Payment);
}
