public ActionResult EditItemClass(string id)
{
ItemclassViewModel model = new ItemclassViewModel();
try
{
if (ModelState.IsValid)
{
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
DataSet ds = dbfunction.GetDataset("select * from tov.itemclass where class= '" + id + "'");
if (ds.Tables[0].Rows.Count > 0)
{
model.ClassId = Convert.ToString(ds.Tables[0].Rows[0]["Class"]);
model.Class = Convert.ToString(ds.Tables[0].Rows[0]["Class"]);
model.Desc = Convert.ToString(ds.Tables[0].Rows[0]["Desc"]);
model.Dept = Convert.ToString(ds.Tables[0].Rows[0]["Dept"]);
model.Market = Convert.ToString(ds.Tables[0].Rows[0]["Market"]);
model.Deptnum = Convert.ToInt32(ds.Tables[0].Rows[0]["Deptnum"]);
model.Buyer = Convert.ToString(ds.Tables[0].Rows[0]["Buyer"]);
}
else
{
return(RedirectToAction("ItemClassList", "Inventory"));
}
}
}
catch (Exception ex)
{
}
return(View(model));
return(View());
}
public ActionResult AddItemClass(ItemclassViewModel model)
{
try
{
if (ModelState.IsValid)
{
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
var query = "select * from tov.itemclass where class = '" + model.Class + "'";
DataSet ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count == 0)
{
query = "insert into tov.itemclass (Class,`Desc`,Dept,Market,Deptnum,Buyer) values ('" + model.Class + "', '" + model.Desc + "', '" + model.Dept + "', '" + model.Market + "', '" + model.Deptnum + "', '" + model.Buyer + "');insert into HEANDB.itemclass (Class,`Desc`,Dept,Market,Deptnum,Buyer) values ('" + model.Class + "', '" + model.Desc + "', '" + model.Dept + "', '" + model.Market + "', '" + model.Deptnum + "', '" + model.Buyer + "')";
ds = dbfunction.GetDataset(query);
ViewBag.SuccessMessage = "Class added successfully";
}
else
{
ViewBag.ErrorMessage = "Class name is already exists";
}
}
}
catch (Exception ex)
{
}
return(View(model));
}
public ActionResult EditItemClass(ItemclassViewModel model)
{
try
{
if (ModelState.IsValid)
{
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
var query = "select * from tov.itemclass where class = '" + model.Class + "' and class !='" + model.ClassId + "' ";
DataSet ds = dbfunction.GetDataset(query);
if (ds.Tables[0].Rows.Count == 0)
{
query = " update tov.itemclass set Class = '" + model.Class + "',`Desc`= '" + model.Desc + "',Dept = '" + model.Dept + "',Market = '" + model.Market + "',Deptnum = '" + model.Deptnum + "',Buyer = '" + model.Buyer + "' where class = " + model.ClassId + " ;";
ds = dbfunction.GetDataset(query);
query = "update HEANDB.itemclass set Class = '" + model.Class + "',`Desc`= '" + model.Desc + "',Dept = '" + model.Dept + "',Market = '" + model.Market + "',Deptnum = '" + model.Deptnum + "',Buyer = '" + model.Buyer + "' where class = " + model.ClassId + " ;";
ds = dbfunction.GetDataset(query);
ViewBag.SuccessMessage = "Class updated successfully";
}
else
{
ViewBag.ErrorMessage = "Class name is already exists";
}
}
}
catch (Exception ex)
{
}
return(View(model));
}
public JsonResult GetOrderNotes(string ordernum, DateTime orderDate)
{
ResponseModel response = new ResponseModel();
try
{
var year = orderDate.Year.ToString().Substring(2, 2);
ItemclassViewModel model = new ItemclassViewModel();
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
var query = "select * from ordernotes where (SUBSTRING(('" + ordernum + " '),1,6)= Ordernum AND SUBSTRING(('" + ordernum + "'),8,2)= Year) ";
DataSet ds = dbfunction.GetDataset(query);
if (ds.Tables.Count > 0)
{
var notes = (from row in ds.Tables[0].AsEnumerable()
select new OrderNoteViewModel
{
Line = Convert.ToString(row["Line"]) == "" ? 0 : Convert.ToInt32(row["Line"]),
Year = Convert.ToString(row["Year"]),
Ordernum = Convert.ToString(row["Ordernum"]),
Note = Convert.ToString(row["Note"]),
}).ToList();
return(Json(notes));
}
return(Json(response));
}
catch (Exception ex)
{
}
return(Json(response));
}
public JsonResult GetOrderNotes(string bol1_no)
{
ResponseModel response = new ResponseModel();
try
{
ItemclassViewModel model = new ItemclassViewModel();
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
var query = "select * from ordernotes where ordernum in (select bol2_order_no from bol_2 where bol2_no='" + bol1_no + "' )";
DataSet ds = dbfunction.GetDataset(query);
if (ds.Tables.Count > 0)
{
var notes = (from row in ds.Tables[0].AsEnumerable()
select new OrderNoteViewModel
{
Line = Convert.ToString(row["Line"]) == "" ? 0 : Convert.ToInt32(row["Line"]),
Year = Convert.ToString(row["Year"]),
Ordernum = Convert.ToString(row["Ordernum"]),
Note = Convert.ToString(row["Note"]),
}).ToList();
return(Json(notes));
}
return(Json(response));
}
catch (Exception ex)
{
}
return(Json(response));
}
public JsonResult UpdateBolDetail(string bol1_no, string column, string bol1_carrierName, string bol1_carrierPhone, DateTime?bol1_PkupDate, DateTime?bol1_pkupTime, string Conformation, int pallet_no, string pallet_type)
{
ResponseModel response = new ResponseModel();
try
{
ItemclassViewModel model = new ItemclassViewModel();
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
var query = "";
if (column == "bol1_carrierName")
{
query = "Update bol_1 set bol1_carrierName='" + bol1_carrierName + "' where bol1_no ='" + bol1_no + "' ";
}
else if (column == "bol1_carrierPhone")
{
query = "Update bol_1 set bol1_carrierPhone='" + bol1_carrierPhone + "' where bol1_no ='" + bol1_no + "' ";
}
else if (column == "bol1_PkupDate")
{
query = "Update bol_1 set bol1_PkupDate='" + bol1_PkupDate.Value.ToString("yyyy/MM/dd") + "' where bol1_no ='" + bol1_no + "' ";
}
else if (column == "Conformation")
{
query = "Update bol_1 set Conformation='" + Conformation + "' where bol1_no ='" + bol1_no + "' ";
}
else if (column == "pallet")
{
query = "Update bol_1 set bol1_pallet=" + pallet_no + ",bol1_pallet_type='" + pallet_type + "' where bol1_no ='" + bol1_no + "' ";
}
else
{
query = "Update bol_1 set bol1_pkupTime='" + bol1_pkupTime.Value.ToString("HH:mm") + "' where bol1_no ='" + bol1_no + "' ";
}
DataSet ds = dbfunction.GetDataset(query);
response.Status = "1";
response.Message = "Detail updated successfully";
}
catch (Exception ex)
{
}
return(Json(response));
}
public JsonResult DeleteDeptAmount(string id)
{
ResponseModel response = new ResponseModel();
try
{
ItemclassViewModel model = new ItemclassViewModel();
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
var query = " delete from deptamount where deptamount_id = '" + id + "' ";
DataSet ds = dbfunction.GetDataset(query);
response.Status = "1";
response.Message = "Department amount detail deleted successfully";
}
catch (Exception ex)
{
}
return(Json(response));
}
public JsonResult DeleteDeptProjection(string DeptName, string mm)
{
ResponseModel response = new ResponseModel();
try
{
ItemclassViewModel model = new ItemclassViewModel();
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
var query = " delete from tov.DeptProjection where DeptName = '" + DeptName + "' and mm =" + mm + " ";
DataSet ds = dbfunction.GetDataset(query);
response.Status = "1";
response.Message = "Department projection detail deleted successfully";
}
catch (Exception ex)
{
}
return(Json(response));
}
public JsonResult DeleteItemClass(string id)
{
ResponseModel response = new ResponseModel();
try
{
ItemclassViewModel model = new ItemclassViewModel();
DbfunctionUtility dbfunction = new DbfunctionUtility(_appSettings);
var query = " delete from tov.itemclass where class ='" + id + "' ;delete from HEANDB.itemclass where class ='" + id + "' ; ";
DataSet ds = dbfunction.GetDataset(query);
response.Status = "1";
response.Message = "Class deleted successfully";
}
catch (Exception ex)
{
}
return(Json(response));
}
