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