public async Task<ActionResult> Insert(AdvertismentModal advertise)
        {
            var dbHelpre = DBHelper.Instance;
            dbHelpre.BeginTransaction();

            return await Task.Run(() =>
            {
                try
                {
                    bool IsValid = false;
                    ViewBag.Message = "Insert New Avertisment.";

                    if (ModelState.IsValid)
                    {
                        var objAdvertise = new Advertisment();

                        objAdvertise.Heading = advertise.Heading.Trim();
                        objAdvertise.WebUrl = advertise.WebUrl.Trim();
                        objAdvertise.WebLink = advertise.WebLink.Trim();
                        objAdvertise.ShortDesc = advertise.ShortDesc.Trim();
                        objAdvertise.DisplayOrder = advertise.DisplayOrder;
                        objAdvertise.IsActive = advertise.IsActive ? 1 : 0;
                        objAdvertise.IsApproved = advertise.IsApproved ? 1 : 0;
                        objAdvertise.Position = (Int32)Position.PageRight;
                        objAdvertise.AdvertismentType = (Int32)AdvertismentType.TopNewsAdd;

                        var fileName = string.Empty;
                        if (advertise.Image != null && advertise.Image.ContentLength > 0)
                        {
                            fileName = new Random().Next(1000000000).ToString() + Path.GetFileName(advertise.Image.FileName);
                            objAdvertise.ImgUrl = ImagePath.TopTenAdvertisment + "/" + fileName;
                        }

                        AdvertismentDB.Instance.Insert(ref dbHelpre, objAdvertise);

                        if (!string.IsNullOrEmpty(fileName))
                        {
                            IsValid = SaveImage(ImagePath.TopTenAdvertisment, fileName, advertise.Image);
                        }

                        if (!IsValid)
                        {
                            dbHelpre.RollbackTransaction();
                            ModelState.AddModelError("INSERT", "Oops ! There is some error.");
                            ViewBag.Message = "Oops ! There is some error.";
                        }

                        if (IsValid)
                        {
                            dbHelpre.CommitTransaction();
                            ViewBag.Message = "Advertise Successfully Ceated..";
                            ModelState.Clear();
                            advertise = new AdvertismentModal();
                        }
                    }
                    else
                    {
                        //ModelState.AddModelError("INSERT", "Oops ! There is some error.");
                        ViewBag.Message = "Oops ! There is some error.";
                    }
                }
                catch (Exception ex)
                {
                    dbHelpre.RollbackTransaction();
                    throw ex;
                }
                finally
                {
                    dbHelpre.ClearAllParameters();
                    dbHelpre.CloseConnection();
                    dbHelpre.Dispose();
                }

                return View(advertise);
            });

        }
        public async Task<ActionResult> Update(string AdvertismentID)
        {
            return await Task.Run(() =>
            {
                var advertise = new AdvertismentModal();
                try
                {
                    ViewBag.Message = "Modify Selected Avertisment.";

                    if (ModelState.IsValid)
                    {
                        var objAdvertise = AdvertismentBL.Instance.Select(AdvertismentID);
                        if (objAdvertise != null)
                        {
                            advertise.ImgUrl = objAdvertise.ImgUrl;
                            advertise.Heading = objAdvertise.Heading;
                            advertise.WebUrl = objAdvertise.WebUrl;
                            advertise.WebLink = objAdvertise.WebLink;
                            advertise.ShortDesc = objAdvertise.ShortDesc;
                            advertise.DisplayOrder = objAdvertise.DisplayOrder;
                            advertise.IsActive = objAdvertise.IsActive == 1 ? true : false;
                            advertise.IsApproved = objAdvertise.IsApproved == 1 ? true : false;
                            //advertise.AdvertismentType = (Int32)AdvertismentType.TopNewsAdd;
                        }
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }

                return View(advertise);
            });

        }