public List <AreaInCity> GetAreasInCity(string cid)
{
int cityId = Convert.ToInt32(cid);
using (HandyBackOfficeEntities entities = new HandyBackOfficeEntities())
{
return(entities.AreaInCities.Where(area => area.CityID == cityId).ToList());
}
}
public List <ServiceInArea> GetServicesInArea(string areaid)
{
int AreadId = Convert.ToInt32(areaid);
using (HandyBackOfficeEntities entities = new HandyBackOfficeEntities())
{
return(entities.ServiceInAreas.Where(Service => (Service.AreaID == AreadId) && Service.Active == "True").ToList());
}
}
public List <CustomerRequest> GetCustomerRequests(string email)
{
using (HandyBackOfficeEntities entities = new HandyBackOfficeEntities())
{
return(entities.CustomerRequests.Where(c => c.CustomerEmail == email).ToList());
// CustomerRequest objectCustomers = new CustomerRequest();
// foreach (CustomerRequest c in temp)
// {
// objectCustomers.CustomerRequestFor = c.CustomerRequestFor;
// }
// return objectCustomers;
}
}
public void AddCustomerRequest(string cname, string cmobileno, string cemail, string caddinfo, string cdatetimepref, int ccity, string carea)
{
CustomerRequest ctemp = new CustomerRequest();
ctemp.CustomerName = cname;
ctemp.CustomerMobile = cmobileno;
ctemp.CustomerRequestFor = "Pest Control";
ctemp.CustomerEmail = cemail;
ctemp.CustomerAdditionalInfo = caddinfo;
ctemp.CustomerDateTimePrefText = cdatetimepref;
ctemp.City = ccity;
ctemp.Area = carea;
using (HandyBackOfficeEntities entities = new HandyBackOfficeEntities())
{
entities.Database.Connection.Open();
entities.CustomerRequests.Add(ctemp);
entities.SaveChanges();
}
}