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 = "" }));
}
}
public async Task <string> SavePackageOffer(SavePackageOffer model)
{
if (ModelState.IsValid)
{
return(await objPack.SavePackageOfferAsync(model));
}
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return("Operation Error: " + messages);
}
public ActionResult AddPackageOffer()
{
ViewBag.ActiveURL = "/Admin/packageofferlist";
try
{
SavePackageOffer model = new SavePackageOffer();
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 = "" }));
}
}
public ActionResult EditPackageOffer(SavePackageOffer model)
{
try
{
ViewBag.ActiveURL = "/Admin/packagelist";
if (model.cropper.PhotoNormal != null)
{
bool isValidFile = FileTypeCheck.DataImage(model.cropper.PhotoNormal);
if (!isValidFile)
{
TempData["ErrMsg"] = "Please Select A Valid Image File!";
return(View());
}
Random rand = new Random();
string name = "OfferBanner_" + DateTime.Now.ToString("yyyyMMdd") + "_" + rand.Next(50) + ".webp";
string normal_result = SaveImage(model.cropper.PhotoNormal, name);
if (normal_result.Contains("Error"))
{
TempData["ErrMsg"] = "Please Select A Valid Image File!";
return(View());
}
else
{
model.PackageOffer.OfferImagePath = "/Uploads/Offer/" + normal_result;
}
}
else
{
model.PackageOffer.OfferImagePath = model.PackageOffer.OfferImagePath;
}
//if (ModelState.IsValid)
//{
string jsonStr = JsonConvert.SerializeObject(model);
TempData["ErrMsg"] = objAPI.PostRecordtoApI("packageconfig", "savepackageoffer", jsonStr);
return(RedirectToAction("PackageOfferList", "Package", new { Area = "Admin" }));
//}
//return View(model);
}
catch (AuthorizationException)
{
TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again";
return(RedirectToAction("Login", "Account", new { Area = "" }));
}
}
public async Task <string> SavePackageOfferAsync(SavePackageOffer model)
{
try
{
ConvertListToDT objDT = new ConvertListToDT();
DataTable typeDt = new DataTable();
var parPOffID = new SqlParameter("@PackageOfferID", model.PackageOffer.PackageOfferID);
//var parPacID = new SqlParameter("@PackageID", DBNull.Value);
//if (model.PackageID != null)
// parPacID = new SqlParameter("@PackageID", model.PackageID);
var parOfferDiscount = new SqlParameter("@OfferDiscount", model.PackageOffer.OfferDiscount);
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);
List <IDModel> tyepList = model.PackageID.Select(x => new IDModel()
{
ID = Convert.ToInt64(x)
}).ToList();
typeDt = objDT.ConvertIEnumerableToDataTable(tyepList);
var parSubDT = new SqlParameter("@PackageOfferTable", typeDt);
parSubDT.SqlDbType = SqlDbType.Structured;
parSubDT.TypeName = "dbo.IDType";
return(await db.Database.SqlQuery <string>("udspPackageOfferSave @PackageOfferID,@OfferDiscount, @OfferDesc, @OfferImagePath, @StartDate, @EndDate,@PackageOfferTable",
parPOffID, parOfferDiscount, parOfferDesc, parOfferImgPath, parStart, parEnd, parSubDT).FirstOrDefaultAsync());
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
