public List <DDCI_INFO> GetCustomerPartNumber(DDCI_INFO paramEntity = null)
{
List <DDCI_INFO> lstEntity = null;
try
{
if (!DB.IsNotNullOrEmpty())
{
return(lstEntity);
}
if (paramEntity.IsNotNullOrEmpty() && paramEntity.IDPK.IsNotNullOrEmpty())
{
lstEntity = (from row in DB.DDCI_INFO
where (Convert.ToBoolean(Convert.ToInt16(row.DELETE_FLAG)) == false || row.DELETE_FLAG == null) && row.IDPK == paramEntity.IDPK
select row).ToList <DDCI_INFO>();
}
else
{
lstEntity = (from row in DB.DDCI_INFO
where (Convert.ToBoolean(Convert.ToInt16(row.DELETE_FLAG)) == false || row.DELETE_FLAG == null)
select row).ToList <DDCI_INFO>();
}
if (lstEntity.IsNotNullOrEmpty())
{
lstEntity = lstEntity.GroupBy(row => ((row.CUST_DWG_NO == null || Convert.ToString(row.CUST_DWG_NO).Trim().Length == 0) ? null : Convert.ToString(row.CUST_DWG_NO).Trim())).Select(row => new DDCI_INFO()
{
CI_REFERENCE = row.First().CI_REFERENCE,
ENQU_RECD_ON = row.First().ENQU_RECD_ON,
FR_CS_DATE = row.First().FR_CS_DATE,
PROD_DESC = row.First().PROD_DESC,
CUST_CODE = row.First().CUST_CODE,
CUST_DWG_NO = ((row.First().CUST_DWG_NO == null || Convert.ToString(row.First().CUST_DWG_NO).Trim().Length == 0) ? null : Convert.ToString(row.First().CUST_DWG_NO).Trim()),
CUST_DWG_NO_ISSUE = row.First().CUST_DWG_NO_ISSUE,
EXPORT = row.First().EXPORT,
NUMBER_OFF = row.First().NUMBER_OFF,
POTENTIAL = row.First().POTENTIAL,
SFL_SHARE = row.First().SFL_SHARE,
REMARKS = row.First().REMARKS,
RESPONSIBILITY = row.First().RESPONSIBILITY,
PENDING = row.First().PENDING,
FEASIBILITY = row.First().FEASIBILITY,
REJECT_REASON = row.First().REJECT_REASON,
LOC_CODE = row.First().LOC_CODE,
CHEESE_WT = row.First().CHEESE_WT,
FINISH_WT = row.First().FINISH_WT,
FINISH_CODE = row.First().FINISH_CODE,
SUGGESTED_RM = row.First().SUGGESTED_RM,
RM_COST = row.First().RM_COST,
FINAL_COST = row.First().FINAL_COST,
COST_NOTES = row.First().COST_NOTES,
PROCESSED_BY = row.First().PROCESSED_BY,
ORDER_DT = row.First().ORDER_DT,
PRINT = row.First().PRINT,
ALLOT_PART_NO = row.First().ALLOT_PART_NO,
PART_NO_REQ_DATE = row.First().PART_NO_REQ_DATE,
CUST_STD_NO = row.First().CUST_STD_NO,
CUST_STD_DATE = row.First().CUST_STD_DATE,
AUTOPART = row.First().AUTOPART,
SAFTYPART = row.First().SAFTYPART,
APPLICATION = row.First().APPLICATION,
STATUS = row.First().STATUS,
CUSTOMER_NEED_DT = row.First().CUSTOMER_NEED_DT,
MKTG_COMMITED_DT = row.First().MKTG_COMMITED_DT,
PPAP_LEVEL = row.First().PPAP_LEVEL,
DEVL_METHOD = row.First().DEVL_METHOD,
PPAP_FORGING = row.First().PPAP_FORGING,
PPAP_SAMPLE = row.First().PPAP_SAMPLE,
PACKING = row.First().PACKING,
NATURE_PACKING = row.First().NATURE_PACKING,
SPL_CHAR = row.First().SPL_CHAR,
OTHER_CUST_REQ = row.First().OTHER_CUST_REQ,
ATP_DATE = row.First().ATP_DATE,
SIMILAR_PART_NO = row.First().SIMILAR_PART_NO,
GENERAL_REMARKS = row.First().GENERAL_REMARKS,
MONTHLY = row.First().MONTHLY,
MKTG_COMMITED_DATE = row.First().MKTG_COMMITED_DATE,
ROWID = row.First().ROWID,
DELETE_FLAG = row.First().DELETE_FLAG,
ENTERED_DATE = row.First().ENTERED_DATE,
ENTERED_BY = row.First().ENTERED_BY,
UPDATED_DATE = row.First().UPDATED_DATE,
UPDATED_BY = row.First().UPDATED_BY,
IDPK = row.First().IDPK,
COATING_CODE = row.First().COATING_CODE,
REALISATION = row.First().REALISATION,
NO_OF_PCS = row.First().NO_OF_PCS,
ZONE_CODE = row.First().ZONE_CODE,
RM_FACTOR = row.First().RM_FACTOR,
IS_COMBINED = row.First().IS_COMBINED,
}).OrderBy(row => ((row.CUST_DWG_NO == null || Convert.ToString(row.CUST_DWG_NO).Trim().Length == 0) ? null : Convert.ToString(row.CUST_DWG_NO).Trim())).Distinct <DDCI_INFO>().ToList <DDCI_INFO>();
}
}
catch (Exception ex)
{
throw ex.LogException();
}
return(lstEntity);
}
public CopyCIReferenceViewModel(UserInformation userInformation, WPF.MDI.MdiChild mdiChild, DDCI_INFO oldActiveEntity,
OperationMode operationMode)
{
bll = new FeasibleReportAndCostSheet(userInformation);
EnquiryReceivedOn = bll.ServerDateTime();
OldCIReferenceDataSource = bll.GetCIReferenceNumber().ToDataTable <V_CI_REFERENCE_NUMBER>().DefaultView;
CIReferenceZoneDataSource = bll.GetZoneDetails().ToDataTable <CI_REFERENCE_ZONE>().DefaultView;
OldActiveEntity = oldActiveEntity;
if (!OldActiveEntity.IsNotNullOrEmpty())
{
OldActiveEntity = new DDCI_INFO();
}
EntityPrimaryKey = oldActiveEntity.IDPK;
#region DropdownColumns Settins
CiReferenceZoneDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "CODE", ColumnDesc = "Zone Code", ColumnWidth = "25*"
},
new DropdownColumns()
{
ColumnName = "DESCRIPTION", ColumnDesc = "Zone", ColumnWidth = "75*"
}
};
OldCIReferenceDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "CI_REFERENCE", ColumnDesc = "CI Reference", ColumnWidth = "90"
},
new DropdownColumns()
{
ColumnName = "FRCS_DATE", ColumnDesc = "FRCS Date", ColumnWidth = "80"
},
new DropdownColumns()
{
ColumnName = "CUST_DWG_NO", ColumnDesc = "Drawing No.", ColumnWidth = "100"
},
new DropdownColumns()
{
ColumnName = "CUST_CODE", ColumnDesc = "Customer Code", ColumnWidth = "100"
},
new DropdownColumns()
{
ColumnName = "FINISH_CODE", ColumnDesc = "Finish Code", ColumnWidth = "80"
},
new DropdownColumns()
{
ColumnName = "CUST_DWG_NO_ISSUE", ColumnDesc = "Customer Drawing Issue No.", ColumnWidth = "175"
},
new DropdownColumns()
{
ColumnName = "CUST_STD_DATE", ColumnDesc = "Customer STD Date ", ColumnWidth = "150"
}
};
#endregion
this.ciReferenceEndEditCommand = new DelegateCommand(this.ciReferenceEndEdit);
this.oldReferenceSelectedItemChangedCommand = new DelegateCommand(this.OldCIReferenceChanged);
this.enquiryReceivedOnChangedCommand = new DelegateCommand(this.EnquiryReceivedOnChanged);
this.saveCommand = new DelegateCommand(this.SaveSubmitCommand);
this.ciReferenceZoneSelectedItemChangedCommand = new DelegateCommand(this.CIReferenceZoneChanged);
ActionPermission = bll.GetUserRights("CIReferenceCopy");
ActionPermission.AddNew = true;
ActionPermission.Edit = true;
ActionPermission.Save = true;
ActionPermission.Close = true;
ActionPermission.Print = true;
ActionMode = operationMode;
}
public System.Data.DataSet GetAllCustomerPartNos(PRD_MAST productMaster = null, DDCI_INFO customerInfo = null, DataRowView customerMaster = null)
{
System.Data.DataSet dsReport = null;
try
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT ");
sb.Append(" ROW_NUMBER() OVER(ORDER BY A.PART_NO) AS SNO, ");
sb.Append(" a.PART_NO, ");
sb.Append(" a.PART_DESC, ");
//sb.Append(" a.SIM_TO_STD_CD, ");
//sb.Append(" a.PRD_CLASS_CD, ");
//sb.Append(" a.MFG_STD, ");
//sb.Append(" a.ED_CD, ");
//sb.Append(" a.THREAD_CD, ");
//sb.Append(" a.DIA_CD, ");
//sb.Append(" a.QUALITY, ");
//sb.Append(" a.BIF_PROJ, ");
//sb.Append(" a.BIF_FORECAST, ");
//sb.Append(" a.FINISH_WT, ");
//sb.Append(" a.FINISH_WT_EST, ");
//sb.Append(" a.HEAT_TREATMENT_CD, ");
//sb.Append(" a.HEAT_TREATMENT_DESC, ");
//sb.Append(" a.PRD_GRP_CD, ");
//sb.Append(" a.MACHINE_CD, ");
//sb.Append(" a.ALLOT_DATE, ");
//sb.Append(" a.DOC_REL_DATE, ");
//sb.Append(" a.DOC_REL_REMARKS, ");
//sb.Append(" a.FAMILY, ");
//sb.Append(" a.HEAD_STYLE, ");
//sb.Append(" a.TYPE, ");
//sb.Append(" a.APPLICATION, ");
//sb.Append(" a.USER_CD, ");
//sb.Append(" a.THREAD_CLASS, ");
//sb.Append(" a.THREAD_STD, ");
//sb.Append(" a.PG_CATEGORY, ");
//sb.Append(" a.NOS_PER_PACK, ");
//sb.Append(" a.SAMP_SUBMIT_DATE, ");
//sb.Append(" a.ALLOTTED_BY, ");
//sb.Append(" a.PSW_ST, ");
//sb.Append(" a.DOC_REL_TYPE, ");
//sb.Append(" a.HOLD_ME, ");
//sb.Append(" a.ADDL_FEATURE, ");
//sb.Append(" a.KEYWORDS, ");
//sb.Append(" a.CANCEL_STATUS, ");
//sb.Append(" a.IDPK AS PRD_MAST_IDPK, ");
//sb.Append(" a.PART_CONFIG_ID, ");
//sb.Append(" a.LOC_CODE, ");
//sb.Append(" C.CI_REFERENCE, ");
//sb.Append(" C.ENQU_RECD_ON, ");
//sb.Append(" C.FR_CS_DATE, ");
//sb.Append(" C.PROD_DESC, ");
//sb.Append(" C.CUST_CODE, ");
sb.Append(" C.CUST_DWG_NO ");
//sb.Append(" C.CUST_DWG_NO_ISSUE, ");
//sb.Append(" C.EXPORT, ");
//sb.Append(" C.NUMBER_OFF, ");
//sb.Append(" C.POTENTIAL, ");
//sb.Append(" C.SFL_SHARE, ");
//sb.Append(" C.REMARKS, ");
//sb.Append(" C.RESPONSIBILITY, ");
//sb.Append(" C.PENDING, ");
//sb.Append(" C.FEASIBILITY, ");
//sb.Append(" C.REJECT_REASON, ");
//sb.Append(" C.LOC_CODE, ");
//sb.Append(" C.CHEESE_WT, ");
//sb.Append(" C.FINISH_WT, ");
//sb.Append(" C.FINISH_CODE, ");
//sb.Append(" C.SUGGESTED_RM, ");
//sb.Append(" C.RM_COST, ");
//sb.Append(" C.FINAL_COST, ");
//sb.Append(" C.COST_NOTES, ");
//sb.Append(" C.PROCESSED_BY, ");
//sb.Append(" C.ORDER_DT, ");
//sb.Append(" C.ALLOT_PART_NO, ");
//sb.Append(" C.PART_NO_REQ_DATE, ");
//sb.Append(" C.CUST_STD_NO, ");
//sb.Append(" C.CUST_STD_DATE, ");
//sb.Append(" C.AUTOPART, ");
//sb.Append(" C.SAFTYPART, ");
//sb.Append(" C.APPLICATION, ");
//sb.Append(" C.STATUS, ");
//sb.Append(" C.CUSTOMER_NEED_DT, ");
//sb.Append(" C.MKTG_COMMITED_DT, ");
//sb.Append(" C.PPAP_LEVEL, ");
//sb.Append(" C.DEVL_METHOD, ");
//sb.Append(" C.PPAP_FORGING, ");
//sb.Append(" C.PPAP_SAMPLE, ");
//sb.Append(" C.PACKING, ");
//sb.Append(" C.NATURE_PACKING, ");
//sb.Append(" C.SPL_CHAR, ");
//sb.Append(" C.OTHER_CUST_REQ, ");
//sb.Append(" C.ATP_DATE, ");
//sb.Append(" C.SIMILAR_PART_NO, ");
//sb.Append(" C.GENERAL_REMARKS, ");
//sb.Append(" C.MONTHLY, ");
//sb.Append(" C.MKTG_COMMITED_DATE, ");
//sb.Append(" C.IDPK AS CI_IDPK, ");
//sb.Append(" C.COATING_CODE, ");
//sb.Append(" C.REALISATION, ");
//sb.Append(" C.NO_OF_PCS, ");
//sb.Append(" C.ZONE_CODE, ");
//sb.Append(" C.RM_FACTOR, ");
//sb.Append(" C.IS_COMBINED ");
//sb.Append("FROM prd_mast a ");
//sb.Append("LEFT OUTER JOIN prd_ciref b ");
//sb.Append("ON a.part_no = b.part_no ");
//sb.Append("LEFT OUTER JOIN ddci_info c ");
//sb.Append("ON b.ci_ref = c.ci_reference");
//sb.Append(" where b.CURRENT_CIREF = 1 ");
sb.Append("FROM prd_mast a ,prd_ciref b ,ddci_info c where a.part_no = b.part_no and b.ci_ref=c.ci_reference and b.CURRENT_CIREF = 1");
if (customerInfo.IsNotNullOrEmpty() && customerInfo.CUST_DWG_NO.ToValueAsString().Trim().Length > 0)
{
sb.Append(" and RTRIM(LTRIM(cust_dwg_no)) like '" + customerInfo.CUST_DWG_NO.ToValueAsString() + "%'");
}
if (productMaster.IsNotNullOrEmpty() && productMaster.PART_NO.ToValueAsString().Trim().Length > 0)
{
sb.Append(" and RTRIM(LTRIM(a.part_no)) like '" + productMaster.PART_NO.ToValueAsString() + "%'");
}
if (customerMaster.IsNotNullOrEmpty() && customerMaster["CUST_CODE"].ToValueAsString().Trim().Length > 0)
{
sb.Append(" and RTRIM(LTRIM(cust_code)) = '" + customerMaster["CUST_CODE"].ToValueAsString() + "'");
}
sb.Append(" order by a.PART_NO");
List <StringBuilder> sqlList = new List <StringBuilder>()
{
sb
};
dsReport = Dal.GetDataSet(sqlList);
if (dsReport.IsNotNullOrEmpty() && dsReport.Tables.IsNotNullOrEmpty() && dsReport.Tables.Count > 0)
{
dsReport.Tables[0].TableName = "PRD_MAST_CI";
}
DataTable dtCompany = new DataTable();
dtCompany.TableName = "CompanyName";
dtCompany.Columns.Add("Name");
dtCompany.Columns.Add("ShortName");
dtCompany.Columns.Add("Phone");
dtCompany.Columns.Add("Fax");
dtCompany.Columns.Add("Mobile");
dtCompany.Columns.Add("EMail");
dtCompany.Columns.Add("Title");
dtCompany.Columns.Add("ReportTitle");
if (dsReport.IsNotNullOrEmpty())
{
dsReport.Tables.Add(dtCompany);
}
}
catch (Exception ex)
{
throw ex.LogException();
}
return(dsReport);
}