public ActionResult DeleteConfirmed(string id)
{
pallet_master pallet_master = db.pallet_master.Find(id);
db.pallet_master.Remove(pallet_master);
db.pallet.RemoveRange(db.pallet.Where(c => c.pallet_name == id));
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult bulk(HttpPostedFileBase FileUpload, string pallet_name)
{
string path = "";
DataTable dt = new DataTable();
//check we have a file
if (FileUpload.ContentLength > 0)
{
//Workout our file path
string fileName = Path.GetFileName(FileUpload.FileName);
path = Path.Combine(Server.MapPath("~/App_Data/uploads"), fileName);
try
{
FileUpload.SaveAs(path);
List <string> temp_line = new List <string>();
using (StringReader reader = new StringReader(System.IO.File.ReadAllText(path)))
{
string line = null;
while ((line = reader.ReadLine()) != null)
{
if (!temp_line.Contains(line))
{
temp_line.Add(line);
}
}
}
using (StreamWriter writer = new StreamWriter(System.IO.File.Open(path, FileMode.Create)))
foreach (string r in temp_line)
{
var updateQuery = new pallet();
updateQuery.ictags = int.Parse(r);
updateQuery.pallet_name = pallet_name;
db.pallet.Add(updateQuery);
}
var palletmaster = new pallet_master();
palletmaster.pallet_id = pallet_name;
db.pallet_master.Add(palletmaster);
db.SaveChanges();
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
catch (Exception ex)
{
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
//Catch errors
TempData["message"] = ex.ToString();
}
}
return(RedirectToAction("bulk"));
}
public ActionResult Edit([Bind(Include = "pallet_id")] pallet_master pallet_master)
{
if (ModelState.IsValid)
{
db.Entry(pallet_master).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pallet_master));
}
public ActionResult Create([Bind(Include = "pallet_id")] pallet_master pallet_master)
{
if (ModelState.IsValid)
{
db.pallet_master.Add(pallet_master);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pallet_master));
}
// GET: pallet_master/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
pallet_master pallet_master = db.pallet_master.Find(id);
if (pallet_master == null)
{
return(HttpNotFound());
}
return(View(pallet_master));
}
public JsonResult create_pallet(string pallet_name)
{
string message = "";
var entry = new pallet_master();
entry.pallet_id = pallet_name;
db.pallet_master.Add(entry);
try
{
db.SaveChanges();
message = "pallet " + pallet_name + " created.";
}
catch (Exception e)
{
message = e.InnerException.InnerException.Message;
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
