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