public ActionResult AddNewFile(StuffInStorage Add) { if (Session["Username"] == null && Session["Password"] == null) { return(RedirectToAction("Index", "Admin", new { area = "" })); } else { if (ModelState.IsValid) { StuffsInStorages AddStuffInStorage = new StuffsInStorages(); AddStuffInStorage.Name = Add.Name; HttpPostedFileBase File = Request.Files["User_File"]; if (File.ContentLength > 0) { string ext = File.FileName.Substring(File.FileName.LastIndexOf(".")); string imgName = DateTime.Now.Ticks + ext; string webpath = "~/p_storage/" + imgName; File.SaveAs(Request.MapPath(webpath)); AddStuffInStorage.User_File = imgName; } AddStuffInStorage.Date = DateTime.Today.ToString("dd-MM-yyyy"); AddStuffInStorage.Month = DateTime.Today.ToString("MMM"); AddStuffInStorage.Year = DateTime.Today.ToString("yyyy"); AddStuffInStorage.Time = DateTime.Now.ToString("HH:mm:ss"); new Cateloge().AddStuffInStorage(AddStuffInStorage); TempData["Msg"] = "New Item Have Added Successfully"; return(RedirectToAction("Index")); } return(RedirectToAction("Index")); } }
public ActionResult Edit(StuffInStorage Update, int id) { if (Session["Username"] == null && Session["Password"] == null) { return(RedirectToAction("Index", "Admin", new { area = "" })); } else { if (ModelState.IsValid) { StuffsInStorages UpdateStuffInStorage = new StuffsInStorages(); UpdateStuffInStorage.Name = Update.Name; HttpPostedFileBase File = Request.Files["User_File"]; if (File.ContentLength > 0) { string ext = File.FileName.Substring(File.FileName.LastIndexOf(".")); string imgName = DateTime.Now.Ticks + ext; string webpath = "~/p_storage/" + imgName; File.SaveAs(Request.MapPath(webpath)); UpdateStuffInStorage.User_File = imgName; new Cateloge().UpdateStuffInStorage_file(UpdateStuffInStorage, id); } else { new Cateloge().UpdateStuffInStorage(UpdateStuffInStorage, id); } TempData["Msg"] = "Item Have Updated Successfully"; return(RedirectToAction("Index")); } return(View(Update)); } }
private List <StuffsInStorages> fetchStuffsInStorages(SqlCommand cmd) { SqlConnection con = cmd.Connection; List <StuffsInStorages> stuffsinstorages = null; con.Open(); using (con) { SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { stuffsinstorages = new List <StuffsInStorages>(); while (dr.Read()) { StuffsInStorages ss = new StuffsInStorages(); ss.db_Id = Convert.ToString(dr["id"]); ss.Name = Convert.ToString(dr["name"]); ss.User_File = Convert.ToString(dr["user_file"]); stuffsinstorages.Add(ss); } stuffsinstorages.TrimExcess(); } } return(stuffsinstorages); }
public void UpdateStuffInStorage(StuffsInStorages uss, int id) { SqlCommand cmd = new SqlCommand("Update storage Set name=@Name Where id=@Id", DALUtil.getConnection()); cmd.Parameters.AddWithValue("@Id", id); cmd.Parameters.AddWithValue("@Name", (uss.Name == null) ? Convert.DBNull : uss.Name); addstuffinstorage(cmd); }
public void AddStuffInStorage(StuffsInStorages ss) { SqlCommand cmd = new SqlCommand("INSERT into storage (name,user_file,date,month,year,time) VALUES (@Name,@File,@Date,@Month,@Year,@Time)", DALUtil.getConnection()); cmd.Parameters.AddWithValue("@Name", (ss.Name == null) ? Convert.DBNull : ss.Name); cmd.Parameters.AddWithValue("@File", (ss.User_File == null) ? Convert.DBNull : ss.User_File); cmd.Parameters.AddWithValue("@Date", (ss.Date == null) ? Convert.DBNull : ss.Date); cmd.Parameters.AddWithValue("@Month", (ss.Month == null) ? Convert.DBNull : ss.Month); cmd.Parameters.AddWithValue("@Year", (ss.Year == null) ? Convert.DBNull : ss.Year); cmd.Parameters.AddWithValue("@Time", (ss.Time == null) ? Convert.DBNull : ss.Time); addstuffinstorage(cmd); }
public void UpdateStuffInStorage_file(StuffsInStorages uss, int id) { new AddAndUpdtStuffInStorageDAL().UpdateStuffInStorage_file(uss, id); }
public void AddStuffInStorage(StuffsInStorages ss) { new AddAndUpdtStuffInStorageDAL().AddStuffInStorage(ss); }