public string AddServices(Vendorservices service) { var str = string.Empty; try { var userobj = (from u in context.Vendors where u.Vendorid == service.Vendorid select u).FirstOrDefault(); var wish = (from w in context.Vendorservices where w.Vendorid == service.Vendorid && w.Name == service.Name select w).FirstOrDefault(); if (userobj == null) { return("enter valid data vendor doesnt exist"); } else if (wish != null) { return("Vendor has a same service alredy registered"); } else { context.Vendorservices.Add(service); context.SaveChanges(); str = "sucessfully added service"; } } catch (Exception e) { str = e.Message; throw (e); } return(str); }
public string DelServices(Vendorservices services) { var str = string.Empty; try { var dbcart = (from c in context.Vendorservices where c.Vendorid == services.Vendorid && c.Name == services.Name select c).FirstOrDefault(); if (dbcart != null) { context.Vendorservices.Remove(dbcart); context.SaveChanges(); str = "Sucessfully deleted"; } else { str = "service doesnt exist for that vendor"; } } catch (Exception e) { str = e.Message; throw e; }; return(str); }
public string DelServices(Vendorservices services) { try { return(VendorDao.DelServices(services)); } catch (Exception e) { throw e; } }
public string UpdateServices(Vendorservices services) { string status = "could not update try again"; try { Vendorservices carti = (from c in context.Vendorservices where c.Vendorid == services.Vendorid && c.Name == services.Name select c).FirstOrDefault(); carti.Price = services.Price; using (var newContext = new StuffyCareContext()) { newContext.Vendorservices.Update(carti); newContext.SaveChanges(); status = "updated sucessfuly"; } } catch (Exception e) { status = "exception occured in Dal"; throw e; } return(status); }