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