public bool editConsumable(ConsumableMaterialModel item)
{
string connString = ConfigurationManager.ConnectionStrings["consumable"].ConnectionString;
OleDbConnection oledb = new OleDbConnection(connString);
try
{
oledb.Open();
OleDbCommand command = new OleDbCommand("UPDATE [Sheet1$] SET [耗材名稱] = '" + item.materialName + "',[ECS系統料號] = '" + item.materialECSCode + "',[ECS名稱] = '" + item.materialECSName + "',[型號] = '" + item.materialSpecification + "',[單位] = '" + item.materialUnit + "',[存放位置] = '" + item.materialStorageLocation + "',[適用機種] = '" + item.materialKind + "',[廠家] = '" + item.materialSupplier + "',[參考價值] = '" + item.materialReferenceValue + "',[購買] = '" + item.materialTimeCanGet + "',[請購數量] = '" + item.materialQuantity + "',[安全] = '" + item.materialSafety + "',[領用數量] = '" + item.materialNumberRecipient + "',[退庫良品數量] = '" + item.materialGoodNumberReturn + "',[退庫不良數量] = '" + item.materialBadNumberReturn + "',[庫存] = '" + (Int32.Parse(item.materialQuantity) - Int32.Parse(item.materialNumberRecipient) + Int32.Parse(item.materialGoodNumberReturn)).ToString() + "',[備註] = '" + item.materialRemark + "',[ImagePath] = '" + item.materialImagePath + "' WHERE [耗材料號] = '" + item.materialCode + "'", oledb);
int result = command.ExecuteNonQuery();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
finally
{
oledb.Close();
}
}
public ActionResult AddOrEditConsumable(string id)
{
ConsumableMaterialModel emp = new ConsumableMaterialModel();
JSONReadWrite ex = new JSONReadWrite();
emp = ex.getConsumableById(id);
return(View(emp));
}
public ActionResult AddOrEditConsumable(ConsumableMaterialModel model)
{
try
{
if (Int32.Parse(model.materialNumberRecipient) > Int32.Parse(model.materialQuantity))
{
return(Json(new { success = false, message = "Value of 領用數量 cannot be greqter than 請購數量" }, JsonRequestBehavior.AllowGet));
}
if (Int32.Parse(model.materialGoodNumberReturn) > Int32.Parse(model.materialNumberRecipient))
{
return(Json(new { success = false, message = "Value of 退庫良品數量 cannot be greqter than 領用數量" }, JsonRequestBehavior.AllowGet));
}
if (Int32.Parse(model.materialBadNumberReturn) > Int32.Parse(model.materialNumberRecipient))
{
return(Json(new { success = false, message = "Value of 退庫不良數量 cannot be greqter than 領用數量" }, JsonRequestBehavior.AllowGet));
}
if (model.ImageUpload != null && model.materialImagePath != null)
{
string fileName = Path.GetFileNameWithoutExtension(model.ImageUpload.FileName);
string extension = Path.GetExtension(model.ImageUpload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
model.materialImagePath = "~/AppFiles/Images/" + fileName;
model.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName));
}
JSONReadWrite ex = new JSONReadWrite();
if (!ex.checkCodeExistOrNot(model.materialCode))
{
var result = ex.addNewConsumable(model);
if (result)
{
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAlll", GetAllConsumableMaterial()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Add new Fail" }, JsonRequestBehavior.AllowGet));
}
}
else
{
var result = ex.editConsumable(model);
if (result)
{
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAlll", GetAllConsumableMaterial()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Edit Fail" }, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public bool addNewConsumable(ConsumableMaterialModel prod)
{
var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/AppFiles/Database/ComsumableItem.json"));
string jsonResult = Read(path);
List <ConsumableMaterialModel> list = JsonConvert.DeserializeObject <List <ConsumableMaterialModel> >(jsonResult);
list.Add(prod);
string jSONString = JsonConvert.SerializeObject(list, Formatting.Indented);
Write(path, jSONString);
return(true);
}
public ConsumableMaterialModel getConsumableById(string id)
{
ConsumableMaterialModel model = new ConsumableMaterialModel();
string connString = ConfigurationManager.ConnectionStrings["consumable"].ConnectionString;
OleDbConnection oledb = new OleDbConnection(connString);
try
{
oledb.Open();
OleDbCommand command = new OleDbCommand("SELECT * FROM [Sheet1$] WHERE [耗材料號] = '" + id + "'", oledb);
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = command;
DataSet ds = new DataSet();
adapter.Fill(ds);
model.materialCode = ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim();
model.materialName = ds.Tables[0].Rows[0].ItemArray[1].ToString();
model.materialECSCode = ds.Tables[0].Rows[0].ItemArray[2].ToString();
model.materialECSName = ds.Tables[0].Rows[0].ItemArray[3].ToString();
model.materialSpecification = ds.Tables[0].Rows[0].ItemArray[4].ToString();
model.materialUnit = ds.Tables[0].Rows[0].ItemArray[5].ToString();
model.materialStorageLocation = ds.Tables[0].Rows[0].ItemArray[6].ToString();
model.materialKind = ds.Tables[0].Rows[0].ItemArray[7].ToString();
model.materialSupplier = ds.Tables[0].Rows[0].ItemArray[8].ToString();
model.materialReferenceValue = ds.Tables[0].Rows[0].ItemArray[9].ToString();
model.materialTimeCanGet = ds.Tables[0].Rows[0].ItemArray[10].ToString();
model.materialQuantity = ds.Tables[0].Rows[0].ItemArray[11].ToString();
model.materialSafety = ds.Tables[0].Rows[0].ItemArray[12].ToString();
model.materialNumberRecipient = ds.Tables[0].Rows[0].ItemArray[13].ToString();
model.materialGoodNumberReturn = ds.Tables[0].Rows[0].ItemArray[14].ToString();
model.materialBadNumberReturn = ds.Tables[0].Rows[0].ItemArray[15].ToString();
model.materialRemainQuantity = ds.Tables[0].Rows[0].ItemArray[16].ToString();
model.materialRemark = ds.Tables[0].Rows[0].ItemArray[17].ToString();
model.materialImagePath = String.IsNullOrEmpty(ds.Tables[0].Rows[0].ItemArray[18].ToString()) ? "~/AppFiles/Images/default.png" : ds.Tables[0].Rows[0].ItemArray[18].ToString();
model.needToBuyMore = (bool)(Int32.Parse(ds.Tables[0].Rows[0].ItemArray[16].ToString()) < Int32.Parse(ds.Tables[0].Rows[0].ItemArray[12].ToString()));
return(model);
}
catch (Exception ex)
{
return(model);
}
finally
{
oledb.Close();
}
}
public bool editConsumable(ConsumableMaterialModel item)
{
try
{
var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/AppFiles/Database/ComsumableItem.json"));
string jsonResult = Read(path);
List <ConsumableMaterialModel> list = JsonConvert.DeserializeObject <List <ConsumableMaterialModel> >(jsonResult);
int index = list.FindIndex(x => x.materialCode.Equals(item.materialCode));
if (index == -1)
{
return(false);
}
list[index] = item;
string jSONString = JsonConvert.SerializeObject(list, Formatting.Indented);
Write(path, jSONString);
return(true);
}
catch (Exception ex) {
return(false);
}
}
