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