public List <DDCUST_MAST> GetCustomerDetails(DDCUST_MAST paramEntity = null)
{
List <DDCUST_MAST> lstEntity = null;
try
{
if (!DB.IsNotNullOrEmpty())
{
return(lstEntity);
}
if (paramEntity.IsNotNullOrEmpty() && paramEntity.CUST_CODE.IsNotNullOrEmpty())
{
lstEntity = (from row in DB.DDCUST_MAST
where (Convert.ToBoolean(Convert.ToInt16(row.DELETE_FLAG)) == false || row.DELETE_FLAG == null) && row.CUST_CODE == paramEntity.CUST_CODE
orderby row.CUST_CODE ascending
select row).ToList <DDCUST_MAST>();
}
else
{
lstEntity = (from row in DB.DDCUST_MAST
where (Convert.ToBoolean(Convert.ToInt16(row.DELETE_FLAG)) == false || row.DELETE_FLAG == null)
orderby row.CUST_CODE ascending
select row).ToList <DDCUST_MAST>();
}
}
catch (Exception ex)
{
throw ex.LogException();
}
return(lstEntity);
}
private void RefreshSubmitCommand()
{
string pgCategory = "";
ProductPGCategoryDataSource.RowFilter = "PG_CATEGORY='" + MandatoryFields.PG_CATEGORY + "'";
if (ProductPGCategoryDataSource.Count > 0)
{
pgCategory = ProductPGCategoryDataSource[0]["PG_CAT"].ToValueAsString();
}
ProductPGCategoryDataSource.RowFilter = null;
PRD_MAST productMaster = new PRD_MAST()
{
PART_NO = MandatoryFields.PART_NO,
PART_DESC = MandatoryFields.PART_DESC,
QUALITY = MandatoryFields.QUALITY,
PG_CATEGORY = pgCategory,
PSW_ST = pwsStatus
};
DDCUST_MAST customerMaster = new DDCUST_MAST()
{
CUST_CODE = (selectedCustomer.IsNotNullOrEmpty() ? selectedCustomer.CUST_CODE : -999999)
};
List <DDLOC_MAST> lstLocation = null;
if (SelectedItems.IsNotNullOrEmpty())
{
lstLocation = new List <DDLOC_MAST>();
foreach (object loc in SelectedItems.Values)
{
lstLocation.Add(new DDLOC_MAST()
{
LOC_CODE = loc.ToValueAsString()
});
}
}
DataSet dsReport = bll.GetAllPartNos(productMaster, customerMaster, lstLocation);
MandatoryFields.GRID_TITLE = REPORT_TITLE;
if (!dsReport.IsNotNullOrEmpty() || !dsReport.Tables.IsNotNullOrEmpty() || dsReport.Tables.Count <= 0)
{
return;
}
MandatoryFields.GridData = dsReport.Tables[0].DefaultView;
MandatoryFields.GRID_TITLE = REPORT_TITLE + " - " + MandatoryFields.GridData.Table.Rows.Count + " Entries";
}
public bool DeleteCustomerCode(decimal operCode, string nextAction, ref string message)
{
DDCUST_MAST ddCustMaster = (from c in DB.DDCUST_MAST
where c.CUST_CODE == operCode
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).SingleOrDefault <DDCUST_MAST>();
try
{
if (nextAction == "DELETE")
{
if (ddCustMaster != null)
{
if (ddCustMaster.DELETE_FLAG == true)
{
ddCustMaster.DELETE_FLAG = false;
}
else
{
ddCustMaster.DELETE_FLAG = true;
}
ddCustMaster.CUST_CODE = operCode;
// ddCustMaster.DELETE_FLAG = true;
ddCustMaster.UPDATED_DATE = DateTime.Now;
ddCustMaster.UPDATED_BY = userInformation.UserName;
// DB.DDCUST_MAST.DeleteOnSubmit(ddCustMaster);
DB.SubmitChanges();
message = PDMsg.DeletedSuccessfully;
}
else if (ddCustMaster == null)
{
message = PDMsg.NoRecordFound;
}
}
}
catch (Exception ex)
{
ex.LogException();
DB.DDCUST_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddCustMaster);
}
return(true);
}
public bool CheckCodeisEsxists(decimal operCode)
{
try
{
DDCUST_MAST ddCustMaster = (from c in DB.DDCUST_MAST
where c.CUST_CODE == operCode
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
//Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false
select c).SingleOrDefault <DDCUST_MAST>();
if (ddCustMaster != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ex.LogException();
return(false);
}
}
public frmrptPartNos(UserInformation userInformation, WPF.MDI.MdiChild mdiChild, PRD_MAST productMaster = null, ReportMISProductInformationModel productInformationModel = null, DDCUST_MAST customerMaster = null, List <DDLOC_MAST> lstLocation = null, bool refreshOnLoad = false, string title = "Customer Partno Wise Report")
{
InitializeComponent();
this.mdiChild = mdiChild;
vm = new ReportMISProductInformationViewModel(userInformation, mdiChild, productMaster, productInformationModel, customerMaster, lstLocation, refreshOnLoad, title);
this.DataContext = vm;
mdiChild.Closing += vm.CloseMethod;
//if (vm.CloseAction == null && mdiChild.IsNotNullOrEmpty())
// vm.CloseAction = new Action(() => mdiChild.Close());
}
public ReportMISCustomerPartNoWiseViewModel(UserInformation userInformation, WPF.MDI.MdiChild mdiChild, PRD_MAST productMaster = null, DDCI_INFO customerInfo = null, DDCUST_MAST customerMaster = null, bool refreshOnLoad = false, string title = REPORT_TITLE)
{
_userInformation = userInformation;
this.mdiChild = mdiChild;
bll = new ReportMISCustomerPartNoWise(userInformation);
MandatoryFields = new ReportMISCustomerPartNoWiseModel();
MandatoryFields.GRID_TITLE = REPORT_TITLE;
CustomersDataSource = bll.GetCustomerDetails().ToDataTable <DDCUST_MAST>().DefaultView;
this.customerSelectedItemChangedCommand = new DelegateCommand(this.CustomerChanged);
CustomerDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "CUST_CODE", ColumnDesc = "Customer Code", ColumnWidth = "25*"
},
new DropdownColumns()
{
ColumnName = "CUST_NAME", ColumnDesc = "Customer", ColumnWidth = "75*", IsDefaultSearchColumn = true
}
};
SFLPartNumbersDataSource = bll.GetPartNumber().ToDataTable <PRD_MAST>().DefaultView;
this.sflPartNumberSelectedItemChangedCommand = new DelegateCommand(this.SFLPartNumberChanged);
SFLPartNumberDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "PART_NO", ColumnDesc = "SFL Part Number", ColumnWidth = "1*"
},
};
this.printCommand = new DelegateCommand(this.PrintSubmitCommand);
this.refreshCommand = new DelegateCommand(this.RefreshSubmitCommand);
CustomerPartNumbersDataSource = bll.GetCustomerPartNumber().ToDataTable <DDCI_INFO>().DefaultView;
this.customerPartNumberSelectedItemChangedCommand = new DelegateCommand(this.CustomerPartNumberChanged);
CustomerPartNumberDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "CUST_DWG_NO", ColumnDesc = "Customer Part Number", ColumnWidth = "1*"
},
};
}
public ReportMISMFMViewModel(UserInformation userInformation, WPF.MDI.MdiChild mdiChild, PRD_MAST productMaster = null, DDCI_INFO customerInfo = null, DDCUST_MAST customerMaster = null, bool refreshOnLoad = false, string title = REPORT_TITLE)
{
CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name);
ci.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy";
ci.DateTimeFormat.DateSeparator = "/";
Thread.CurrentThread.CurrentCulture = ci;
_userInformation = userInformation;
this.mdiChild = mdiChild;
bll = new ReportMISMFM(userInformation);
MandatoryFields = new ReportMISMFMModel();
MandatoryFields.GRID_TITLE = REPORT_TITLE;
CustomersDataSource = bll.GetCustomerDetails().ToDataTable <DDCUST_MAST>().DefaultView;
this.customerSelectedItemChangedCommand = new DelegateCommand(this.CustomerChanged);
CustomerDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "CUST_CODE", ColumnDesc = "Customer Code", ColumnWidth = "25*"
},
new DropdownColumns()
{
ColumnName = "CUST_NAME", ColumnDesc = "Customer", ColumnWidth = "75*", IsDefaultSearchColumn = true
}
};
SFLPartNumbersDataSource = bll.GetPartNumber().ToDataTable <PRD_MAST>().DefaultView;
this.sflPartNumberSelectedItemChangedCommand = new DelegateCommand(this.SFLPartNumberChanged);
SFLPartNumberDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "PART_NO", ColumnDesc = "SFL Part Number", ColumnWidth = "1*"
},
};
this.printCommand = new DelegateCommand(this.PrintSubmitCommand);
this.refreshCommand = new DelegateCommand(this.RefreshSubmitCommand);
this.ExportCommand = new DelegateCommand(this.ExportToExcelData);
}
public frmrptMFM(UserInformation userInformation, WPF.MDI.MdiChild mdiChild, PRD_MAST productMaster = null, DDCI_INFO customerInfo = null, DDCUST_MAST customerMaster = null, bool refreshOnLoad = false, string title = "MFM")
{
InitializeComponent();
this.mdiChild = mdiChild;
vm = new ReportMISMFMViewModel(userInformation, mdiChild, productMaster, customerInfo, customerMaster, refreshOnLoad, title);
this.DataContext = vm;
mdiChild.Closing += vm.CloseMethod;
//if (vm.CloseAction == null && mdiChild.IsNotNullOrEmpty())
// vm.CloseAction = new Action(() => mdiChild.Close());
}
public System.Data.DataSet GetAllPartNos(PRD_MAST productMaster = null, DDCUST_MAST customerMaster = null, List <DDLOC_MAST> lstLocation = null)
{
System.Data.DataSet dsReport = null;
try
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT ROW_NUMBER() OVER(ORDER BY M.PART_NO) AS SNO, ");
sb.Append(" M.PART_NO, ");
sb.Append(" P.PART_DESC, ");
sb.Append(" T.CUST_NAME, ");
sb.Append(" P.BIF_PROJ, ");
sb.Append(" P.BIF_FORECAST, ");
sb.Append(" P.FINISH_WT, ");
sb.Append(" M.CHEESE_WT, ");
sb.Append(" M.RM_WT, ");
sb.Append(" P.PG_CATEGORY, ");
sb.Append(" P.QUALITY, ");
sb.Append(" P.SAMP_SUBMIT_DATE, ");
sb.Append(" P.PSW_ST, ");
sb.Append(" C.CUST_DWG_NO, ");
sb.Append(" P.DOC_REL_DATE ");
sb.Append("FROM dbo.PRD_MAST AS P ");
sb.Append("LEFT OUTER JOIN dbo.PRD_CIREF AS F ");
sb.Append("ON F.PART_NO = P.PART_NO ");
sb.Append("LEFT OUTER JOIN dbo.DDCI_INFO AS C ");
sb.Append("ON C.CI_REFERENCE = F.CI_REF, ");
sb.Append(" dbo.PROCESS_MAIN AS M, ");
sb.Append(" dbo.DDCUST_MAST AS T ");
sb.Append("WHERE P.PART_NO = M.PART_NO ");
sb.Append("AND M.CURRENT_PROC = 1 ");
sb.Append("AND T.CUST_CODE = C.CUST_CODE ");
if (customerMaster.IsNotNullOrEmpty() && customerMaster.CUST_CODE.IsNotNullOrEmpty() && customerMaster.CUST_CODE != -999999)
{
sb.Append(" AND C.CUST_CODE = '" + customerMaster.CUST_CODE + "' ");
}
if (productMaster.IsNotNullOrEmpty())
{
if (productMaster.PART_NO.IsNotNullOrEmpty())
{
sb.Append(" AND P.PART_NO LIKE '" + productMaster.PART_NO + "%' ");
}
if (productMaster.PART_DESC.IsNotNullOrEmpty())
{
sb.Append(" AND upper(P.PART_DESC) LIKE '%" + productMaster.PART_DESC.ToUpper() + "%' ");
}
if (productMaster.QUALITY.IsNotNullOrEmpty())
{
sb.Append(" AND P.QUALITY LIKE '" + productMaster.QUALITY + "%' ");
}
if (productMaster.PG_CATEGORY.IsNotNullOrEmpty())
{
sb.Append(" AND P.PG_CATEGORY = '" + productMaster.PG_CATEGORY + "' ");
}
if (productMaster.PSW_ST.IsNotNullOrEmpty() && (productMaster.PSW_ST.ToUpper() == "YES" || productMaster.PSW_ST.ToUpper() == "NO"))
{
sb.Append(" AND P.PSW_ST = '" + productMaster.PSW_ST + "' ");
}
if (productMaster.PSW_ST.IsNotNullOrEmpty() && (productMaster.PSW_ST.ToUpper() == "NONE"))
{
sb.Append(" AND P.PSW_ST IS NULL ");
}
}
if (lstLocation.IsNotNullOrEmpty() && lstLocation.Count > 0 && lstLocation.Count < 4)
{
string locsql = "";
foreach (DDLOC_MAST loc in lstLocation)
{
locsql = locsql + "(P.BIF_PROJ LIKE '" + loc.LOC_CODE + "%' OR P.BIF_FORECAST LIKE '" + loc.LOC_CODE + "%')";
if (lstLocation[lstLocation.Count - 1].GetHashCode() != loc.GetHashCode())
{
locsql = locsql + " OR ";
}
}
sb.Append(" AND (" + locsql + ") ");
}
sb.Append(" order by M.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);
}
public System.Data.DataSet GetAllMFM(string startDate, string endDate, PRD_MAST productMaster = null, DDCI_INFO customerInfo = null, DDCUST_MAST customerMaster = null)
{
System.Data.DataSet dsReport = null;
try
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT ROW_NUMBER() OVER(ORDER BY MFM_MAST.PART_NO) AS SNO, ");
sb.Append(" MFM_MAST.PART_NO, ");
sb.Append(" CAST(DOC_REL_DT_PLAN as varchar(10)) as DOC_REL_DT_PLAN, ");
sb.Append(" CAST(DOC_REL_DT_ACTUAL as varchar(10)) as DOC_REL_DT_ACTUAL, ");
sb.Append(" CAST(TOOLS_READY_DT_PLAN as varchar(10)) as TOOLS_READY_DT_PLAN, ");
sb.Append(" CAST(TOOLS_READY_ACTUAL_DT as varchar(10)) as TOOLS_READY_ACTUAL_DT, ");
sb.Append(" CAST(FORGING_PLAN_DT as varchar(10)) as FORGING_PLAN_DT, ");
sb.Append(" CAST(FORGING_ACTUAL_DT as varchar(10)) as FORGING_ACTUAL_DT, ");
sb.Append(" CAST(SECONDARY_PLAN_DT as varchar(10)) as SECONDARY_PLAN_DT, ");
sb.Append(" CAST(SECONDARY_ACTUAL_DT as varchar(10)) as SECONDARY_ACTUAL_DT, ");
sb.Append(" CAST(HEAT_TREATMENT_PLAN_DT as varchar(10)) as HEAT_TREATMENT_PLAN_DT, ");
sb.Append(" CAST(HEAT_TREATMENT_ACTUAL as varchar(10)) as HEAT_TREATMENT_ACTUAL, ");
sb.Append(" CAST(ISSR_PLAN_DT as varchar(10)) as ISSR_PLAN_DT, ");
sb.Append(" CAST(ISSR_ACTUAL_DT as varchar(10)) as ISSR_ACTUAL_DT, ");
sb.Append(" CAST(PPAP_PLAN as varchar(10)) as PPAP_PLAN, ");
sb.Append(" CAST(PPAP_ACTUAL_DT as varchar(10)) as PPAP_ACTUAL_DT, ");
sb.Append(" CAST(PSW_DATE as varchar(10)) as PSW_DATE, ");
sb.Append(" SAMPLE_QTY, ");
sb.Append(" RESP ");
sb.Append("FROM MFM_MAST ");
if (customerMaster.IsNotNullOrEmpty() && customerMaster.CUST_CODE.ToValueAsString().Trim().Length > 0)
{
sb.Append(" , ");
sb.Append(" prd_mast, ");
sb.Append(" prd_ciref, ");
sb.Append(" ddci_info ");
}
sb.Append(" WHERE 1 = 1 ");
sb.Append(" AND DOC_REL_DT_PLAN BETWEEN " + "'" + startDate + "'" + " AND " + "'" + endDate + "'");
if (customerMaster.IsNotNullOrEmpty() && customerMaster.CUST_CODE.ToValueAsString().Trim().Length > 0)
{
sb.Append(" AND prd_ciref.part_no = prd_mast.part_no ");
sb.Append(" AND mfm_mast.part_no = prd_mast.part_no ");
sb.Append(" AND ddci_info.ci_reference = prd_ciref.ci_ref AND prd_ciref.CURRENT_CIREF = 1 ");
//sb.Append(" AND ddci_info.ci_reference = prd_ciref.ci_ref");
sb.Append(" AND cust_code = '" + customerMaster.CUST_CODE.ToValueAsString() + "'");
}
if (productMaster.IsNotNullOrEmpty() && productMaster.PART_NO.ToValueAsString().Trim().Length > 0)
{
sb.Append(" and MFM_MAST.part_no like '" + productMaster.PART_NO.ToValueAsString() + "%'");
}
sb.Append(" order by MFM_MAST.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);
}
public ReportMISProductInformationViewModel(UserInformation userInformation, WPF.MDI.MdiChild mdiChild, PRD_MAST productMaster = null, ReportMISProductInformationModel productInformationModel = null, DDCUST_MAST customerMaster = null, List <DDLOC_MAST> lstLocation = null, bool refreshOnLoad = false, string title = REPORT_TITLE)
{
_userInformation = userInformation;
this.mdiChild = mdiChild;
bll = new ReportMISProductInformationWise(userInformation);
MandatoryFields = new ReportMISProductInformationModel();
MandatoryFields.GRID_TITLE = REPORT_TITLE;
CustomersDataSource = bll.GetCustomerDetails().ToDataTable <DDCUST_MAST>().DefaultView;
this.customerSelectedItemChangedCommand = new DelegateCommand(this.CustomerChanged);
CustomerDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "CUST_CODE", ColumnDesc = "Customer Code", ColumnWidth = "25*"
},
new DropdownColumns()
{
ColumnName = "CUST_NAME", ColumnDesc = "Customer", ColumnWidth = "75*", IsDefaultSearchColumn = true
}
};
SFLPartNumbersDataSource = bll.GetPartNumber().ToDataTable <PRD_MAST>().DefaultView;
this.sflPartNumberSelectedItemChangedCommand = new DelegateCommand(this.SFLPartNumberChanged);
SFLPartNumberDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "PART_NO", ColumnDesc = "SFL Part Number", ColumnWidth = "1*"
},
};
this.printCommand = new DelegateCommand(this.PrintSubmitCommand);
this.refreshCommand = new DelegateCommand(this.RefreshSubmitCommand);
Items = new Dictionary <string, object>();
SelectedItems = new Dictionary <string, object>();
SelectedItems.Add("All", "All");
foreach (DDLOC_MAST locationMaster in bll.GetLocationDetails())
{
Items.Add(locationMaster.LOCATION + "(" + locationMaster.LOC_CODE + ")", locationMaster.LOC_CODE);
SelectedItems.Add(locationMaster.LOCATION + "(" + locationMaster.LOC_CODE + ")", locationMaster.LOC_CODE);
}
DataTable dtPGCategory = bll.GetProductPGCategoryByPrimaryKey().ToDataTable <PG_CATEGORY>();
if (dtPGCategory.Columns.Contains("PG_CAT_DESC"))
{
dtPGCategory.Columns["PG_CAT_DESC"].ColumnName = "PG_CATEGORY";
}
ProductPGCategoryDataSource = dtPGCategory.DefaultView;
ProductPGCategoryDropDownItems = new ObservableCollection <DropdownColumns>()
{
new DropdownColumns()
{
ColumnName = "PG_CAT", ColumnDesc = "Code", ColumnWidth = "25*"
},
new DropdownColumns()
{
ColumnName = "PG_CATEGORY", ColumnDesc = " Product Group Category", ColumnWidth = "75*"
}
};
this.productPGCategorySelectedItemChangedCommand = new DelegateCommand(this.productPGCategoryChanged);
this.productPGCategoryEndEditCommand = new DelegateCommand(this.productPGCategoryEndEdit);
//Items.Add("Padi", "M");
//Items.Add("KPM", "K");
//Items.Add("Pondy", "Y");
//SelectedItems.Add("All", "All");
//SelectedItems.Add("Padi", "M");
//SelectedItems.Add("KPM", "K");
//SelectedItems.Add("Pondy", "Y");
}
public bool AddNewCustomerMaster(bool isActive, decimal operCode, string operDesc, string showInCost, string nextAction, ref string message)
{
bool _status = false;
DDCUST_MAST ddCustMaster = (from c in DB.DDCUST_MAST
where c.CUST_CODE == operCode
// where (c.CUST_CODE == operCode || operDesc.ToUpper().Replace(" ", "") == c.CUST_NAME.ToUpper().Replace(" ", ""))
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).FirstOrDefault <DDCUST_MAST>();
try
{
if (nextAction == "DELETE")
{
nextAction = "EDIT";
}
if (nextAction == "ADD")
{
if (ddCustMaster == null)
{
ddCustMaster = new DDCUST_MAST();
ddCustMaster.CUST_CODE = (decimal)operCode;
ddCustMaster.CUST_NAME = (string)operDesc;
ddCustMaster.DELETE_FLAG = isActive;
ddCustMaster.ENTERED_DATE = DateTime.Now;
ddCustMaster.ENTERED_BY = userInformation.UserName;
ddCustMaster.ROWID = Guid.NewGuid();
DB.DDCUST_MAST.InsertOnSubmit(ddCustMaster);
DB.SubmitChanges();
message = PDMsg.SavedSuccessfully;
}
else
{
if (CheckCodeisEsxists(operCode) == true)
{
message = PDMsg.AlreadyExists("Customer Code");
return(false);
}
else
{
message = PDMsg.AlreadyExists("Customer Code");
return(false);
}
//if (ddCustMaster.DELETE_FLAG != true)
//{
// ddCustMaster.CUST_NAME = (string)operDesc;
// ddCustMaster.UPDATED_DATE = DateTime.Now;
// ddCustMaster.DELETE_FLAG = isActive;
// ddCustMaster.UPDATED_BY = userInformation.UserName;
// DB.SubmitChanges();
// message = PDMsg.SavedSuccessfully;
//}
//else
//{
// //if (CheckCodeisEsxists(operCode) == true)
// //{
// // message = PDMsg.AlreadyExists("Customer Code");
// // return false;
// //}
// //else
// //{
// message = PDMsg.AlreadyExists("Customer Code");
// return false;
// // }
//}
// message = "Customer Code already Exists";
// return false;
}
}
else if (nextAction == "EDIT")
{
ddCustMaster.CUST_NAME = (string)operDesc;
ddCustMaster.UPDATED_DATE = DateTime.Now;
ddCustMaster.DELETE_FLAG = isActive;
ddCustMaster.UPDATED_BY = userInformation.UserName;
DB.SubmitChanges();
message = PDMsg.UpdatedSuccessfully;
}
_status = true;
}
catch (Exception ex)
{
ex.LogException();
if (nextAction == "ADD")
{
DB.DDCUST_MAST.DeleteOnSubmit(ddCustMaster);
}
else if (nextAction == "EDIT")
{
DB.DDCUST_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddCustMaster);
}
}
return(_status);
}
