public static void UpdatePerson(InvoiceModle person)
{
lock (LockObj)
{
var persons = InvoiceModle.Storage;
InvoiceModle updatingPerson = persons.FirstOrDefault(p => p.Id == person.Id);
if (updatingPerson == null)
{
throw new Exception("InvoiceModle not found");
}
updatingPerson.UId = person.UId;
updatingPerson.InvoiceNo = person.InvoiceNo;
updatingPerson.AmountNoTax = person.AmountNoTax;
updatingPerson.InvoiceDate = person.InvoiceDate;
try
{
UpdateToDatabase(updatingPerson);
}
catch (Exception e)
{
throw;
}
InvoiceModle.Storage = persons;
}
}
private static void UpdateToDatabase(InvoiceModle updatingPerson)
{
using (Entities db = new Entities())
{
if (updatingPerson.UId == null || db.T_FD_InvoiceList.Find(updatingPerson.UId) == null)
{
db.T_FD_InvoiceList.Add(new T_FD_InvoiceList()
{
AmountNoTax = updatingPerson.AmountNoTax,
InvoiceDate = updatingPerson.InvoiceDate,
InvoiceNo = updatingPerson.InvoiceNo,
ReferenceId = ReferenceId
});
}
else
{
var dbItem = db.T_FD_InvoiceList.Find(updatingPerson.UId);
dbItem.AmountNoTax = updatingPerson.AmountNoTax;
dbItem.InvoiceDate = updatingPerson.InvoiceDate;
dbItem.InvoiceNo = updatingPerson.InvoiceNo;
dbItem.ReferenceId = ReferenceId;
}
db.SaveChanges();
}
}
private static void DeleteTFromDatabase(InvoiceModle updatingPerson)
{
using (Entities db = new Entities())
{
var dbItem = db.T_FD_InvoiceList.Find(updatingPerson.UId);
if (dbItem == null)
{
return;
}
db.T_FD_InvoiceList.Remove(dbItem);
db.SaveChanges();
}
}
public static int?AddPerson(InvoiceModle person)
{
lock (LockObj)
{
var persons = InvoiceModle.Storage;
person.Id = InvoiceModle.NewId;
try
{
UpdateToDatabase(person);
}
catch (Exception e)
{
throw;
}
persons.Add(person);
InvoiceModle.Storage = persons;
return(person.Id);
}
}
public static void DeletePerson(int id)
{
lock (LockObj)
{
var persons = InvoiceModle.Storage;
InvoiceModle person = persons.FirstOrDefault(p => p.Id == id);
if (person == null)
{
throw new Exception("InvoiceModle not found");
}
try
{
DeleteTFromDatabase(person);
}
catch (Exception e)
{
throw;
}
persons.Remove(person);
InvoiceModle.Storage = persons;
}
}