public bool RetreieveCustomerName(MFMPlanModel mfmplan) { try { var innerQuery = (from o in DB.PRD_CIREF where o.PART_NO == mfmplan.PART_NO && o.CURRENT_CIREF == true select o.CI_REF).Distinct(); var ciinfo = (from a in DB.DDCI_INFO join b in DB.DDCUST_MAST on a.CUST_CODE equals b.CUST_CODE where innerQuery.Contains(a.CI_REFERENCE) select new { b.CUST_NAME }).FirstOrDefault(); if (ciinfo != null) { mfmplan.CUST_NAME = ciinfo.CUST_NAME; } else { mfmplan.CUST_NAME = ""; } return(true); } catch (Exception ex) { throw ex.LogException(); } }
public MFMPlanViewModel(UserInformation userinfo) { userInformation = userinfo; mfmplan = new MFMPlanModel(); bll = new MFMPlanBll(userinfo); this._windowLoadedCommand = new DelegateCommand(this.WindowLoaded); this._onPartNoSelectionChanged = new DelegateCommand(this.PartNoSelectionChanged); this._saveCommand = new DelegateCommand(this.Save); this._closeCommand = new DelegateCommand(this.Close); DropdownHeaders = new ObservableCollection <DropdownColumns> { new DropdownColumns { ColumnName = "PART_NO", ColumnDesc = "Part Number", ColumnWidth = "1*" }, new DropdownColumns { ColumnName = "PART_DESC", ColumnDesc = "Part Description", ColumnWidth = "1*" } }; DropDownItemsUsers = new ObservableCollection <DropdownColumns> { new DropdownColumns { ColumnName = "LOGIN", ColumnDesc = "Login ID", ColumnWidth = "1*" }, new DropdownColumns { ColumnName = "USER_FULL_NAME", ColumnDesc = "User Full Name", ColumnWidth = "1*" } }; }
public bool RetrieveMFMmast(MFMPlanModel mfmplan) { try { mfmplan.MFM_MASTER = (from o in DB.MFM_MAST where o.PART_NO == mfmplan.PART_NO && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) select o).FirstOrDefault <MFM_MAST>(); return(true); } catch (Exception ex) { throw ex.LogException(); } }
public bool UpdateMFMPlan(MFMPlanModel mfmplan) { try { MFM_MAST mfm = (from o in DB.MFM_MAST where o.PART_NO == mfmplan.PART_NO && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) select o).FirstOrDefault <MFM_MAST>(); if (mfm != null) { mfm.DOC_REL_DT_PLAN = mfmplan.DOC_REL_DT_PLAN; mfm.DOC_REL_DT_ACTUAL = mfmplan.DOC_REL_DT_ACTUAL; mfm.TIME_BOGAUGE_PLAN = mfmplan.TIME_BOGAUGE_PLAN; mfm.TIME_BOGAUGE_ACTUAL = mfmplan.TIME_BOGAUGE_ACTUAL; mfm.TOOLS_READY_DT_PLAN = mfmplan.TOOLS_READY_DT_PLAN; mfm.TOOLS_READY_ACTUAL_DT = mfmplan.TOOLS_READY_ACTUAL_DT; mfm.FORGING_PLAN_DT = mfmplan.FORGING_PLAN_DT; mfm.FORGING_ACTUAL_DT = mfmplan.FORGING_ACTUAL_DT; mfm.SECONDARY_PLAN_DT = mfmplan.SECONDARY_PLAN_DT; mfm.SECONDARY_ACTUAL_DT = mfmplan.SECONDARY_ACTUAL_DT; mfm.HEAT_TREATMENT_PLAN_DT = mfmplan.HEAT_TREATMENT_PLAN_DT; mfm.HEAT_TREATMENT_ACTUAL = mfmplan.HEAT_TREATMENT_ACTUAL; mfm.ISSR_PLAN_DT = mfmplan.ISSR_PLAN_DT; mfm.ISSR_ACTUAL_DT = mfmplan.ISSR_ACTUAL_DT; mfm.PPAP_PLAN = mfmplan.PPAP_PLAN; mfm.PPAP_ACTUAL_DT = mfmplan.PPAP_ACTUAL_DT; mfm.SAMPLE_QTY = mfmplan.SAMPLE_QTY.ToString().ToDecimalValue(); mfm.PSW_DATE = mfmplan.PSW_DATE; mfm.RESP = mfmplan.RESP; mfm.REMARKS = mfmplan.REMARKS; mfm.UPDATED_BY = userInformation.UserName; mfm.UPDATED_DATE = userInformation.Dal.ServerDateTime; DB.SubmitChanges(); } mfm = null; return(true); } catch (Exception ex) { throw ex.LogException(); } }
public bool GetProductMaster(MFMPlanModel mfmplan) { try { DataTable dt = new DataTable(); dt = ToDataTable((from o in DB.PRD_MAST where o.DOC_REL_DATE != null && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) select new { o.PART_NO, o.PART_DESC }).ToList()); if (dt != null) { mfmplan.DVProductMaster = dt.DefaultView; } else { mfmplan.DVProductMaster = null; } dt = ToDataTable((from o in DB.DDUSER_LIST where (o.USER_GROUP == "Designer" || o.USER_GROUP == "Manager") select new { o.LOGIN, o.USER_FULL_NAME }).ToList()); if (dt != null) { mfmplan.DVUsers = dt.DefaultView; } else { mfmplan.DVUsers = null; } return(true); } catch (Exception ex) { throw ex.LogException(); } }