public JsonResult submit_data(int[] input, string pallet_name)
{
List <string> message = new List <string>();
for (int i = 0; i < input.Length; i++)
{
try
{
using (var tran = new TransactionScope())
{
var entry = new pallet();
entry.ictags = input[i];
entry.pallet_name = pallet_name;
db.pallet.Add(entry);
tran.Complete();
message.Add(input[i] + "Successfully Added to Pallet: " + pallet_name);
}
db.SaveChanges();
}
catch (Exception e)
{
message.Add(input[i] + ":" + e.InnerException.InnerException.Message);
continue;
}
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmed(int id)
{
pallet pallet = db.pallet.Find(id);
db.pallet.Remove(pallet);
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 = "ictags,pallet_name,type,note")] pallet pallet)
{
if (ModelState.IsValid)
{
db.Entry(pallet).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pallet));
}
public ActionResult Create([Bind(Include = "ictags,pallet_name,type,note")] pallet pallet)
{
if (ModelState.IsValid)
{
db.pallet.Add(pallet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pallet));
}
private static PalletProperties LoadPalletById(Document doc, List <pallet> listPallet, string sid)
{
pallet palletItem = listPallet.Find(delegate(pallet p) { return(p.id == sid); });
if (null == palletItem)
{
return(null);
}
else
{
// dimensions
double[] dimensions = palletItem.dimensions.ToArray();
// type
string typeName = string.Empty;
switch (palletItem.type)
{
case palletType.BLOCK: typeName = "BLOCK"; break;
case palletType.EUR: typeName = "EUR"; break;
case palletType.EUR2: typeName = "EUR2"; break;
case palletType.EUR3: typeName = "EUR3"; break;
case palletType.EUR6: typeName = "EUR6"; break;
case palletType.GMA: typeName = "GMA"; break;
case palletType.STANDARD_UK: typeName = "STANDARD_UK"; break;
default:
throw new Exception("Pallet with id = {0} has an unknown pallet type");
}
// instantiate pallet properties
PalletProperties palletProperties = new PalletProperties(doc, typeName, dimensions[0], dimensions[1], dimensions[2]);
// name
palletProperties.Name = palletItem.name;
// description
palletProperties.Description = palletItem.description;
// color
palletProperties.Color = System.Drawing.Color.FromArgb((int)palletItem.color[0], (int)palletItem.color[1], (int)palletItem.color[2], (int)palletItem.color[3]);
// weight
palletProperties.Weight = palletItem.weight;
// insert in list
if (null != doc)
{
doc.AddType(palletProperties);
}
return(palletProperties);
}
}
// GET: pallets/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
pallet pallet = db.pallet.Find(id);
if (pallet == null)
{
return(HttpNotFound());
}
return(View(pallet));
}
public JsonResult insert_pallet(string pallet, string[] assets, string note)
{
// assets = assets.Where(x => !string.IsNullOrEmpty(x)).ToArray();
// assets = assets.Distinct().ToArray();
string message = "";
if (String.IsNullOrEmpty(note))
{
note = "";
}
for (int i = 0; i < assets.Length; i++)
{
try
{
using (var tran = new TransactionScope())
{
var entry = new pallet();
entry.ictags = int.Parse(assets[i]);
entry.pallet_name = pallet;
entry.note = note;
db.pallet.Add(entry);
tran.Complete();
}
}
catch (Exception e)
{
message += assets[i] + ":" + e.InnerException.InnerException.Message;
continue;
}
}
db.SaveChanges();
message += "Complete";
return(Json(message, JsonRequestBehavior.AllowGet));
}
private void takedownpallet(pallet pal)
{
pal.Isplacede = false;
managercontext.Update(pal);
managercontext.SaveChanges();
}
