/// <summary> /// used to update a service provided by an vendor /// </summary> /// <param name="vendorservice">object containing the details to be added</param> /// <returns>a string signifying the status</returns> public string UpdateVendorserviceDetails(Vendorservice vendorservice) { var str = string.Empty; try { var dbvendorservice = (from venservice in context.Vendorservices where venservice.Vendorid == vendorservice.Vendorid && venservice.Nameofservice == vendorservice.Nameofservice select venservice).FirstOrDefault(); if (dbvendorservice != null) { dbvendorservice.Price = vendorservice.Price; context.Vendorservices.Update(dbvendorservice); if (context.SaveChanges() > 0) { str = "Sucessfully Updated vendor service"; } } else { str = "Vendor with that service doesnt exist"; } } catch (Exception e) { str = e.Message; throw e; }; return(str); }
/// <summary> /// used to delete a service provided by an vendor /// </summary> /// <param name="vendorservice">object containing the details to be added</param> /// <returns>a string signifying the status</returns> public string DelVendorService(Vendorservice vendorservice) { var str = string.Empty; try { var dbvendorservice = (from venservice in context.Vendorservices where venservice.Vendorid == vendorservice.Vendorid && venservice.Nameofservice == vendorservice.Nameofservice select venservice).FirstOrDefault(); if (dbvendorservice != null) { context.Vendorservices.Remove(dbvendorservice); // context.Vendors.Update(dbvendor); if (context.SaveChanges() > 0) { str = "Sucessfully deleted"; } } else { str = "Vendor with that service doesnt exist"; } } catch (Exception e) { str = e.Message; throw e; } return(str); }
//vendor service part #region Vendor Service(CRUD operations) /// <summary> /// used to add a service provided by an vendor /// </summary> /// <param name="vendorservice">object containing the details to be added</param> /// <returns>a string signifying the status</returns> public string AddVendorService(Vendorservice vendorservice) { var str = ""; try { Vendorservice vendorserviceobj = (from c in context.Vendorservices where c.Vendorid == vendorservice.Vendorid && c.Nameofservice == vendorservice.Nameofservice select c).AsNoTracking().FirstOrDefault(); if (vendorserviceobj != null) { return("vendor has the service alredy registered(if u want to change price try update vendorservice)"); } context.Vendorservices.Add(vendorservice); if (this.save() > 0) { return("vendor's service added sucessfully"); } } catch (Exception e) { str = e.Message; throw e; } return(str); }
public JsonResult UpdateVendorservice([FromBody] Vendorservice vendorservice) { var str = _vendor.UpdateVendorserviceDetails(_mapper.Map <WoofyTailsDALLayer.EFModels.Vendorservice>(vendorservice)); bool status = false; if (str == "Sucessfully Updated vendor service") { status = true; } return(new JsonResult(new { Success = status, message = status ? "vendor service updated sucessfully" : str })); }
public JsonResult DeleteVendorservice(Vendorservice vendorservice) { var str = _vendor.DelVendorService(_mapper.Map <WoofyTailsDALLayer.EFModels.Vendorservice>(vendorservice)); bool status = false; if (str == "Sucessfully deleted vendor service") { status = true; } return(new JsonResult(new { Success = status, message = status ? "vendor service deleted sucessfully" : str })); }
public JsonResult GetVendorServices(string vendorid) { List <Vendorservice> listObj = new List <Vendorservice>(); var replistObj = _vendor.GetVendorservices(vendorid); if (replistObj != null) { foreach (var obj in replistObj) { Vendorservice vendorObj = _mapper.Map <Vendorservice>(obj); listObj.Add(vendorObj); } } return(new JsonResult(listObj)); }