//for loading user service request details in a list public List <ServiceRequestModel> loadUserServiceRequest(string email) { List <ServiceRequestModel> sr1 = new List <ServiceRequestModel>(); dbHelper db = new dbHelper(); sr1 = db.loadUserServiceRequest(email); return(sr1); }
//for loading description if click on view details public string loadDescription(string idsr) { string description = ""; dbHelper db = new dbHelper(); description = db.loadDescription(idsr); return(description); }
} // id of user table is foreign key in sr table //for loading admin service request details in a list public List <ServiceRequestModel> loadServiceRequest() { List <ServiceRequestModel> sr1 = new List <ServiceRequestModel>(); dbHelper db = new dbHelper(); sr1 = db.LoadServiceRequest(); return(sr1); }
public bool resolveServiceRequest(ServiceRequestModel objsr) { bool status = false; dbHelper db = new dbHelper(); status = db.resolveServiceRequest(objsr); return(status); }
public bool saveServiceRequest(ServiceRequestModel objsr) { bool Inserted = false; dbHelper db = new dbHelper(); Inserted = db.saveServiceRequest(objsr); return(Inserted); }
public Users ValidateUser(string email, string pwd) { Users obju = new Users(); dbHelper db = new dbHelper(); obju = db.ValidateUser(email, pwd); return(obju); }