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"));
}
public IHttpActionResult PutPartsModel(int id, PartsModel partsModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != partsModel.PartsModelID)
{
return(BadRequest());
}
db.Entry(partsModel).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PartsModelExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IActionResult CalculatePartDetails()
{
PartsModel partsModel;
using (var db = new ShippingContext())
{
db.Parts.RemoveRange(db.Parts);
foreach (var box in db.Boxes)
{
var W = box.Weight;
var PC = box.PartCount;
var floor = (int)(W / PC);
var mod = W % PC;
for (var p = 0; p < PC; p++)
{
var part = new Part
{
BoxId = box.BoxId,
PartWeight = p == 0 ? floor + mod : floor
};
part.PartCost = CalculateCost(part.PartWeight);
db.Parts.Add(part);
}
}
db.SaveChanges();
partsModel = new PartsModel {
Parts = db.Parts.OrderBy(p => p.BoxId).ToList()
};
}
return(View(partsModel));
}
public void PrepareCategories()
{
Categories = new ObservableCollection <CategoryTable>();
PartsModel partModel = new PartsModel();
Categories = partModel.GetCategory();
}
void updatePart()
{
string filePath = "";
OpenFileDialog ofd = new OpenFileDialog();
ofd.Multiselect = false;
if (ofd.ShowDialog() == DialogResult.OK)
{
filePath = ofd.FileName;
}
else
{
return;
}
DataTable dt = TextUtils.ExcelToDatatableNoHeader(filePath, "Sheet2");
dt = dt.Select("F2 is not null and F2 <> ''").CopyToDataTable();
if (dt.Rows.Count == 0)
{
MessageBox.Show("Bạn đã chọn sai biểu mẫu dữ liệu.", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
DataTable dtPart = LibQLSX.Select("select * from Parts with(nolock)");
int count = 0;
foreach (DataRow row in dt.Rows)
{
string partsCode = TextUtils.ToString(row["F2"]);
if (partsCode == "")
{
continue;
}
string des = TextUtils.ToString(row["F3"]);
string hsCode = TextUtils.ToString(row["F4"]);
decimal importTax = TextUtils.ToDecimal(row["F5"]);
DataRow[] drs = dtPart.Select("PartsCode = '" + partsCode.Trim() + "'");
if (drs.Length > 0)
{
string partsId = TextUtils.ToString(drs[0]["PartsId"]);
PartsModel part = (PartsModel)PartsBO.Instance.FindByAttribute("PartsId", partsId)[0];
part.Description = des;
part.HsCode = hsCode;
part.ImportTax = importTax;
PartsBO.Instance.UpdateQLSX(part);
count++;
}
}
MessageBox.Show(count.ToString());
loadData(1);
}
/// <summary>
/// get a parts and directories tree (root node)
/// </summary>
/// <returns>root node</returns>
public PartsModel BuildPartsTree()
{
IList <PartsModel> directories = null;
IList <PartsModel> parts = null;
using (var dao = new PartsDao(_dbName))
{
directories = dao.GetDirectory();
parts = dao.GetParts();
}
var dictNodes = directories.ToDictionary(m => m.Id, m => m);
var root = new PartsModel()
{
Name = _dbName,
Id = 0,
PId = 0,
SortPos = 0,
PartsType = PartsModel.Type.ROOT,
};
// build directory tree
foreach (var node in dictNodes)
{
var pid = node.Value.PId;
if (pid == 0)
{
root.Children.Add(node.Value);
node.Value.Parent = root;
}
else
{
if (dictNodes.ContainsKey(pid))
{
var parentItem = dictNodes[pid];
parentItem.Children.Add(node.Value);
node.Value.Parent = parentItem;
}
}
}
// build part tree under the directory
foreach (var part in parts)
{
if (dictNodes.ContainsKey(part.PId))
{
var parentItem = dictNodes[part.PId];
parentItem.Children.Add(part);
part.Parent = parentItem;
}
}
return(root);
}
public IHttpActionResult GetPartsModel(int id)
{
PartsModel partsModel = db.Parts.Find(id);
if (partsModel == null)
{
return(NotFound());
}
return(Ok(partsModel));
}
public IHttpActionResult PostPartsModel(PartsModel partsModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Parts.Add(partsModel);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = partsModel.PartsModelID }, partsModel));
}
public void CreatePart()
{
try
{
PartsModel partsModel = new PartsModel();
partsModel.CreateNewPart(PartName, Price, Category.CategoryID, 1);
}
catch (ArgumentNullException nullex)
{
Protocol.WriteToProtocol(0, "Register() :" + nullex.Message + nullex.StackTrace, "Register User Error");
}
}
public IHttpActionResult DeletePartsModel(int id)
{
PartsModel partsModel = db.Parts.Find(id);
if (partsModel == null)
{
return(NotFound());
}
db.Parts.Remove(partsModel);
db.SaveChanges();
return(Ok(partsModel));
}
public IActionResult Edit(int id, PartsModel model)
{
if (!this.ModelState.IsValid)
{
return(this.View(model));
}
this.parts.Edit(id,
model.Name,
model.Price,
model.Quantity);
return(this.RedirectToAction(nameof(All)));
}
private void btnEdit_Click(object sender, EventArgs e)
{
string id = TextUtils.ToString(grvData.GetFocusedRowCellValue(colParstId));
ArrayList array = PartsBO.Instance.FindByAttribute("PartsId", id);
PartsModel part = (PartsModel)array[0];
_rownIndex = grvData.FocusedRowHandle;
frmMaterialQLSX frm = new frmMaterialQLSX();
frm.Part = part;
frm.LoadDataChange += main_LoadDataChange;
frm.Show();
}
void updatePart()
{
string filePath = "";
OpenFileDialog ofd = new OpenFileDialog();
ofd.Multiselect = false;
if (ofd.ShowDialog() == DialogResult.OK)
{
filePath = ofd.FileName;
}
else
{
return;
}
//filePath = @"E:\PROJECTS\TanPhat\KAIZEN\Phòng vật tư\HScode-Xuất nhập khẩu\MISUMI-HSCODE.xlsx";
DataTable dt = TextUtils.ExcelToDatatableNoHeader(filePath, "Sheet2");
dt = dt.Select("F2 is not null and F2 <> ''").CopyToDataTable();
DataTable dtPart = LibQLSX.Select("select * from Parts with(nolock)");
int count = 0;
foreach (DataRow row in dt.Rows)
{
string partsCode = TextUtils.ToString(row["F2"]);
if (partsCode == "")
{
continue;
}
string des = TextUtils.ToString(row["F3"]);
string hsCode = TextUtils.ToString(row["F4"]);
decimal importTax = TextUtils.ToDecimal(row["F5"]);
DataRow[] drs = dtPart.Select("PartsCode = '" + partsCode.Trim() + "'");
if (drs.Length > 0)
{
string partsId = TextUtils.ToString(drs[0]["PartsId"]);
PartsModel part = (PartsModel)PartsBO.Instance.FindByAttribute("PartsId", partsId)[0];
part.Description = des;
part.HsCode = hsCode;
part.ImportTax = importTax;
PartsBO.Instance.UpdateQLSX(part);
count++;
}
}
MessageBox.Show(count.ToString());
}
public IActionResult Create(PartsModel model)
{
if (!this.ModelState.IsValid)
{
model.Suppliers = this.GetSuppliersItems();
return(this.View(model));
}
this.parts
.Create(model.Name,
model.Price,
model.Quantity,
model.SupplierId);
return(this.RedirectToAction(nameof(All)));
}
void upateDatePrice()
{
string filePath = @"E:\PROJECTS\TanPhat\KAIZEN\VAT TU DA THEM GIA.xlsx";
DataTable dt = TextUtils.ExcelToDatatableNoHeader(filePath, "Sheet");
dt = dt.Select("F4 is not null and F4 <> ''").CopyToDataTable();
DataTable dtPart = LibQLSX.Select("select * from Parts with(nolock)");
int count = 0;
foreach (DataRow row in dt.Rows)
{
string partsCode = TextUtils.ToString(row["F4"]);
string MaVatLieu = TextUtils.ToString(row["F5"]);
if (partsCode == "")
{
continue;
}
if (MaVatLieu != "" && MaVatLieu != "GCCX")
{
partsCode = MaVatLieu;
}
DataRow[] drs = dtPart.Select("PartsCode = '" + partsCode.Trim() + "'");
if (drs.Length > 0)
{
string partsId = TextUtils.ToString(drs[0]["PartsId"]);
decimal price = TextUtils.ToDecimal(drs[0]["Price"]);
if (price <= 1)
{
continue;
}
PartsModel part = (PartsModel)PartsBO.Instance.FindByAttribute("PartsId", partsId)[0];
part.UpdatedPriceDate = DateTime.Now;
PartsBO.Instance.UpdateQLSX(part);
count++;
}
}
MessageBox.Show(count.ToString());
}
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" }));
}
protected PartsFacade(PartsModel model) : base(model)
{
}
public PartsViewModel()
{
model = new PartsModel();
}
