public void Update(ComplaintRequest obj)
{
DataHandler dh = new DataHandler();
dh.Update(string.Format(
"UPDATE dbo.ComplaintRequest SET description='{1}' WHERE ComplaintRequestID={0}",
obj.Id,
obj.Description
//obj.serviceContract.id
));
dh.Dispose();
RequestController requestController = new RequestController();
requestController.Update(obj);
}
public int Create(NewContractRequest obj)
{
DataHandler dh = new DataHandler();
RequestController requestController = new RequestController();
obj.Id = requestController.Create(obj);
dh.Insert(string.Format(
"INSERT INTO NewContractRequest(NewContractRequestID, ServiceContractID) VALUES ({0}, null)",
obj.Id
));
dh.Dispose();
return(obj.Id);
}
public void Update(ServiceRequest obj)
{
DataHandler dh = new DataHandler();
dh.Update(string.Format(
"UPDATE dbo.ServiceRequest SET description='{1}', jobStarted='{2}' WHERE ServiceRequestID={0}",
obj.Id,
obj.Description,
obj.JobStarted == null ? null : obj.JobStarted.Value.ToString("yyyy-MM-dd HH:mm:ss.fff")
));
dh.Dispose();
RequestController requestController = new RequestController();
requestController.Update(obj);
}
public int Create(ComplaintRequest obj)
{
DataHandler dh = new DataHandler();
RequestController requestController = new RequestController();
obj.Id = requestController.Create(obj);
dh.Insert(string.Format(
"INSERT INTO ComplaintRequest(ComplaintRequestID, ServiceContractID, description) VALUES ({0}, null, '{1}')",
obj.Id,
obj.Description
));
dh.Dispose();
return(obj.Id);
}
public int Create(ServiceRequest obj)
{
DataHandler dh = new DataHandler();
RequestController requestController = new RequestController();
obj.Id = requestController.Create(obj);
string query = string.Format(
"INSERT INTO ServiceRequest(ServiceRequestID, description, jobStarted) VALUES ({0}, '{1}', '{2}')",
obj.Id,
obj.Description,
obj.JobStarted == null ? null : obj.JobStarted.Value.ToString("yyyy-MM-dd HH:mm:ss.fff")
);
dh.Insert(query);
dh.Dispose();
return(obj.Id);
}
public void Update(NewContractRequest obj)
{
RequestController requestController = new RequestController();
requestController.Update(obj);
}