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));
}
