private void unfinished_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
UnFinished item = (UnFinished)unfinished.SelectedItem;
continueInspection.IsChecked = true;
iInspectionItem Inspect = (from c in db.iInspectionItems
where c.SAPCode == item.Sapcode &&
c.LotNo == item.LotNo
select c).FirstOrDefault();
Stage.Text = Inspect.Stage;
Sapcode.Text = Inspect.SAPCode;
Quantity.Text = Convert.ToString(Inspect.Qty);
Lotnocontainer.Text = Inspect.LotNo;
loadDataRelatedFromChosenSAPCode(sender, null);
DisabledAll();
}
//public bool Validation()
//{
// bool result = true;
// if(this.Stage.SelectedIndex == 0)
// {
// result = false;
// }
//}
private void StartInspection_Click(object sender, RoutedEventArgs e)
{
string sapCode = Regex.Replace(Sapcode.Text, @"\s+", "");
string insType = "";
iInspectionItem exist = (from c in db.iInspectionItems where c.LotNo == Lotnocontainer.Text && c.SAPCode == sapCode select c).FirstOrDefault();
bool proceed = true;
if (newInspection.IsChecked == true)
{
insType = "NEW";
string type = gettype(sapCode);
if (exist == null)
{
if (type.Equals("SP"))
{
List <SPModel> items = loadSAPCodeDataSP(sapCode);
foreach (SPModel i in items)
{
DateTime datehere = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd HH:mm tt"), "yyyy-MM-dd HH:mm tt", System.Globalization.CultureInfo.InvariantCulture);
iInspectionItem checkitem = new iInspectionItem();
checkitem.MCSID = i.MCSID;
checkitem.MCSChildID = i.MCSSPID;
checkitem.CheckItem = i.CheckItem;
checkitem.Stage = Stage.Text.Trim();
checkitem.SAPCode = sapCode;
checkitem.Qty = Convert.ToInt32(Quantity.Text);
checkitem.LotNo = Lotnocontainer.Text;
checkitem.SamplingSize = LoadSamplingSize(i.Method);
checkitem.SACStart = Convert.ToDateTime("1/1/1900 12:00:00 AM");
checkitem.SACEnd = Convert.ToDateTime("1/1/1900 12:00:00 AM");
checkitem.RegisterDate = datehere;
checkitem.RegisterID = currentuser.UserID;
checkitem.UpdateDate = datehere;
checkitem.UpdateID = currentuser.UserID;
checkitem.RegisterPG = "PG";
checkitem.UpdatePG = "ADMIN";
db.iInspectionItems.Add(checkitem);
db.SaveChanges();
}
}
else
{
List <FGModel> items = loadSAPCodeDataFG(sapCode);
foreach (FGModel i in items)
{
DateTime datehere = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd HH:mm tt"), "yyyy-MM-dd HH:mm tt", System.Globalization.CultureInfo.InvariantCulture);
iInspectionItem checkitem = new iInspectionItem();
checkitem.MCSID = i.MCSID;
checkitem.MCSChildID = i.MCSFGID;
checkitem.CheckItem = i.CheckItem;
checkitem.Stage = Stage.Text.Trim();
checkitem.SAPCode = sapCode;
checkitem.Qty = Convert.ToInt32(Quantity.Text);
checkitem.LotNo = Lotnocontainer.Text;
checkitem.SamplingSize = LoadSamplingSize(i.Method);
checkitem.SACStart = Convert.ToDateTime("1/1/1900 12:00:00 AM");
checkitem.SACEnd = Convert.ToDateTime("1/1/1900 12:00:00 AM");
checkitem.RegisterDate = datehere;
checkitem.RegisterID = currentuser.UserID;
checkitem.UpdateDate = datehere;
checkitem.UpdateID = currentuser.UserID;
checkitem.RegisterPG = "PG";
checkitem.UpdatePG = "ADMIN";
db.iInspectionItems.Add(checkitem);
db.SaveChanges();
}
}
MessageBox.Show("Inspection Successfully Created");
}
else
{
MessageBox.Show("Inspection Already Exist");
proceed = false;
}
}
else
{
MessageBox.Show("Continue Inspection");
}
if (proceed)
{
Inspectiondetail detail = new Inspectiondetail(currentuser, sapCode, Lotnocontainer.Text, type, insType);
detail.Show();
this.Close();
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (DatainsertGrid.HasItems)
{
DetailsInspect item = (DetailsInspect)detailsgrid.SelectedItem;
iInspectionItem inspectionITEM = (from c in db.iInspectionItems where c.ID == item.ID select c).FirstOrDefault();
//foreach (DetailsInspect item in detailsgrid.SelectedItems)
//{
if (item.Datatype != "ATTRIBUTE")
{
List <theData> datahere = DatainsertGrid.Items.OfType <theData>().ToList();
string OVERALLJudgement = "AC";
foreach (theData d in datahere)
{
if (d.Judgement == "NC")
{
OVERALLJudgement = "NC";
}
iInspectionDetail inspectDetail = new iInspectionDetail();
inspectDetail.InspectionItemId = item.ID;
inspectDetail.CheckItemNo = item.No;
inspectDetail.Sequence = sampling;
inspectDetail.Data = Convert.ToDecimal(d.Data);
inspectDetail.Judgement = d.Judgement;
inspectDetail.IsPartial = false;
inspectDetail.IsFinished = true;
inspectDetail.IsDeleted = false;
inspectDetail.RegisterID = currentuser.UserID;
inspectDetail.RegisterPG = "PG";
inspectDetail.RegisterDate = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd HH:mm tt"), "yyyy-MM-dd HH:mm tt", System.Globalization.CultureInfo.InvariantCulture);
inspectDetail.UpdateID = currentuser.UserID;
inspectDetail.UpdatePG = "PG";
inspectDetail.UpdateDate = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd HH:mm tt"), "yyyy-MM-dd HH:mm tt", System.Globalization.CultureInfo.InvariantCulture);
db.iInspectionDetails.Add(inspectDetail);
db.SaveChanges();
//}
inspectionITEM.OverallJudgement = OVERALLJudgement;
inspectionITEM.IsFinished = true;
db.Entry(inspectionITEM).State = EntityState.Modified;
db.SaveChanges();
}
}
else
{
List <theVisualData> thevisualdatahere = DatainsertGrid.Items.OfType <theVisualData>().ToList();
SaveVisual("AC", Convert.ToInt32(thevisualdatahere[0].AC), item);
SaveVisual("NC", Convert.ToInt32(thevisualdatahere[0].NC), item);
SaveVisual("NA", Convert.ToInt32(thevisualdatahere[0].NA), item);
if (thevisualdatahere[0].AC == "0" && thevisualdatahere[0].NC == "0")
{
inspectionITEM.OverallJudgement = "NA";
}
else if (Convert.ToInt32(thevisualdatahere[0].NC) > 0)
{
inspectionITEM.OverallJudgement = "NC";
}
else
{
inspectionITEM.OverallJudgement = "AC";
}
inspectionITEM.IsFinished = true;
db.Entry(inspectionITEM).State = EntityState.Modified;
db.SaveChanges();
}
sampling = 1;
DatainsertGrid.ItemsSource = null;
detailsgrid.SelectedIndex++;
Datalist = new List <theData>();
MethodSelected(sender, null);
}
else
{
MessageBox.Show("Please select check item to inspect");
}
}
