//public async Task<string> EditPackageOfferAsync(EditPackageOffer model) //{ // try // { // var parPOffID = new SqlParameter("@PackageOfferID", model.PackageOffer.PackageOfferID); // var parPacID = new SqlParameter("@PackageID", model.PackageOffer.PackageID); // var parOfferDesc = new SqlParameter("@OfferDesc", model.PackageOffer.OfferDesc); // var parPOffer = new SqlParameter("@OfferPercent", model.PackageOffer.OfferPercent); // var parOfferImgPath = new SqlParameter("@OfferImagePath", model.PackageOffer.OfferImagePath); // var parStart = new SqlParameter("@StartDate", model.PackageOffer.StartDate); // var parEnd = new SqlParameter("@EndDate", model.PackageOffer.EndDate); // return await db.Database.SqlQuery<string>("udspPackageOfferEdit @PackageOfferID,@PackageID,@OfferDesc, @OfferPercent,@OfferImagePath, @StartDate, @EndDate", // parPOffID, parPacID, parOfferDesc, parPOffer, parOfferImgPath, parStart, parEnd).FirstOrDefaultAsync(); // } // catch (Exception ex) // { // return "Error: " + ex.Message; // } //} public async Task <string> DeletePackageOfferAsync(long POID) { try { utblPackageOffer curObj = await db.utblPackageOffers.FindAsync(POID); db.utblPackageOffers.Remove(curObj); await db.SaveChangesAsync(); return("Package Details Removed"); } catch (SqlException ex) { if (ex.Errors.Count > 0) // Assume the interesting stuff is in the first error { switch (ex.Errors[0].Number) { case 547: // Foreign Key violation return("This record has dependencies on other records, so cannot be removed."); default: return("Error: " + ex.Message); } } return("Error while operation. Error Message: " + ex.Message); } catch (Exception ex) { return("Error: " + ex.Message); } }
public ActionResult EditPackageOffer(long id) { try { ViewBag.ActiveURL = "/Admin/packagelist"; SavePackageOffer model = new SavePackageOffer(); utblPackageOffer packageoffer = objAPI.GetObjectByKey <utblPackageOffer>("packageconfig", "packageofferbyid", id.ToString(), "PackageOfferID"); //model.PackageList = objAPI.GetAllRecords<PackageDD>("packageconfig", "packagelist"); var OfferPkglist = objAPI.GetRecordsByQueryString <long>("packageconfig", "OfferPackagelist", "id=" + id); model.PackageOffer = new PackageOffer() { PackageOfferID = packageoffer.PackageOfferID, OfferDiscount = packageoffer.OfferDiscount, OfferDesc = HttpUtility.HtmlDecode(packageoffer.OfferDesc), OfferImagePath = packageoffer.OfferImagePath, StartDate = packageoffer.StartDate, EndDate = packageoffer.EndDate, PackageID = OfferPkglist }; model.PackageList = objAPI.GetAllRecords <PackageDD>("packageconfig", "packagelist"); return(View(model)); } catch (AuthorizationException) { TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again"; return(RedirectToAction("Login", "Account", new { Area = "" })); } }