public void UpdateServiceToCompany(ServicesCompany newServiceToCompany)
{
using (var ctx = new SystemCompanyEntities())
{
var serviceToCompany =
ctx.ServicesCompanies.First(
e => e.idService == newServiceToCompany.idService && e.idCompany == newServiceToCompany.idCompany);
if (serviceToCompany.startdate != newServiceToCompany.startdate ||
serviceToCompany.enddate != newServiceToCompany.enddate ||
serviceToCompany.price != newServiceToCompany.price ||
serviceToCompany.priceCost != newServiceToCompany.priceCost ||
serviceToCompany.paid != newServiceToCompany.paid)
{
serviceToCompany.startdate = newServiceToCompany.startdate;
serviceToCompany.enddate = newServiceToCompany.enddate;
serviceToCompany.price = newServiceToCompany.price;
if (newServiceToCompany.priceCost == string.Empty)
{
newServiceToCompany.priceCost = "0";
}
serviceToCompany.priceCost = newServiceToCompany.priceCost;
serviceToCompany.paid = newServiceToCompany.paid;
ctx.SaveChanges();
}
}
}
/* public List<ServicesCompany> GetIdServiceAndIdCompny()
* {
* var query = _mDb.ServicesCompanies.Select(s => new
* {
* s.idService,
* s.idCompany,
* }).ToList();
*
* return query.Select(serviceCompany => new ServicesCompany
* {
* idService = serviceCompany.idService,
* idCompany = serviceCompany.idCompany
* }).ToList();
* }*/
public void InsertServiceToCompany(ServicesCompany serviceToCompany)
{
using (var ctx = new SystemCompanyEntities())
{
ctx.AddToServicesCompanies(serviceToCompany);
ctx.SaveChanges();
}
}
public void DeleteServiceToCompany(ServicesCompany idServiceToIdCompany)
{
using (var ctx = new SystemCompanyEntities())
{
var serviceToCompany =
ctx.ServicesCompanies.First(
e => e.idService == idServiceToIdCompany.idService && e.idCompany == idServiceToIdCompany.idCompany);
AuditDataServices.Instance.InsertAudit(serviceToCompany.idCompany, serviceToCompany.idService, 0, "ServicesCompanies", Convert.ToString(serviceToCompany.startdate), "Delete");
AuditDataServices.Instance.InsertAudit(serviceToCompany.idCompany, serviceToCompany.idService, 0, "ServicesCompanies", Convert.ToString(serviceToCompany.enddate), "Delete");
AuditDataServices.Instance.InsertAudit(serviceToCompany.idCompany, serviceToCompany.idService, 0, "ServicesCompanies", serviceToCompany.price, "Delete");
AuditDataServices.Instance.InsertAudit(serviceToCompany.idCompany, serviceToCompany.idService, 0, "ServicesCompanies", serviceToCompany.priceCost, "Delete");
AuditDataServices.Instance.InsertAudit(serviceToCompany.idCompany, serviceToCompany.idService, 0, "ServicesCompanies", Convert.ToString(serviceToCompany.paid), "Delete");
ctx.DeleteObject(serviceToCompany);
ctx.SaveChanges();
}
}
