public int Add(customer customerData)
{
try
{
using (var ctx = new AppDb())
{
var obj = ctx.customer.FirstOrDefault(f => f.Id == customerData.Id);
if (obj != null)
{
ctx.Entry(obj).CurrentValues.SetValues(customerData);
}
else
{
ctx.customer.Add(customerData);
}
var plot = ctx.plot.FirstOrDefault(f => f.Id == customerData.PlotID);
if (plot != null)
{
if (customerData.SellAmount != null)
{
plot.SellAmount = customerData.SellAmount ?? 0;
}
if (customerData.RegNo != null)
{
plot.RegNo = customerData.RegNo;
}
if (customerData.RegDate != null)
{
plot.RegDate = customerData.RegDate;
}
if (customerData.AllotmentLtDt != null)
{
plot.AllotmentLtDt = customerData.AllotmentLtDt;
}
if (customerData.TitleClearFrom != null)
{
plot.TitleClearFrom = customerData.TitleClearFrom;
}
if (customerData.TitleClearDt != null)
{
plot.TitleClearDt = customerData.TitleClearDt;
}
plot.Bank = customerData.Bank;
}
var intSave = ctx.SaveChanges();
return(intSave);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete(int Id)
{
using (var db = new AppDb())
{
var data = db.payment.FirstOrDefault(f => f.Id == Id);
if (data != null)
{
db.Entry(data).State = System.Data.Entity.EntityState.Deleted;
return(db.SaveChanges());
}
return(0);
}
}
public int Edit(user usr)
{
using (var db = new AppDb())
{
var checkuser = db.users.FirstOrDefault(f => f.Id == usr.Id);
if (checkuser == null)
{
throw new Exception("User not found!");
}
else
{
checkuser.Lastname = usr.Lastname;
checkuser.Firstname = usr.Firstname;
checkuser.Role = usr.Role;
checkuser.Email = usr.Email;
}
db.Entry(checkuser).State = System.Data.Entity.EntityState.Modified;
var rec = db.SaveChanges();
return(rec);
}
}
public int Add(template templateData)
{
try
{
using (var ctx = new AppDb())
{
var obj = ctx.template.FirstOrDefault(f => f.Id == templateData.Id);
if (obj != null)
{
ctx.Entry(obj).CurrentValues.SetValues(templateData);
}
else
{
ctx.template.Add(templateData);
}
return(ctx.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Add(quotation quotationData)
{
try
{
using (var ctx = new AppDb())
{
var obj = ctx.quotation.FirstOrDefault(f => f.Id == quotationData.Id);
if (obj != null)
{
ctx.Entry(obj).CurrentValues.SetValues(quotationData);
}
else
{
ctx.quotation.Add(quotationData);
}
ctx.SaveChanges();
return(quotationData.Id);
}
}
catch (Exception ex)
{
throw ex;
}
}
