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