public int AddPayment(PaymentTbl pt, string Paymentno)
{
int returnVal = 0;
try
{
Paymentno = pt.PaymentNo;
pt.CreatedDate = DateTime.Now;
if (pt.CreatedDate != null)
{
pt.CreatedBy = "abcd";
}
bool existingCustomer = db.PaymentTbl.Any(x => x.PaymentNo == Paymentno);
if (existingCustomer == true)
{
returnVal = -1;
}
if (existingCustomer == false)
{
db.PaymentTbl.Add(pt);
db.SaveChanges();
}
//return 1;
}
catch (Exception ex)
{
throw;
}
return(returnVal);
}
public PaymentTbl GetPayment(int id)
{
try
{
PaymentTbl c = db.PaymentTbl.Find(id);
return(c);
}
catch (Exception)
{
throw;
}
}
public int AddPayment(PaymentTbl pt)
{
try
{
db.PaymentTbl.Add(pt);
db.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw;
}
}
public int DeletePayment(int id)
{
try
{
PaymentTbl inv = db.PaymentTbl.Find(id);
db.PaymentTbl.Remove(inv);
db.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
public int UpdatePayment(PaymentTbl pt)
{
try
{
db.Entry(pt).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}