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