public ActionResult PartsInserting(int partsTypeID, int[] partsBrandID)
{
Database db;
PartsTypeModel ptModel = new PartsTypeModel();
ptModel.PART_TYPE_ID = partsTypeID;
for (int i = 0; i < partsBrandID.Length; i++)
{
PartsBrandModel pbModel = new PartsBrandModel();
pbModel.PART_BRAND_ID = partsBrandID[i];
PartsModel pModel = new PartsModel();
pModel.TYPE = ptModel;
pModel.BRAND = pbModel;
// ค้นข้อมูลมา ตรวจสอบค่าก่อนจะเพิ่มลงฐานข้อมูล
db = new Database();
PartsDAO pDAO = new PartsDAO(db);
bool hasRow = pDAO.HasField(pModel);
db.Close();
// ถ้าไม่มีให้เพิ่มได้ ถ้ามีไม่ต้องทำอะไร
if (!hasRow)
{
db = new Database();
pDAO = new PartsDAO(db);
pDAO.Add(pModel);
db.Close();
}
}
return(Redirect("~/Stock/StockManagement"));
}
//ปุ่มเรียกใช้อยู่หน้า index/stock
public ActionResult stockEdeting_Popup(int stockID)
{
// ตัวที่จะแก้ไข
Database db = new Database();
StockDAO sDAO = new StockDAO(db);
StockModel sModel = sDAO.FindById(stockID);
db.Close();
ViewBag.Stock = sModel;
// ทำตัวเลือกประเภท
db = new Database();
PartsTypeDAO ptDAO = new PartsTypeDAO(db);
List <PartsTypeModel> ptModel = ptDAO.FindAll();
db.Close();
ViewBag.PartsType = ptModel;
//ทำตัวเลือกยี่ห้อ
db = new Database();
PartsDAO pDAO = new PartsDAO(db);
List <PartsModel> pModel = pDAO.FindByPartsTypeID(sModel.PART.TYPE.PART_TYPE_ID);
db.Close();
ViewBag.PartsBrand = pModel;
return(View());
}
public JsonResult StockAdding_PopupSelectDataLoading(int idValue)
{
Database db = new Database();
PartsDAO pDAO = new PartsDAO(db);
List <PartsModel> pModel = pDAO.FindByPartsTypeID(idValue);
db.Close();
var data = "";
if (pModel.Count > 0)
{
data = "<option value=''>---- เลือกยี่ห้อ ----</option>";
foreach (var brand in pModel)
{
data += "<option value='" + brand.PART_ID + "'>" + brand.BRAND.PART_BRAND_NAME + "</option>";
}
}
else
{
data = "<option value=''>---- ไม่มีข้อมูล ----</option>";
}
return(Json(new { data }));
}
protected void btnDelete_Click(object sender, EventArgs e)
{
String partID = dropDownPartID.SelectedValue;
PartsDAO dao = new PartsDAO();
dao.deletePart(partID);
Response.Redirect("~/Staff/AdminHome.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
PartsDTO dto = (PartsDTO)Session["PartsDTO"];
ModelFacade facade = new ModelFacade();
Parts parts = facade.createPart(dto);
PartsDAO dao = new PartsDAO();
dao.savePart(parts);
Session.Abandon();
Response.Redirect("~/Staff/AdminHome.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
partObj.partID = lblID.Text;
partObj.partName = txtNewName.Text;
partObj.partType = dropDownNewType.SelectedValue;
partObj.manufacturer = txtNewManu.Text;
partObj.datePurchased = calNewDate.SelectedDate.ToShortDateString();
partObj.price = txtNewPrice.Text;
partObj.supplier = txtNewSupplier.Text;
partObj.inStock = dropDownInStock.SelectedValue;
PartsDAO dao = new PartsDAO();
dao.updatePart(partObj);
Session.Abandon();
Response.Redirect("~/Staff/AdminHome.aspx");
}
public ActionResult StockManagement_DataLoading(int typeID)
{
Database db = new Database();
PartsBrandDAO pbDAO = new PartsBrandDAO(db);
List <PartsBrandModel> pbModel = pbDAO.FindAll();
ViewBag.PartsBrand = pbModel;
db.Close();
db = new Database();
PartsDAO pDAO = new PartsDAO(db);
List <PartsModel> tModel = pDAO.FindByPartsTypeID(typeID);
ViewBag.Parts = tModel;
db.Close();
return(View());
}
public JsonResult Uncheck(int type_id, int brand_id)
{
PartsTypeModel ptModel = new PartsTypeModel();
ptModel.PART_TYPE_ID = type_id;
PartsBrandModel pbModel = new PartsBrandModel();
pbModel.PART_BRAND_ID = brand_id;
PartsModel pModel = new PartsModel();
pModel.TYPE = ptModel;
pModel.BRAND = pbModel;
Database db = new Database();
PartsDAO pDAO = new PartsDAO(db);
int x = pDAO.DeleteByTypeAndBrand(pModel);
db.Close();
return(Json(new { errMsg = "test" }));
}
