void SaveOpration() {
try {
foreach (var _opration in lstTempOpration)
{
GenaricRepository<OperationPool> _ORepository = new GenaricRepository<OperationPool>(new ItrackContext());
foreach (var item in _CompanyRepository.GetAll().Where(x => x.isDefaultCompany == true))
{
_Company.CompanyID = item.CompanyID;
}
_Operation.CompanyID = _Company.CompanyID;
_Operation.OperationPoolID = _opration.OprationID;
_Operation.OpationName = _opration.OparationName;
_Operation.SMV = _opration.SMV;
_Operation.SMVType = _opration.SMVType;
_Operation.MachineType = _opration.MachineType;
_Operation.Remark = _opration.Remark;
_Operation.OprationRole = _opration.OprationRole;
_Operation.OprationGrade = _opration.OprationGrade;
_Operation.PartName = _opration.PartName;
_ORepository.Insert(_Operation);
GenaricRepository<TempOpration> _tOpration = new GenaricRepository<TempOpration>(new ItrackContext());
TempOpration t = new TempOpration();
t.TempOprationID = _opration.TempOprationID;
_tOpration.Delete(t);
}
}
catch(Exception ex){
Debug.WriteLine(ex.Message);
}
}
void getUpdatedList() {
foreach (var item in lst.Where(x => x.Selected == true))
{
//lstselected.Add(new OperationListSelection(item.OprationNo, item.OprationName, item.SMV, item.WorkstationNo,item.Selected));
MessageBox.Show(item.OprationNo);
DividingPlanItem _item = new DividingPlanItem();
if (_item.DividingPlanHeaderID != 0)
{
_item.DividingPlanHeaderID = Convert.ToInt16(this.DividingPlanHeader);
}
else
{
_item.DividingPlanHeaderID = DividingPlanHeader;
}
_item.OprationNo = item.OprationNo;
_item.OprationName = item.OprationName;
_item.MachineType = item.MachineType;
_item.SMVType = item.SMVType;
_item.SMV = item.SMV;
_item.PartName = item.PartName;
_item.OperationRole = item.OperationRole;
_item.WorkstationNo = item.WorkstationNo;
GenaricRepository<DividingPlanItem> _pDidingItemRepository = new GenaricRepository<DividingPlanItem>(new ItrackContext());
_item.OpNo = _pDidingItemRepository.GetAll().ToList().Where(X => X.DividingPlanHeaderID == _item.DividingPlanHeaderID).Count();
if (_pDidingItemRepository.Insert(_item) == true)
{
}
}
MessageBox.Show("Save Sucessfully !", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public BindingList<OperationPool> ReadMyExcel(DevExpress.XtraEditors.ProgressBarControl bar )
{
TempOpration t = new TempOpration();
bar.Show();
bar.Properties.Maximum = lastRow;
bar.Properties.Step = 1;
oprationList.Clear();
// EmpList.Clear();
for (int index = 5; index <= lastRow; index++)
{
System.Array MyValues = (System.Array)MySheet.get_Range("A" + index.ToString(), "G" + index.ToString()).Cells.Value;
string opration = "";
string _OprationName = "";
string _MachineType = "None";
string _SMVtype = "none";
string _SMV = "";
string _PartName = "None";
string _OprationRole = "None";
string _OprationGrade = "None";
bool _hasData = false;
if (MySheet.Cells[index, 1].Value != null) {
opration = (string)(MySheet.Cells[index, 1].Value.ToString());
t.OprationID = opration;
_hasData = true;
// Debug.WriteLine(opration);
}
if (MySheet.Cells[index, 2].Value != null)
{
_OprationName = (string)(MySheet.Cells[index, 2].Value.ToString());
t.OparationName = _OprationName;
if (MySheet.Cells[index, 1].Value != null)
{
}
else {
t.PartName = t.OparationName;
}
}
if (MySheet.Cells[index, 3].Value != null)
{
_MachineType = (string)(MySheet.Cells[index, 3].Value.ToString());
t.MachineType = _MachineType;
// Debug.WriteLine(opration);
}
if (MySheet.Cells[index, 4].Value != null)
{
_SMVtype = (string)(MySheet.Cells[index, 4].Value.ToString());
t.SMVType = _SMVtype;
// D ebug.WriteLine(opration);
}
if (MySheet.Cells[index, 6].Value != null)
{
_SMV = (string)(MySheet.Cells[index, 6].Value.ToString());
_SMVtype = "M/C";
try {
t.SMV = Convert.ToDouble(_SMV);
t.SMVType = _SMVtype;
}
catch(Exception ex){
t.SMV = 0;
t.SMVType = _SMVtype;
Debug.WriteLine(ex.Message);
}
// D ebug.WriteLine(opration);
}
if (MySheet.Cells[index, 7].Value != null)
{
_SMV = (string)(MySheet.Cells[index, 7].Value.ToString());
_SMVtype = "M/A";
try {
t.SMV = Convert.ToDouble(_SMV);
t.SMVType = _SMVtype;
}
catch(Exception ex){
t.SMV = 0;
t.SMVType = _SMVtype;
Debug.WriteLine(ex.Message);
}
// D ebug.WriteLine(opration);
}
if (MySheet.Cells[index, 8].Value != null)
{
_OprationRole = (string)(MySheet.Cells[index, 8].Value.ToString());
t.OprationRole = _OprationRole;
// D ebug.WriteLine(opration);
}
else {
t.OprationRole ="None";
}
if (MySheet.Cells[index, 9].Value != null)
{
_OprationGrade = (string)(MySheet.Cells[index, 9].Value.ToString());
t.OprationGrade = _OprationGrade;
// D ebug.WriteLine(opration);
}
else {
t.OprationGrade = "None";
}
GenaricRepository<TempOpration> _TempOprationRepository = new GenaricRepository<TempOpration>(new ItrackContext());
bar.PerformStep();
if (_hasData == true && GetoprationByID(t.OprationID).Count == 0)
{
_TempOprationRepository.Insert(t);
}
//oprationList.Add(new OperationPool
// {
// OperationPoolID = MyValues.GetValue(1, 1).ToString(),
// OpationName = MyValues.GetValue(1, 2).ToString(),
// MachineType = MyValues.GetValue(1, 3).ToString(),
// SMVType = MyValues.GetValue(1, 4).ToString(),
// SMV = Convert.ToDouble(MyValues.GetValue(1, 4).ToString())
// });
}
bar.Hide();
return oprationList;
}
public static async Task<bool> ReadDevidingPlan() {
try {
DividingPlanTemp temp = new DividingPlanTemp();
bool _hasData= false;
if (MySheet.Cells[4, 2].Value != null)
{
temp.StyleID = (string)(MySheet.Cells[4, 2].Value.ToString());
_hasData = true;
// Debug.WriteLine(opration);
}
if (MySheet.Cells[4, 4].Value != null)
{
temp.LineNo = (string)(MySheet.Cells[4, 4].Value.ToString());
_hasData = true;
// Debug.WriteLine(opration);
}
if (MySheet.Cells[5, 6].Value != null)
{
temp.Target = (string)(MySheet.Cells[5, 6].Value.ToString());
_hasData = true;
}
if (MySheet.Cells[4, 6].Value != null)
{
string i = (string)(MySheet.Cells[4, 6].Value.ToString());
temp.TotalEmployee = i;
// Debug.WriteLine(opration);
}
if (MySheet.Cells[6, 6].Value != null)
{
temp.ProductionPerHour = (string)(MySheet.Cells[6, 6].Value.ToString());
_hasData = true;
// Debug.WriteLine(opration);
}
for (int index = 9; index <= lastRow; index++)
{
if (MySheet.Cells[index, 1].Value != null)
{
temp.OprationNo = (string)(MySheet.Cells[index, 1].Value.ToString());
_hasData = true;
// Debug.WriteLine(opration);
}
else {
temp.OprationNo = "";
_hasData = false;
}
if (MySheet.Cells[index, 2].Value != null)
{
temp.OprationName = (string)(MySheet.Cells[index, 2].Value.ToString());
// Debug.WriteLine(opration);
}
else {
temp.OprationName = "";
}
if (MySheet.Cells[index, 3].Value != null)
{
temp.MachineType = (string)(MySheet.Cells[index, 3].Value.ToString());
// Debug.WriteLine(opration);
}
else {
temp.MachineType = "";
}
if (MySheet.Cells[index, 4].Value != null)
{
temp.SMV = (string)(MySheet.Cells[index, 4].Value.ToString());
temp.SMVType = "M/C";
try
{
temp.SMV = temp.SMV;
temp.SMVType = temp.SMVType;
}
catch (Exception ex)
{
temp.SMV = "0";
temp.SMVType = temp.SMVType;
Debug.WriteLine(ex.Message);
}
// D ebug.WriteLine(opration);
}
if (MySheet.Cells[index, 5].Value != null)
{
temp.SMV = (string)(MySheet.Cells[index, 5].Value.ToString());
temp.SMVType = "M/A";
temp.MachineType ="None";
try
{
temp.SMV = temp.SMV;
temp.SMVType = temp.SMVType;
}
catch (Exception ex)
{
temp.SMV = "0";
temp.SMVType = temp.SMVType;
Debug.WriteLine(ex.Message);
}
// D ebug.WriteLine(opration);
}
GenaricRepository<DividingPlanTemp> _DevidingPlanRepository = new GenaricRepository<DividingPlanTemp>(new ItrackContext());
if (_hasData) {
_DevidingPlanRepository.Insert(temp);
Debug.WriteLine(temp.OprationNo + " | " + temp.OprationName + " | " + temp.MachineType + " | " + temp.SMVType + " | " + temp.SMV);
}
}
return true;
}
catch(Exception ex){
Debug.WriteLine(ex.Message);
return false;
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public bool addBundleDetails(BundleDetails _bandle,Int64 _bundleHeaderID) {
try {
GenaricRepository<BundleDetails> _BundleDetails = new GenaricRepository<BundleDetails>(new ItrackContext());
_bandle.BundleHeaderID = _bundleHeaderID;
_bandle.BundleTagPrintedBy = "None";
_bandle.BundleTagPrintedTime = "None";
_bandle.isBundleTagsPrinted = false;
_bandle.BundleStickerPrintedBy = "None";
_bandle.BundleStickerPrintedTime = "None";
_bandle.BundleTagPrintedBy = "None";
_BundleDetails.Insert(_bandle);
return true;
}
catch(Exception ex){
Debug.WriteLine(ex.Message);
return false;
}
}
public void genarateTestData() {
try {
for(int i = 0 ; i <6000000; i++){
GenaricRepository<OprationBarcodes> _OprationTagsRepo = new GenaricRepository<OprationBarcodes>(new ItrackContext());
_barcode.OprationBarcodesID = i.ToString().PadLeft(14, '0');
_barcode.OprationNO = "A";
_barcode.OprationRole = "";
_barcode.OprationGrade = "A";
_barcode.PartName = "";
_barcode.OparationName = "A"+i;
_barcode.EmployeeID = "None";
_barcode.isOparationComplete = false;
_barcode.OprationComplteAt = Convert.ToDateTime(DateTime.Now.ToShortDateString());
_barcode.BundleDetailsID = 449;
_OprationTagsRepo.Insert(_barcode);
}
}
catch(Exception ex){
Debug.WriteLine(ex.Message);
}
}
public static async Task<bool> AddIndividualProductionSummary(DateTime dayendDate,string _HourNo)
{
try
{
GenaricRepository<OprationBarcodes> _OperationBarcode = new GenaricRepository<OprationBarcodes>(new ItrackContext());
GenaricRepository<IndividualProductionSummery> _IndivialProudctionRepo = new GenaricRepository<IndividualProductionSummery>(new ItrackContext());
IndividualProductionSummery _individualProductionSummary = new IndividualProductionSummery();
var itemList = from items in _OperationBarcode.GetAll().ToList()
where items.isOparationComplete == true && items.OprationComplteAt.Day == dayendDate.Day && items.OprationComplteAt.Month == dayendDate.Month && items.OprationComplteAt.Year == dayendDate.Year && items.HourNo == _HourNo
group items by new { items.OprationComplteAt.Date, items.LineNo, items.EmployeeID, items.OprationNO, items.OparationName } into ItemG
select new { ItemG.Key.Date, ItemG.Key.LineNo, ItemG.Key.EmployeeID, ItemG.Key.OprationNO, ItemG.Key.OparationName, TotalItem = ItemG.Sum(c => c.BundleDetails.NoOfItem), SMV = ItemG.Sum(c => c.OperationPool.SMV * c.BundleDetails.NoOfItem) };
foreach (var summary in itemList)
{
Debug.WriteLine("Employee Name -" + summary.EmployeeID + " opration Name" + summary.OparationName + " No Of Item - " + summary.TotalItem + " Total SAH - " + summary.SMV / 60);
GenaricRepository<IndividualProductionSummery> _IndivialRepo = new GenaricRepository<IndividualProductionSummery>(new ItrackContext());
_individualProductionSummary.EmployeeID = summary.EmployeeID;
_individualProductionSummary.OprationNo = summary.OprationNO;
_individualProductionSummary.Pcs = Convert.ToInt16(summary.TotalItem);
_individualProductionSummary.EarnSAH = Convert.ToDouble((summary.SMV / 60).ToString("G7", CultureInfo.InvariantCulture));
_individualProductionSummary.Effiency = summary.SMV;
_individualProductionSummary.DayendHeaderID = Convert.ToString(dayendDate.Year + dayendDate.Month + dayendDate.Day);
_individualProductionSummary.IndividualProductionSummeryID = _individualProductionSummary.DayendHeaderID + summary.EmployeeID;
_IndivialRepo.Insert(_individualProductionSummary);
}
return true;
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return false;
}
}
public static async Task<bool> AddIndividualProductionSummary(DateTime dayendDate, string _HourNo,string In,string _Out)
{
try {
GenaricRepository<OprationBarcodes> _OperationBarcode = new GenaricRepository<OprationBarcodes>(new ItrackContext());
GenaricRepository<IndividualProductionSummery> _IndivialProudctionRepo = new GenaricRepository<IndividualProductionSummery>(new ItrackContext());
IndividualProductionDetails _individualProductionSummary = new IndividualProductionDetails();
var itemList = from items in _OperationBarcode.GetAll().ToList()
where items.isOparationComplete == true && items.OprationComplteAt.Day == dayendDate.Day && items.OprationComplteAt.Month == dayendDate.Month && items.OprationComplteAt.Year == dayendDate.Year && items.HourNo ==_HourNo
group items by new {items.BundleDetails.BundleHeader.CuttingItem.CuttingHeader.StyleID, items.OprationComplteAt.Date, items.LineNo, items.EmployeeID,items.WorkstationNo,items.OprationNO, items.OparationName,items.HourNo } into ItemG
select new {ItemG.Key.StyleID, ItemG.Key.Date, ItemG.Key.LineNo, ItemG.Key.EmployeeID,ItemG.Key.WorkstationNo,ItemG.Key.OprationNO, ItemG.Key.HourNo, ItemG.Key.OparationName,TotalItem = ItemG.Sum(c => c.BundleDetails.NoOfItem), SMV = ItemG.Sum(c => c.OperationPool.SMV*c.BundleDetails.NoOfItem) };
GenaricRepository<Company> _CompanyRepository = new GenaricRepository<Company>(new ItrackContext());
foreach (var item in _CompanyRepository.GetAll().Where(x => x.isDefaultCompany == true))
{
_individualProductionSummary.CompanyID = item.CompanyID;
}
foreach (var summary in itemList)
{
Debug.WriteLine("Employee Name -" +summary.EmployeeID +" opration Name"+ summary.OparationName +" No Of Item - " + summary.TotalItem + " Total SAH - " + summary.SMV/60);
GenaricRepository<IndividualProductionDetails> _IndivialRepo = new GenaricRepository<IndividualProductionDetails>(new ItrackContext());
_individualProductionSummary.EmployeeID = summary.EmployeeID;
_individualProductionSummary.Date = summary.Date;
_individualProductionSummary.SMV = summary.SMV/summary.TotalItem;
_individualProductionSummary.OperationNo = summary.OprationNO;
_individualProductionSummary.OperationName = summary.OparationName;
_individualProductionSummary.Pcs =Convert.ToInt16( summary.TotalItem);
_individualProductionSummary.SAH = Convert.ToDouble((_individualProductionSummary.SMV * summary.TotalItem / 60).ToString("G7", CultureInfo.InvariantCulture));
_individualProductionSummary.SAH =Convert.ToDouble( String.Format("{0:0.00}", _individualProductionSummary.SAH));
_individualProductionSummary.Efficiency = _individualProductionSummary.SAH / 1 * 100;
_individualProductionSummary.Efficiency = Convert.ToDouble(String.Format("{0:0.00}", _individualProductionSummary.Efficiency));
_individualProductionSummary.HourNo =Convert.ToInt16( _HourNo);
_individualProductionSummary.WorkstationNo = summary.WorkstationNo;
_individualProductionSummary.StyleNo = summary.StyleID;
if (summary.EmployeeID != null)
{
_IndivialRepo.Insert(_individualProductionSummary);
}
}
int i = 9;
//-------------------------------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------------------------------------------------
var SizeList = from items in _OperationBarcode.GetAll().ToList()
where items.isOparationComplete == true && items.OprationComplteAt.Day == dayendDate.Day && items.OprationComplteAt.Month == dayendDate.Month && items.OprationComplteAt.Year == dayendDate.Year && items.HourNo == _HourNo && (items.OprationNO == In || items.OprationNO == _Out)
group items by new { items.OprationComplteAt.Date, items.StyleNo, items.LineNo, items.BundleDetails.BundleHeader.CuttingItem.PoNo, items.HourNo, items.OprationNO, items.OprationRole, items.BundleDetails.BundleHeader.CuttingItem.Color, items.BundleDetails.BundleHeader.CuttingItem.Size } into ItemG
select new { ItemG.Key.Date, ItemG.Key.StyleNo, ItemG.Key.LineNo, ItemG.Key.PoNo, ItemG.Key.HourNo, ItemG.Key.OprationNO, ItemG.Key.OprationRole, ItemG.Key.Color, ItemG.Key.Size, TotalItem = ItemG.Sum(c => c.BundleDetails.NoOfItem), SMV = ItemG.Sum(c => c.OperationPool.SMV * c.BundleDetails.NoOfItem) };
DailyProduction _production =new DailyProduction();
foreach (var sizeItem in SizeList)
{
GenaricRepository<DailyProduction> _Indivial = new GenaricRepository<DailyProduction>(new ItrackContext());
_production.PoNo = sizeItem.PoNo;
_production.Date = sizeItem.Date;
_production.HourNo = Convert.ToInt16(sizeItem.HourNo);
_production.LineNo = sizeItem.LineNo;
_production.Color = sizeItem.Color;
_production.Size = sizeItem.Size;
_production.Type = sizeItem.OprationRole;
_production.Qty = Convert.ToInt16(sizeItem.TotalItem);
_production.StyleID = sizeItem.StyleNo;
_Indivial.Insert(_production);
}
return true;
}
catch(Exception ex){
Debug.WriteLine(ex.Message);
return false;
}
}
void saveOparation() {
try {
GenaricRepository<DividingPlanHeader> _dHeaderRepo = new GenaricRepository<DividingPlanHeader>(new ItrackContext());
DividingPlanHeader dHeader = new DividingPlanHeader();
dHeader.LineNo = txtLineNo.Text;
dHeader.ProductionPerHour =Convert.ToInt16( txtProductionPerHour.Text);
dHeader.StyleID = txtStyleNo.Text;
dHeader.TotalEmployee =Convert.ToInt16( txtTotalEmployee.Text);
dHeader.Target =Convert.ToInt16(txtTarget.Text);
_dHeaderRepo.Add(dHeader);
dHeader.DividingPlanheaderID = _dHeaderRepo.GetAll().ToList().Last().DividingPlanheaderID;
for (int i = 0; i < gridView3.RowCount; i++)
{
GenaricRepository<DividingPlanItem> _dItemRepo = new GenaricRepository<DividingPlanItem>(new ItrackContext());
DividingPlanItem dItem = new DividingPlanItem();
dItem.OprationNo = gridView3.GetRowCellValue(i, "OprationNo").ToString();
dItem.OprationName = gridView3.GetRowCellValue(i, "OprationName").ToString();
dItem.SMVType = gridView3.GetRowCellValue(i, "SMVType").ToString();
dItem.MachineType = gridView3.GetRowCellValue(i, "MachineType").ToString();
dItem.SMV =Convert.ToDouble( gridView3.GetRowCellValue(i, "SMV").ToString());
dItem.DividingPlanHeaderID = dHeader.DividingPlanheaderID;
dItem.PartName = gridView3.GetRowCellValue(i, "PartName").ToString();
string status = gridView3.GetRowCellValue(i, "Selected").ToString();
GenaricRepository<DividingPlanTemp> _dItemTempRepo = new GenaricRepository<DividingPlanTemp>(new ItrackContext());
DividingPlanTemp dTemp = new DividingPlanTemp();
dTemp.DividingPlanTempID = Convert.ToInt16(gridView3.GetRowCellValue(i, "DividingPlanTempID").ToString());
if (status == "True")
{
_dItemRepo.Insert(dItem);
_dItemTempRepo.Delete(dTemp);
}
else {
}
}
}
catch(Exception ex){
Debug.WriteLine(ex.Message);
}
}
