public ActionResult AddOrEdit(BannerViewModel banner) { if (banner.BannerId == 0) { HttpPostedFileBase fup = Request.Files["Photo"]; tblBanner tb = new tblBanner(); tb.HostelId = banner.HostelId; tb.Photo = fup.FileName; if (fup.ContentLength > 0) { fup.SaveAs(Path.Combine(Server.MapPath("~/Images/Banner/"), fup.FileName)); } db.tblBanners.Add(tb); db.SaveChanges(); return(RedirectToAction("Banner", "Admin")); } else { HttpPostedFileBase fup = Request.Files["Photo"]; tblBanner tb = db.tblBanners.Where(x => x.BannerId == banner.BannerId).FirstOrDefault(); tb.HostelId = banner.HostelId; if (fup.ContentLength > 0) { System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/Banner/"), tb.Photo)); tb.Photo = fup.FileName; fup.SaveAs(Path.Combine(Server.MapPath("~/Images/Banner/"), fup.FileName)); } db.SaveChanges(); return(RedirectToAction("Banner", "Admin")); } }
public void LoadBanner() { objBanner = new tblBanner(); rpBanner.DataSource = objBanner.LoadBanner(); rpBanner.DataBind(); objBanner = null; }
public ActionResult Delete(int id) { uid = id; tblBanner tb = _db.tblBanners.Where(u => u.BannerId == id).FirstOrDefault(); return(View(tb)); }
public ActionResult Edit(tblBanner bd) { tblBanner tb = _db.tblBanners.Where(u => u.BannerId == bd.BannerId).FirstOrDefault(); tb.Header = bd.Header; tb.Caption = bd.Caption; HttpPostedFileBase fup = Request.Files["Path"]; if (fup != null) { if (fup.FileName != "") { System.IO.File.Delete(Server.MapPath("~/Images/Banners/" + bd.Path)); tb.Path = fup.FileName; fup.SaveAs(Server.MapPath("~/Images/Banners/" + fup.FileName)); } else { tb.Path = bd.Path; } } if (_db.SaveChanges() > 0) { return(RedirectToAction("Index")); } return(View()); }
public ActionResult Delete_Post(int id) { tblBanner tb = _db.tblBanners.Where(u => u.BannerId == id).FirstOrDefault(); _db.tblBanners.Remove(tb); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete() { tblBanner tb = _db.tblBanners.Where(u => u.BannerId == uid).FirstOrDefault(); System.IO.File.Delete(Server.MapPath("~/Images/Banners/" + tb.Path)); _db.tblBanners.Remove(tb); _db.SaveChanges(); return(RedirectToAction("Index", "Banner")); }
public IHttpActionResult DeletetblBanner(int id) { tblBanner tblBanner = new tblBanner(); tblBanner = db.tblBanners.Find(id); db.tblBanners.Remove(tblBanner); db.SaveChanges(); return(Ok(new { code = 0, message = "Banner deleted successfully!" })); }
public ActionResult Delete_Post(BannerViewModel bvmm) { tblBanner tb = new tblBanner(); BannerViewModel bvm = new BannerViewModel(); tb.BannerId = bvm.BannerId; _db.tblBanners.Remove(tb); _db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult GettblBanner(int id) { tblBanner tblBanner = db.tblBanners.Find(id); if (tblBanner == null) { return(NotFound()); } return(Ok(tblBanner)); }
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (!string.IsNullOrEmpty(e.CommandArgument.ToString())) { objCommon = new clsCommon(); hdnPKID.Value = e.CommandArgument.ToString(); if (e.CommandName == "Up") { LinkButton inkButton = (LinkButton)e.CommandSource; GridViewRow drCurrent = (GridViewRow)inkButton.Parent.Parent; if (drCurrent.RowIndex > 0) { GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex - 1]; objCommon.SetDisplayOrder("tblBanner", tblBanner.ColumnNames.AppBannerID, tblBanner.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[1]); LoadDataGrid(false, false); objCommon = null; } } else if (e.CommandName == "Down") { LinkButton lnkButton = (LinkButton)e.CommandSource; GridViewRow drCurrent = (GridViewRow)lnkButton.Parent.Parent; if (drCurrent.RowIndex < dgvGridView.Rows.Count - 1) { GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex + 1]; objCommon.SetDisplayOrder("tblBanner", tblBanner.ColumnNames.AppBannerID, tblBanner.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[1]); LoadDataGrid(false, false); objCommon = null; } } else if (e.CommandName == "IsActive") { objBanner = new tblBanner(); if (objBanner.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { if (objBanner.AppIsActive == true) { objBanner.AppIsActive = false; } else if (objBanner.AppIsActive == false) { objBanner.AppIsActive = true; } objBanner.Save(); LoadDataGrid(false, false, "", ""); } objBanner = null; } } }
private bool SaveData() { if (FileUploadImg.HasFile) { objClsCommon = new clsCommon(); objBanner = new tblBanner(); if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objBanner.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); } else { objBanner.AddNew(); objBanner.AppDisplayOrder = objClsCommon.GetNextDisplayOrder("tblBanner", tblBanner.ColumnNames.AppDisplayOrder); } objBanner.AppTitle = txtBannerTitle.Text; objBanner.AppIsActive = chkIsActive.Checked; objBanner.AppUrl = txtappUrl.Text; objBanner.AppDescription = txtDescription.Text; if (FileUploadImg.HasFile) { string strError = ""; string Time = Convert.ToString(DateTime.Now.Month) + Convert.ToString(DateTime.Now.Day) + Convert.ToString(DateTime.Now.Year) + Convert.ToString(DateTime.Now.Hour) + Convert.ToString(DateTime.Now.Minute) + Convert.ToString(DateTime.Now.Second); string strPath = objClsCommon.FileUpload_Images(FileUploadImg.PostedFile, txtBannerTitle.Text.Trim().Replace(" ", "_") + "_" + Time, "Uploads/Banner/", ref strError, 0, objBanner.s_AppImage, false, 600, 1600); if (strError == "") { objBanner.AppImage = strPath; } else { DInfo.ShowMessage(strError, Enums.MessageType.Error); return(false); } } objBanner.Save(); iBannerID = objBanner.AppBannerID; objBanner = null; objClsCommon = null; return(true); } else { DInfo.ShowMessage("Select Image First", Enums.MessageType.Error); return(false); } }
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "") { objBanner = new tblBanner(); objDataTable = objBanner.LoadGridData(ddlFields.SelectedValue, txtSearch.Text.Trim()); //'Reset PageIndex of gridviews if (IsResetPageIndex) { if (dgvGridView.PageCount > 0) { dgvGridView.PageIndex = 0; } } dgvGridView.DataSource = null; dgvGridView.DataBind(); lblCount.Text = 0.ToString(); hdnSelectedIDs.Value = ""; //'Check for data into datatable if (objDataTable.Rows.Count <= 0) { DInfo.ShowMessage("No data found", Enums.MessageType.Information); return; } else { if (ddlPerPage.SelectedItem.Text.ToLower() == "all") { dgvGridView.AllowPaging = false; } else { dgvGridView.AllowPaging = true; dgvGridView.PageSize = Convert.ToInt32(ddlPerPage.SelectedItem.Text); } lblCount.Text = objDataTable.Rows.Count.ToString(); objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort); dgvGridView.DataSource = objDataTable; dgvGridView.DataBind(); } objBanner = null; }
public ActionResult Create(tblBanner tb) { HttpPostedFileBase fup = Request.Files["Path"]; if (fup != null) { tb.Path = fup.FileName; fup.SaveAs(Server.MapPath("~/Images/Banners/" + fup.FileName)); } _db.tblBanners.Add(tb); if (_db.SaveChanges() > 0) { return(RedirectToAction("Index")); } return(View()); }
public ActionResult AddOrEdit(int id = 0) { ViewBag.Hostels = db.tblHostels.ToList(); if (id == 0) { return(View("AddOrEdit")); } else { tblBanner tb = db.tblBanners.Where(x => x.BannerId == id).FirstOrDefault(); BannerViewModel banner = new BannerViewModel(); banner.BannerId = tb.BannerId; banner.HostelId = tb.HostelId; banner.HostelName = tb.tblHostel.HostelName; banner.Photo = tb.Photo; return(View("AddOrEdit", banner)); } }
private void SetValuesToControls() { if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objBanner = new tblBanner(); if (objBanner.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { txtBannerTitle.Text = objBanner.AppTitle; chkIsActive.Checked = objBanner.AppIsActive; txtappUrl.Text = objBanner.AppUrl; txtDescription.Text = objBanner.AppDescription; if (objBanner.AppImage != "") { img.ImageUrl = objBanner.AppImage; } } objBanner = null; } }
public ActionResult Create(BannerViewModel bvm) { tblBanner tb = new tblBanner(); tb.Title = bvm.Title; tb.HeadingOne = bvm.HeadingOne; tb.HeadingTwo = bvm.HeadingTwo; tb.Description = bvm.Description; HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { tb.Photo = fup.FileName; fup.SaveAs(Server.MapPath("~/images/Banner/" + fup.FileName)); } _db.tblBanners.Add(tb); _db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult PosttblBanner(tblBanner tblBanner) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblBanners.Add(tblBanner); db.SaveChanges(); return(Ok(new { code = 0, data = "Banner added successfully." })); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IHttpActionResult PuttblBanner(int id, tblBanner tblBanner) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (tblBanner == null) { throw new ArgumentNullException("tblBanner"); } var data = db.tblCategories.Where(w => w.ID == tblBanner.ID).Count();//.FirstOrDefault(); if (data >= 0) { tblBanner banner = new tblBanner(); banner.ID = tblBanner.ID; banner.ImageName = tblBanner.ImageName; banner.ImagePath = tblBanner.ImagePath; banner.Created = System.DateTime.Now; banner.CreatedBy = tblBanner.CreatedBy; banner.Updated = System.DateTime.Now; banner.UpdatedBy = tblBanner.UpdatedBy; banner.Active = Convert.ToBoolean(tblBanner.Active); db.Entry(banner).State = EntityState.Modified; db.SaveChanges(); return(Ok(new { code = 0, data = "Banner updated successfully." })); } else { return(Ok(new { code = 1, data = "Banner not found." })); } } catch (Exception ex) { return(InternalServerError(ex)); } }
public ActionResult Delete(int id, string name = "") { if (name == "News") { tblNew news = db.tblNews.Where(x => x.NewsId == id).FirstOrDefault(); System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/News/"), news.Photo)); db.tblNews.Remove(news); db.SaveChanges(); return(RedirectToAction("News", "Admin")); } if (name == "Banner") { tblBanner add = db.tblBanners.Where(x => x.BannerId == id).FirstOrDefault(); System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/Banner/"), add.Photo)); db.tblBanners.Remove(add); db.SaveChanges(); return(RedirectToAction("Banner", "Admin")); } return(RedirectToAction("Index", "Opening")); }
public ActionResult DeleteBanner(int id) { if (Session["StudioID"] == null && Session["StudioName"] == null && Session["StudioPhoneNo"] == null) { return(RedirectToAction("Login", "Login")); } try { tblBanner tblBanner = db.tblBanners.Find(id); db.tblBanners.Remove(tblBanner); db.SaveChanges(); string path = Server.MapPath("~/BannerImages/" + tblBanner.BannerImage); FileInfo delfile = new FileInfo(path); delfile.Delete(); return(Json(new { success = true, message = "Record deleted successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = "Record not deleted" + ex.Message }, JsonRequestBehavior.AllowGet)); } }
private bool Delete(int intPKID) { bool retval = false; objBanner = new tblBanner(); var _with1 = objBanner; if (_with1.LoadByPrimaryKey(intPKID)) { if (System.IO.File.Exists(Server.MapPath(objBanner.s_AppImage))) { System.IO.File.Delete(Server.MapPath(objBanner.s_AppImage)); } _with1.MarkAsDeleted(); _with1.Save(); } retval = true; objBanner = null; return(retval); }
public ActionResult Edit(int id) { tblBanner tb = _db.tblBanners.Where(u => u.BannerId == id).FirstOrDefault(); return(View(tb)); }
public ActionResult InsertBanner() { if (Session["StudioID"] == null && Session["StudioName"] == null && Session["StudioPhoneNo"] == null) { return(RedirectToAction("Login", "Login")); } try { if (ModelState.IsValid) { tblBanner newBanner = new tblBanner(); newBanner.BannerHeading = Request.Form["BannerHeading"]; newBanner.BannerDescription = Request.Form["BannerDescription"]; if (ModelState.IsValid) { int fileSize = 0; string fileName = string.Empty; string mimeType = string.Empty; System.IO.Stream fileContent; if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; fileSize = file.ContentLength; fileName = file.FileName; mimeType = file.ContentType; fileContent = file.InputStream; if (mimeType.ToLower() != "image/jpeg" && mimeType.ToLower() != "image/jpg") { return(Json(new { Formatwarning = true, message = "Banner Image format must be JPEG or JPG" }, JsonRequestBehavior.AllowGet)); } if (fileSize > 2000000) { return(Json(new { Sizewarning = true, message = "Size must be less than 2 MB." }, JsonRequestBehavior.AllowGet)); } #region Save And compress file //To save file, use SaveAs method file.SaveAs(Server.MapPath("~/BannerImages/") + fileName); newBanner.BannerImage = fileName; #endregion } else { return(Json(new { ImageEmpty = true, message = "Image is not selected." }, JsonRequestBehavior.AllowGet)); } } db.tblBanners.Add(newBanner); db.SaveChanges(); } } catch (Exception ex) { return(Json(new { success = false, message = "Record not Inserted" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = true, message = "Record inserted" }, JsonRequestBehavior.AllowGet)); }