public JsonResult edit_form(string asset, string wcoa, string ocoa)
{
List <string> message = new List <string>();
using (var db = new db_a094d4_demoEntities1())
{
try
{
var production = new production_log();
production.wcoa = wcoa;
production.ocoa = ocoa;
production.ictags = asset;
db.production_log.Attach(production);
var entry = db.Entry(production);
entry.Property(e => e.ictags).IsModified = true;
entry.Property(e => e.ocoa).IsModified = true;
// other changed properties
db.SaveChanges();
message.Add("Info Has Updated for Asset ");
}
catch (Exception e)
{
message.Add(e.InnerException.InnerException.Message);
}
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
public JsonResult add_asset(string pallet_name, string asset)
{
var message = "";
try
{
using (var add = new db_a094d4_demoEntities1())
{
add.Database.ExecuteSqlCommand(
"INSERT INTO pallet (ictags, pallet_name) VALUES('" + asset + "','" + pallet_name + "') ON DUPLICATE KEY UPDATE ictags = '" + asset + "', pallet_name = '" + pallet_name + "'");
}
message = asset + " has been added to " + pallet_name;
}
catch (Exception e) {
message = e.Message;
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public JsonResult edit_form(string asset, string time, string serial, string make, string cpu, string ram, string hdd, string model)
{
List <string> message = new List <string>();
using (var db = new db_a094d4_demoEntities1()) {
try
{
var discovery = new discovery();
discovery.serial = serial;
discovery.brand = make;
discovery.cpu = cpu;
discovery.ram = ram;
discovery.hdd = hdd;
discovery.model = model;
discovery.ictag = int.Parse(asset);
db.discovery.Attach(discovery);
var entry = db.Entry(discovery);
entry.Property(e => e.serial).IsModified = true;
entry.Property(e => e.brand).IsModified = true;
entry.Property(e => e.cpu).IsModified = true;
entry.Property(e => e.ram).IsModified = true;
entry.Property(e => e.hdd).IsModified = true;
entry.Property(e => e.model).IsModified = true;
// other changed properties
db.SaveChanges();
message.Add("Info Has Updated for Asset ");
}
catch (Exception e) {
message.Add(e.InnerException.InnerException.Message);
}
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
public JsonResult delete_record(string ictag)
{
string message = "";
try
{
using (var remove = new db_a094d4_demoEntities1())
{
remove.Database.ExecuteSqlCommand(
"Delete from rediscovery where ictag = '" + ictag + "'");
}
message = ictag + " Has Been Deleted";
}
catch (Exception e)
{
message = e.Message;
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public JsonResult mark_pallet(string pallet_name)
{
string message = "";
//remove any pallet name from para
try
{
using (var remove = new db_a094d4_demoEntities1())
{
remove.Database.ExecuteSqlCommand(
"Update pallet set type = 'shipped' where pallet_name = '" + pallet_name + "'");
}
message = pallet_name + " Has Been Mark as Shipped You can View it at Shipped Tab";
}
catch (Exception e)
{
message = e.Message;
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public JsonResult remove_pallet(string pallet_name)
{
string message = "";
//remove any pallet name from para
try
{
using (var remove = new db_a094d4_demoEntities1())
{
remove.Database.ExecuteSqlCommand(
"Delete from pallet where pallet_name = '" + pallet_name + "'");
}
message = pallet_name + " Has Been Deleted";
}
catch (Exception e)
{
message = e.Message;
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public JsonResult edit_form(int asset, string serial, string model, string refurbisher, string sku)
{
List <string> message = new List <string>();
using (var db = new db_a094d4_demoEntities1())
{
try
{
var redis = new rediscovery();
redis.ictag = asset;
redis.pallet = sku;
redis.serial = serial;
redis.model = model;
redis.refurbisher = refurbisher;
db.rediscovery.Attach(redis);
var entry = db.Entry(redis);
entry.Property(e => e.pallet).IsModified = true;
entry.Property(e => e.model).IsModified = true;
entry.Property(e => e.serial).IsModified = true;
entry.Property(e => e.refurbisher).IsModified = true;
// other changed properties
db.SaveChanges();
message.Add("Info Has Updated for Asset ");
}
catch (Exception e)
{
message.Add(e.InnerException.InnerException.Message);
}
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
public JsonResult create(string pallet_name, string assets, string note)
{
List <string> message = new List <string>();
var current_pallet = (from d in db.pallet where d.pallet_name == pallet_name select d).ToList();
if (current_pallet.Count > 0)
{
message.Add("Pallet Name Exisited");
}
else
{
List <string> list = new List <string>(
assets.Split(new string[] { "\r\n" },
StringSplitOptions.RemoveEmptyEntries));
foreach (var asset in list)
{
try
{
using (var add = new db_a094d4_demoEntities1())
{
add.Database.ExecuteSqlCommand(
"INSERT INTO pallet (ictags, pallet_name,note) VALUES('" + asset + "','" + pallet_name + "','" + note + "') ON DUPLICATE KEY UPDATE ictags = '" + asset + "', pallet_name = '" + pallet_name + "', note = '" + note + "'");
message.Add(asset + " has been added to " + pallet_name);
}
}
catch (Exception e)
{
message.Add(e.InnerException.InnerException.Message);
}
}
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public JsonResult reset_asset(string asset)
{
string message = "";
try
{
using (var db = new db_a094d4_demoEntities1())
{
db.Database.ExecuteSqlCommand(
"Update asset_tag_counter set count = '" + asset + "'");
}
message = "Asset Tag Has Been Reset to " + asset;
}
catch (Exception e)
{
message = e.Message;
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public JsonResult import_coa(List <COAs_model.Class1> input)
{
List <string> message = new List <string>();
using (db = new db_a094d4_demoEntities1())
{
foreach (var item in input)
{
try {
var coas = new coas();
coas.COA_ID = item.COAID;
coas.License_Type = item.LicenseType;
coas.PDF_language = item.PDFlanguage;
coas.Pre_existing_COA_ID = item.PreexistingCOAID;
coas.PK = item.ProductKey;
coas.Product_Name = item.ProductName;
coas.Recipient_City = item.RecipientCity;
coas.Recipient_Country___Region = item.RecipientCountryRegion;
coas.Recipient_Organization_Name = item.RecipientOrganizationName;
coas.Recipient_Type = item.RecipientType;
coas.Request_ID = item.RequestID;
db.coas.Add(coas);
db.SaveChanges();
message.Add(item.COAID + " Has Added to Database");
}
catch (Exception e) {
message.Add(e.InnerException.InnerException.Message);
}
}
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
public JsonResult delete_station(string station_name)
{
var message = new List <string>();
try
{
using (var remove = new db_a094d4_demoEntities1())
{
remove.Database.ExecuteSqlCommand(
"Delete from station_setting where station_dropdown_value = '" + station_name + "'");
}
message.Add(station_name + " Has Been Deleted");
}
catch (Exception e)
{
message.Add(e.InnerException.InnerException.Message);
}
return(Json(new { message = message }, JsonRequestBehavior.AllowGet));
}
public string add_station_db(string prefix, string station_name)
{
string message = "";
try
{
using (db = new db_a094d4_demoEntities1())
{
var station = new station_setting();
station.station_name = station_name;
station.station_dropdown_value = prefix + station_name;
db.station_setting.Add(station);
db.SaveChanges();
message = (prefix + station_name + " has been added to station list");
}
}
catch (Exception e)
{
message = (e.InnerException.InnerException.Message);
}
return(message);
}
