private bool AddUnit()
{
bool ck = false;
int C = 0;
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
int idWork = txtWorkId.Text.ToInt();
string workNo = txtWorkNo.Text;
string workName = txtWorkName.Text.Trim();
int UOM = cbbUOM.SelectedValue.ToInt();
decimal costPer = txtCostPer.Value.ToDecimal();
decimal capa = txtCapa.Value.ToDecimal();
int cal = cbbCalendar.SelectedValue.ToInt();
string desc = txtDescription.Text;
var w = db.mh_WorkCenters.Where(x => x.id == idWork).FirstOrDefault();
if (w == null)
{
w = new mh_WorkCenter();
workNo = dbClss.GetNo(25, 2);
}
w.WorkCenterNo = workNo;
w.WorkCenterName = workName;
w.UOM = UOM;
w.CostPerUOM = costPer;
w.Capacity = capa;
w.Calendar = cal;
w.Decription = desc;
db.SubmitChanges();
WorkId = w.id;
C++;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("Add Work center", ex.Message, this.Name);
}
if (C > 0)
{
MessageBox.Show("Save complete.!");
DataLoad();
}
return(ck);
}
private bool AddUnit()
{
bool ck = false;
int C = 0;
try
{
dgvData.EndEdit();
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
//work Center
int idWork = txtWorkId.Text.ToInt();
string workNo = txtWorkNo.Text.Trim();
string workName = txtWorkName.Text.Trim();
int UOM = cbbUOM.SelectedValue.ToInt();
int Cal = cbbCalendar.SelectedValue.ToInt();
string Desc = txtDescription.Text.Trim();
bool newDoc = false;
var work = db.mh_WorkCenters.Where(x => x.id == idWork).FirstOrDefault();
if (work == null)
{
work = new mh_WorkCenter();
//workNo = dbClss.GetNo(25, 2);
dbClss.AddHistory(this.Name, "WorkCenter", $"New Work Center {workNo}", workNo);
newDoc = true;
}
if (!newDoc)
{
if (work.WorkCenterNo != workNo)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Work Center No. from {work.WorkCenterNo} to {workNo}", workNo);
}
if (work.WorkCenterName != workName)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Work Center Name from {work.WorkCenterName} to {workName}", workNo);
}
if (work.UOM != UOM)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"UOM from {work.UOM} to {UOM}", workNo);
}
if (work.Calendar != Cal)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Calendar from {work.Calendar} to {Cal}", workNo);
}
if (work.Decription != Desc)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Description from {work.Decription} to {Desc}", workNo);
}
}
work.WorkCenterNo = workNo;
work.WorkCenterName = workName;
work.UOM = UOM;
work.Calendar = Cal;
work.Decription = Desc;
work.Active = true;
if (idWork == 0)
{
db.mh_WorkCenters.InsertOnSubmit(work);
}
db.SubmitChanges();
idWork = work.id;
WorkId = work.id;
//Sub-Work Centers
//decimal sumCapa = 0.00m;
decimal sumCapaHr = 0.00m;
decimal sumCost = 0.00m;
var sumCycle = 0.00m;
foreach (var item in dgvData.Rows)
{
newDoc = false;
decimal CostPerUOM = item.Cells["CostPerUOM"].Value.ToDecimal();
decimal Capacity = item.Cells["Capacity"].Value.ToDecimal();
decimal CapacityHour = item.Cells["CapacityHour"].Value.ToDecimal();
decimal CycleTime = item.Cells["CycleTime"].Value.ToDecimal();
//sumCapa += Capacity;
sumCapaHr += CapacityHour;
sumCost += CostPerUOM;
sumCycle += CycleTime;
//if (item.Cells["dgvC"].Value.ToSt() == "") continue;
int id = item.Cells["id"].Value.ToInt();
string SubWorkNo = item.Cells["SubWorkNo"].Value.ToSt();
//if (SubWorkNo == "")
// SubWorkNo = dbClss.GetNo(27, 2);
string SubWorkName = item.Cells["SubWorkName"].Value.ToSt();
int WType = item.Cells["WType"].Value.ToInt();
string Description = item.Cells["Description"].Value.ToSt();
bool active = true;
var ws = db.mh_WorkCenterSubs.Where(x => x.id == id).FirstOrDefault();
if (ws == null)
{
ws = new mh_WorkCenterSub();
newDoc = true;
dbClss.AddHistory(this.Name, "WorkCenter", $"New Sub-Workcenter from {SubWorkNo}", workNo);
}
if (!newDoc)
{
if (SubWorkNo != ws.SubWorkNo)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Sub-Work No from {ws.SubWorkNo} to {SubWorkNo}", workNo);
}
if (SubWorkName != ws.SubWorkName)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Sub-Work Name from {ws.SubWorkName} to {SubWorkName}", workNo);
}
if (UOM != ws.UOM)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Sub-UOM from {ws.UOM} to {UOM}", workNo);
}
if (WType != ws.WType)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Work Center Type from {ws.WType} to {WType}", workNo);
}
if (CostPerUOM != ws.CostPerUOM)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Cost:UOM from {ws.CostPerUOM} to {CostPerUOM}", workNo);
}
if (Capacity != ws.Capacity)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Capacity from {ws.Capacity} to {Capacity}", workNo);
}
if (Description != ws.Description)
{
dbClss.AddHistory(this.Name, "WorkCenter", $"Description from {ws.Description} to {Description}", workNo);
}
}
ws.idWorkCenter = idWork;
ws.SubWorkName = SubWorkName;
ws.SubWorkNo = SubWorkNo;
ws.UOM = UOM;
ws.WType = WType;
ws.Active = active;
ws.CostPerUOM = CostPerUOM;
ws.Capacity = Capacity;
ws.Description = Description;
ws.CapacityHour = CapacityHour;
ws.CycleTime = CycleTime;
if (id == 0)
{
db.mh_WorkCenterSubs.InsertOnSubmit(ws);
}
db.SubmitChanges();
C++;
}
//sum Capacity & Cost Per
var w = db.mh_WorkCenters.Where(x => x.id == WorkId).FirstOrDefault();
if (w != null && dgvData.Rows.Count > 0)
{
w.CostPerUOM = sumCost;
//w.Capacity = sumCapa;
//w.CapacityHour = sumCapa * 60;
w.CapacityHour = sumCapaHr;
w.Capacity = Math.Round(sumCapaHr / 60, 2);
w.CycleTime = sumCycle;
db.SubmitChanges();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("Add Sub-Work center", ex.Message, this.Name);
}
if (C > 0)
{
MessageBox.Show("Save complete.!");
}
return(ck);
}
private bool AddUnit()
{
bool ck = false;
int C = 0;
try
{
radGridView1.EndEdit();
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (var g in radGridView1.Rows)
{
if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T"))
{
if (Convert.ToString(g.Cells["dgvCodeTemp"].Value).Equals(""))
{
var t = new mh_WorkCenter();
t.Calendar = g.Cells["Calendar"].Value.ToInt();
t.Capacity = g.Cells["Capacity"].Value.ToDecimal();
t.CostPerUOM = g.Cells["CostPer"].Value.ToDecimal();
t.UOM = g.Cells["UOM"].Value.ToInt();
t.WorkCenterName = g.Cells["Name"].Value.ToSt();
t.WorkCenterNo = dbClss.GetNo(25, 2);
t.Active = true;
dbClss.AddHistory(this.Name, "เพิ่ม Work Center", $"เพิ่ม Work Center [{t.WorkCenterName}]", "");
//dbClss.AddHistory(this.Name, "เพิ่มผู้ขาย", "เพิ่มผู้ขาย [" + gy.VendorName + "]", "");
db.mh_WorkCenters.InsertOnSubmit(t);
db.SubmitChanges();
C += 1;
}
else
{
var t = db.mh_WorkCenters.Where(x => x.id == g.Cells["dgvCodeTemp"].Value.ToInt()).First();
t.Calendar = g.Cells["Calendar"].Value.ToInt();
t.Capacity = g.Cells["Capacity"].Value.ToDecimal();
t.CostPerUOM = g.Cells["CostPer"].Value.ToDecimal();
t.UOM = g.Cells["UOM"].Value.ToInt();
t.WorkCenterName = g.Cells["Name"].Value.ToSt();
C += 1;
db.SubmitChanges();
dbClss.AddHistory(this.Name, "แก้ไข Work Center", $"แก้ไข Work Center [{t.WorkCenterName}]", "");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("เพิ่ม Work Center", ex.Message, this.Name);
}
if (C > 0)
{
MessageBox.Show("บันทึกสำเร็จ!");
}
return(ck);
}
