public static void Create(Application model) { using (var db = new dbContainer()) { var application = Mapper.Map<Application, tblApplications>(model); db.tblApplications.Add(application); db.SaveChanges(); } }
public static void Edit(Customer model) { using (var db = new dbContainer()) { var customer = Mapper.Map<Customer, tblCustomers>(model); db.Entry(customer).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static Application AddMessage(MessageViewModel VMMessage) { using (var db = new dbContainer()) { var application = db.tblApplications.Find(VMMessage.tblApplications_applicationId); tblMessages msg = Mapper.Map<MessageViewModel, tblMessages>(VMMessage); application.tblMessages.Add(msg); db.SaveChanges(); return Mapper.Map<tblApplications, Application>(application); } }
public static void Create(Customer model) { using (var db = new dbContainer()) { var customer = Mapper.Map<Customer, tblCustomers>(model); customer.dateCreated = DateTime.Now; db.tblCustomers.Add(customer); db.SaveChanges(); } }
public static Customer Delete(int customerId) { using (var db = new dbContainer()) { var dbCustomer = (from c in db.tblCustomers where c.customerId == customerId select c).FirstOrDefault(); var customer = Mapper.Map<tblCustomers, Customer>(dbCustomer); if (dbCustomer != null) { db.tblCustomers.Remove(dbCustomer); db.SaveChanges(); } return customer; } }
public static Application Delete(int appId) { using (var db = new dbContainer()) { var dbApplication = (from i in db.tblApplications where i.applicationId == appId select i).FirstOrDefault(); var application = Mapper.Map<tblApplications, Application>(dbApplication); if (dbApplication != null) { db.tblApplications.Remove(dbApplication); db.SaveChanges(); } return application; } }