public void gvPlantList_OnRowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
if ((!e.Row.RowType.ToString().Trim().Equals(System.Web.UI.WebControls.ListItemType.Header.ToString())) & (!e.Row.RowType.ToString().Trim().Equals(System.Web.UI.WebControls.ListItemType.Footer.ToString())))
{
System.Web.UI.WebControls.Label lbl = new Label();
System.Web.UI.WebControls.HiddenField hfField = new HiddenField();
try
{
lbl = (Label)e.Row.Cells[0].FindControl("lblBusorg_out");
if (!String.IsNullOrEmpty(lbl.Text))
{
BUSINESS_ORG busorg = SQMModelMgr.LookupBusOrg(entities, SessionManager.SessionContext.ActiveCompany().COMPANY_ID, Convert.ToDecimal(lbl.Text));
if (busorg != null)
{
lbl.Text = busorg.ORG_NAME;
}
}
lbl = (Label)e.Row.Cells[0].FindControl("lblStatus_out");
hfField = (HiddenField)e.Row.Cells[0].FindControl("hfStatus_out");
lbl.Text = WebSiteCommon.GetStatusString(hfField.Value);
}
catch
{
}
}
}
private void DoLaborList()
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
LocalOrg().LaborList = SQMModelMgr.SelectLaborTypeList(entities, SessionManager.EffLocation.Company.COMPANY_ID, busOrg.BUS_ORG_ID, 0);
uclSubLists.BindLaborList(LocalOrg().LaborList);
}
protected void lbSave_Click(object sender, EventArgs e)
{
BUSINESS_ORG bu = (BUSINESS_ORG)SessionManager.BusinessOrg;
BUSINESS_ORG busOrg = null;
if (!Page.IsValid)
{
return;
}
if (bu == null)
{
busOrg = new BUSINESS_ORG();
}
else
{
busOrg = SQMModelMgr.LookupBusOrg(entities, SessionManager.SessionContext.ActiveCompany().COMPANY_ID, bu.BUS_ORG_ID);
}
bool success;
decimal decVal;
busOrg.ORG_NAME = GetFindControlValue("tbOrgname", hfBase, out success);
busOrg.DUNS_CODE = GetFindControlValue("tbOrgLocCode", hfBase, out success);
if (decimal.TryParse(GetFindControlValue("tbThreshold", hfBase, out success), out decVal))
{
busOrg.THRESHOLD_AMT = decVal;
}
busOrg.PREFERRED_CURRENCY_CODE = GetFindControlValue("ddlCurrencyCodes", hfBase, out success);
busOrg.STATUS = GetFindControlValue("ddlStatus", hfBase, out success);
string sel = GetFindControlValue("ddlParentBusOrg", hfBase, out success);
if (string.IsNullOrEmpty(sel))
{
busOrg.PARENT_BUS_ORG_ID = Convert.ToInt32(null);
}
else
{
busOrg.PARENT_BUS_ORG_ID = Int32.Parse(sel);
}
busOrg = (BUSINESS_ORG)SQMModelMgr.SetObjectTimestamp((object)busOrg, SessionManager.UserContext.UserName(), busOrg.EntityState);
if (bu == null)
{
busOrg.COMPANY_ID = SessionManager.SessionContext.ActiveCompany().COMPANY_ID;
SQMModelMgr.CreateBusOrg(entities, busOrg);
SessionManager.BusOrgSearchCriteria = busOrg.ORG_NAME;
}
else
{
entities.SaveChanges();
}
SessionManager.BusinessOrg = busOrg;
SetupPage();
}
protected void tab_Click(string tabID, string cmdArg)
{
pnlSubLists.Visible = pnlPartProgram.Visible = pnlBusOrgEdit.Visible = pnlAdminEdit.Visible = pnlEscalation.Visible = false;
if (tabID != null)
{
SetActiveTab(SessionManager.CurrentSecondaryTab = tabID);
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
switch (cmdArg)
{
case "dept":
DoDeptList();
pnlSubLists.Visible = true;
break;
case "labor":
DoLaborList();
pnlSubLists.Visible = true;
break;
case "prog":
isEditMode = true;
uclProgramList.BindProgramList(SQMModelMgr.SelectPartProgramList(0, busOrg.BUS_ORG_ID));
pnlPartProgram.Visible = true;
break;
case "notify":
pnlEscalation.Visible = true;
List <TaskRecordType> recordTypeList = new List <TaskRecordType>();
if (UserContext.CheckAccess("SQM", "") >= AccessMode.Update)
{
recordTypeList.Add(TaskRecordType.InternalQualityIncident);
recordTypeList.Add(TaskRecordType.CustomerQualityIncident);
recordTypeList.Add(TaskRecordType.SupplierQualityIncident);
}
if (UserContext.CheckAccess("EHS", "") >= AccessMode.Admin)
{
recordTypeList.Add(TaskRecordType.ProfileInput);
recordTypeList.Add(TaskRecordType.ProfileInputApproval);
recordTypeList.Add(TaskRecordType.HealthSafetyIncident);
recordTypeList.Add(TaskRecordType.PreventativeAction);
}
if (recordTypeList.Count > 0 && !recordTypeList.Contains(TaskRecordType.ProblemCase))
{
recordTypeList.Add(TaskRecordType.ProblemCase);
}
uclNotifyList.BindNotifyList(entities, SessionManager.EffLocation.Company.COMPANY_ID, SessionManager.EffLocation.BusinessOrg.BUS_ORG_ID, 0, recordTypeList);
break;
default:
pnlBusOrgEdit.Visible = true;
DisplayBusOrg();
break;
}
}
}
public void rptOrgList_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Label lbl;
HiddenField hfField;
try
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)e.Item.DataItem;
lbl = (Label)e.Item.FindControl("lblParentBUHdr_out");
if (busOrg.PARENT_BUS_ORG_ID == busOrg.BUS_ORG_ID || busOrg.PARENT_BUS_ORG_ID < 1)
{
lbl.Text = "Top Level";
}
else
{
BUSINESS_ORG parentOrg = null;
if ((parentOrg = SQMModelMgr.LookupParentBusOrg(null, busOrg)) != null)
{
lbl.Text = parentOrg.ORG_NAME;
}
}
lbl = (Label)e.Item.FindControl("lblStatus");
hfField = (HiddenField)e.Item.FindControl("hfStatus");
lbl.Text = WebSiteCommon.GetStatusString(hfField.Value);
GridView gv = (GridView)e.Item.FindControl("gvPlantList");
gv.DataSource = busOrg.PLANT.OrderBy(l => l.PLANT_NAME).ToList(); // order by plant name
gv.DataBind();
Label divLabel = (Label)e.Item.FindControl("lblPlantListEmpty");
HtmlGenericControl div = (HtmlGenericControl)e.Item.FindControl("divPlantGVScroll");
SetGridViewDisplay(gv, divLabel, div, 20, gv.Rows.Count, "scrollArea");
if (UserContext.GetMaxScopePrivilege(SysScope.busloc) <= SysPriv.admin)
{
if (busOrg.PLANT.Count > 0)
{
Button btnAddPlant = (Button)gv.HeaderRow.FindControl("btnAddPlant");
btnAddPlant.CommandArgument = busOrg.BUS_ORG_ID.ToString();
btnAddPlant.Visible = true;
}
else
{
Button btnAddPlant = (Button)e.Item.FindControl("btnAddPlantEmpty");
btnAddPlant.CommandArgument = busOrg.BUS_ORG_ID.ToString();
btnAddPlant.Visible = true;
}
}
}
catch
{
}
}
}
private void SetupPage()
{
PLANT plant = (PLANT)SessionManager.EffLocation.Plant;
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
isEditMode = false;
LocalOrg().EditObject = null;
DropDownList ddl;
HiddenField hdCurrentActiveTab = (HiddenField)this.Form.Parent.FindControl("form1").FindControl("ContentPlaceHolder1").FindControl("hdCurrentActiveSecondaryTab");
uclItemHdr.DisplayPlant(busOrg, plant);
List <BUSINESS_ORG> parent_orgs = SQMModelMgr.SelectBusOrgList(entities, SessionManager.EffLocation.Company.COMPANY_ID, 0, true);
ddl = (DropDownList)hfBase.FindControl("ddlParentBusOrg");
ddl.DataSource = parent_orgs;
ddl.DataTextField = "ORG_NAME";
ddl.DataValueField = "BUS_ORG_ID";
ddl.DataBind();
ddl.SelectedIndex = 0;
if (SessionManager.EffLocation != null && SessionManager.EffLocation.BusinessOrg != null && ddl.Items.FindByValue(SessionManager.EffLocation.BusinessOrg.BUS_ORG_ID.ToString()) != null)
{
ddl.SelectedValue = SessionManager.EffLocation.BusinessOrg.BUS_ORG_ID.ToString();
}
ddlLocationType.Items.AddRange(WebSiteCommon.PopulateDropDownListItems("locationType"));
ddlCountryCode.Items.AddRange(WebSiteCommon.PopulateDropDownListItems("countryCode"));
ddlCountryCode.Items.Insert(0, new ListItem("", ""));
ddlPowerSourcedRegion.Items.AddRange(WebSiteCommon.PopulateDropDownListItems("powerSourcedRegion"));
ddlPowerSourcedRegion.Items.Insert(0, new ListItem("", ""));
ddl = (DropDownList)hfBase.FindControl("ddlPlantCurrencyCodes");
SQMBasePage.FillCurrencyDDL(ddl, "USD");
ddl = (DropDownList)hfBase.FindControl("ddlPlantTimezone");
List <Settings> time_zones = SQMSettings.TimeZone;
ddl.DataSource = time_zones;
ddl.DataTextField = "long_desc";
ddl.DataValueField = "code";
ddl.DataBind();
ddl.SelectedValue = "035";
ddlLocalLanguage.DataSource = SQMModelMgr.SelectLanguageList(entities, true);
ddlLocalLanguage.DataTextField = "LANGUAGE_NAME";
ddlLocalLanguage.DataValueField = "LANGUAGE_ID";
ddlLocalLanguage.DataBind();
ddlLocalLanguage.SelectedIndex = 0;
SetStatusList("ddlPlantStatus", "A");
tab_Click("lbPLantDetail_tab", "");
}
protected void uclAdminList_OnDeptClick(decimal deptID)
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
DEPARTMENT dept = SQMModelMgr.LookupDepartment(entities, SessionManager.EffLocation.Company.COMPANY_ID, busOrg.BUS_ORG_ID, 0, deptID, "", false);
uclSubLists.ToggleVisible(null);
pnlAdminEdit.Visible = true;
uclAdminEdit.BindDeptartment(dept);
LocalOrg().EditObject = dept;
}
protected void uclAdminList_OnLaborClick(decimal laborID)
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
LABOR_TYPE labor = SQMModelMgr.LookupLaborType(entities, SessionManager.EffLocation.Company.COMPANY_ID, busOrg.BUS_ORG_ID, 0, laborID, "", false);
uclSubLists.ToggleVisible(null);
pnlAdminEdit.Visible = true;
uclAdminEdit.BindLaborType(labor);
LocalOrg().EditObject = labor;
}
public void DisplayPlant(BUSINESS_ORG busOrg, PLANT plant)
{
pnlPlantHdr.Visible = true;
lblPlantOrgName_out.Text = busOrg.ORG_NAME;
if (plant != null)
{
lblPlantName_out.Text = plant.PLANT_NAME;
lblLocCodePlant_out.Text = plant.DUNS_CODE;
lblLocationType_out.Text = WebSiteCommon.GetXlatValue("locationType", plant.LOCATION_TYPE);
}
}
private void DisplayBusOrg()
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
DropDownList ddl = (DropDownList)hfBase.FindControl("ddlCurrencyCodes");
if (ddl.Items.Count == 0)
{
SQMBasePage.FillCurrencyDDL(ddl, "USD");
List <BUSINESS_ORG> parent_orgs = SQMModelMgr.SelectBusOrgList(entities, SessionManager.EffLocation.Company.COMPANY_ID, 0, true);
ddl = (DropDownList)hfBase.FindControl("ddlParentBusOrg");
ddl.DataSource = parent_orgs;
ddl.DataTextField = "ORG_NAME";
ddl.DataValueField = "BUS_ORG_ID";
ddl.DataBind();
List <Settings> status_codes = SQMSettings.Status;
ddl = (DropDownList)hfBase.FindControl("ddlStatus");
ddl.DataSource = status_codes;
ddl.DataTextField = "short_desc";
ddl.DataValueField = "code";
ddl.DataBind();
}
if (busOrg != null)
{
if (busOrg.PARENT_BUS_ORG_ID == busOrg.BUS_ORG_ID || busOrg.PARENT_BUS_ORG_ID < 1)
{
SetFindControlValue("lblParentBU_out", hfBase, "Top Level");
}
else
{
if (SessionManager.ParentBusinessOrg == null)
{
SessionManager.ParentBusinessOrg = SQMModelMgr.LookupParentBusOrg(entities, busOrg);
}
BUSINESS_ORG parentOrg = (BUSINESS_ORG)SessionManager.ParentBusinessOrg;
SetFindControlValue("lblParentBU_out", hfBase, parentOrg.ORG_NAME);
}
// editable fields
SetFindControlValue("tbOrgname", hfBase, busOrg.ORG_NAME);
SetFindControlValue("tbOrgLocCode", hfBase, busOrg.DUNS_CODE);
SetFindControlValue("ddlCurrencyCodes", hfBase, busOrg.PREFERRED_CURRENCY_CODE);
SetFindControlValue("ddlStatus", hfBase, busOrg.STATUS);
if (busOrg.PARENT_BUS_ORG_ID > 0)
{
SetFindControlValue("ddlParentBusOrg", hfBase, busOrg.PARENT_BUS_ORG_ID.ToString());
}
SetFindControlValue("lblLastUpdate_out", hfBase, busOrg.LAST_UPD_BY);
lblLastUpdateDate_out.Text = SQMBasePage.FormatDate(WebSiteCommon.LocalTime((DateTime)busOrg.LAST_UPD_DT, SessionManager.UserContext.TimeZoneID), "d", false);
}
}
protected void PreviewFile(object sender, EventArgs e)
{
byte[] fileContent;
if (ddlDataType.SelectedValue.Equals(""))
{
SetStatusMessage("You must select a file type from the drop down list");
}
else if (ddlPlantSelect.SelectedIndex == 0 && ddlDataType.SelectedValue.Equals("RECEIPT"))
{
SetStatusMessage("You must select a Receiving Location to upload a receipt record");
}
else
{
// validate the date in the select control
periodYear = 0;
periodMonth = 0;
List <SETTINGS> sets = SQMSettings.SelectSettingsGroup("FILE_UPLOAD", ""); // ABW 20140805
string fileName = ddlDataType.SelectedValue.ToString() + ".TXT";
int primaryCompany = Convert.ToInt32(sets.Find(x => x.SETTING_CD == "CompanyID").VALUE);
PSsqmEntities Entities = new PSsqmEntities();
BUSINESS_ORG busOrg = SQMModelMgr.LookupBusOrg(Entities, primaryCompany, "", true, false);
selectedFile = tbFileSelected.Text = flUpload.FileName;
int fileLen = flUpload.PostedFile.ContentLength;
fileContent = new byte[Convert.ToInt32(fileLen)];
int nBytes = flUpload.PostedFile.InputStream.Read(fileContent, 0, Convert.ToInt32(fileLen));
fileDelimiter = sets.Find(x => x.SETTING_CD == "FileDelimiter1").VALUE.ToCharArray();
plantDataMultiplier = 1;
//fileReader = new SQMFileReader().InitializeCSV(1, flUpload.PostedFile.FileName, fileContent, fileDelimiter, plantDataMultiplier);
fileReader = new SQMFileReader().InitializeCSV(primaryCompany, fileName, fileContent, fileDelimiter, plantDataMultiplier, periodYear, periodMonth, busOrg.PREFERRED_CURRENCY_CODE);
using (StreamReader sr = new StreamReader(fileReader.FileStream))
{
string line;
int lineNo = 0;
while ((line = sr.ReadLine()) != null)
{
fileReader.PreviewList.Add(line);
}
gvPreview.DataSource = fileReader.PreviewList;
gvPreview.DataBind();
gvPreview.Visible = true;
gvExcelPreview.Visible = false;
}
}
if (ddlDataType.SelectedValue.Equals("RECEIPT"))
{
dvPlantSelect.Style.Add("display", "inline");
}
}
protected void SaveBusOrg()
{
BUSINESS_ORG bu = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
BUSINESS_ORG busOrg = null;
if (!Page.IsValid)
{
return;
}
if (bu == null)
{
busOrg = SQMModelMgr.CreateBusOrg(entities, SessionManager.EffLocation.Company.COMPANY_ID, "");
}
else
{
busOrg = SQMModelMgr.LookupBusOrg(entities, SessionManager.EffLocation.Company.COMPANY_ID, bu.BUS_ORG_ID);
}
bool success;
decimal decVal;
busOrg.ORG_NAME = GetFindControlValue("tbOrgname", hfBase, out success);
busOrg.DUNS_CODE = GetFindControlValue("tbOrgLocCode", hfBase, out success);
busOrg.PREFERRED_CURRENCY_CODE = GetFindControlValue("ddlCurrencyCodes", hfBase, out success);
busOrg.STATUS = GetFindControlValue("ddlStatus", hfBase, out success);
string sel = GetFindControlValue("ddlParentBusOrg", hfBase, out success);
if (string.IsNullOrEmpty(sel))
{
busOrg.PARENT_BUS_ORG_ID = Convert.ToInt32(null);
}
else
{
busOrg.PARENT_BUS_ORG_ID = Int32.Parse(sel);
}
busOrg = (BUSINESS_ORG)SQMModelMgr.SetObjectTimestamp((object)busOrg, SessionManager.UserContext.UserName(), busOrg.EntityState);
entities.SaveChanges();
SessionManager.EffLocation.BusinessOrg = busOrg;
// SetupPage();
}
private void SetupPage()
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.BusinessOrg;
pnlBusOrgDetail.Visible = true;
// bu summary section
SetFindControlValue("lblOrgName_out", hfBase, busOrg.ORG_NAME);
SetFindControlValue("lblLocCode_out", hfBase, busOrg.DUNS_CODE);
SetFindControlValue("lblCurrency_out", hfBase, busOrg.PREFERRED_CURRENCY_CODE);
SetFindControlValue("lblCaseThreshold_out", hfBase, busOrg.THRESHOLD_AMT.ToString());
SetFindControlValue("lblStatus_out", hfBase, WebSiteCommon.GetStatusString(busOrg.STATUS));
SetFindControlValue("lblUpdatedBy_out", hfBase, busOrg.LAST_UPD_BY);
SetFindControlValue("lblUpdatedDate_out", hfBase, WebSiteCommon.LocalTime((DateTime)busOrg.LAST_UPD_DT, SessionManager.UserContext.TimeZoneID).ToString());
if (busOrg.PARENT_BUS_ORG_ID == busOrg.BUS_ORG_ID || busOrg.PARENT_BUS_ORG_ID < 1)
{
SetFindControlValue("lblParentBU_out", hfBase, "Top Level");
}
else
{
if (SessionManager.ParentBusinessOrg == null)
{
SessionManager.ParentBusinessOrg = SQMModelMgr.LookupParentBusOrg(entities, busOrg);
}
BUSINESS_ORG parentOrg = (BUSINESS_ORG)SessionManager.ParentBusinessOrg;
SetFindControlValue("lblParentBU_out", hfBase, parentOrg.ORG_NAME);
}
// editable fields
SetFindControlValue("tbOrgname", hfBase, busOrg.ORG_NAME);
SetFindControlValue("tbOrgLocCode", hfBase, busOrg.DUNS_CODE);
SetFindControlValue("tbThreshold", hfBase, busOrg.THRESHOLD_AMT.ToString());
SetFindControlValue("ddlCurrencyCodes", hfBase, busOrg.PREFERRED_CURRENCY_CODE);
SetFindControlValue("ddlStatus", hfBase, busOrg.STATUS);
if (busOrg.PARENT_BUS_ORG_ID > 0)
{
SetFindControlValue("ddlParentBusOrg", hfBase, busOrg.PARENT_BUS_ORG_ID.ToString());
}
SetFindControlValue("lblLastUpdate_out", hfBase, busOrg.LAST_UPD_BY);
SetFindControlValue("lblLastUpdateDate_out", hfBase, WebSiteCommon.LocalTime((DateTime)busOrg.LAST_UPD_DT, SessionManager.UserContext.TimeZoneID).ToString());
}
public void gvUserList_OnRowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
if ((!e.Row.RowType.ToString().Trim().Equals(System.Web.UI.WebControls.ListItemType.Header.ToString())) & (!e.Row.RowType.ToString().Trim().Equals(System.Web.UI.WebControls.ListItemType.Footer.ToString())))
{
System.Web.UI.WebControls.Label lbl = new Label();
System.Web.UI.WebControls.HiddenField hfField = new HiddenField();
try
{
try
{
hfField = (HiddenField)e.Row.Cells[0].FindControl("hfBusOrg_out");
decimal busorgID = Convert.ToDecimal(hfField.Value);
if (busorgID > 0)
{
BUSINESS_ORG busOrg = busorgList.FirstOrDefault(b => (b.BUS_ORG_ID == busorgID));
if (busOrg != null)
{
lbl = (Label)e.Row.Cells[0].FindControl("lblBusOrg_out");
lbl.Text = busOrg.ORG_NAME;
}
}
}
catch
{
}
lbl = (Label)e.Row.Cells[0].FindControl("lblStatus_out");
hfField = (HiddenField)e.Row.Cells[0].FindControl("hfStatus_out");
lbl.Text = WebSiteCommon.GetStatusString(hfField.Value);
lbl = (Label)e.Row.Cells[0].FindControl("lblLastUpd_out");
hfField = (HiddenField)e.Row.Cells[0].FindControl("hfLastUpd_out");
DateTime dt = new DateTime();
dt = Convert.ToDateTime(hfField.Value);
lbl.Text = dt.ToShortDateString();
}
catch
{
}
}
}
protected void tab_Click(string tabID, string cmdArg)
{
pnlSubLists.Visible = pnlPartProgram.Visible = pnlBusOrgEdit.Visible = pnlAdminEdit.Visible = pnlEscalation.Visible = false;
if (tabID != null)
{
SetActiveTab(SessionManager.CurrentSecondaryTab = tabID);
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
switch (cmdArg)
{
case "dept":
DoDeptList();
pnlSubLists.Visible = true;
break;
case "labor":
DoLaborList();
pnlSubLists.Visible = true;
break;
case "prog":
isEditMode = true;
uclProgramList.BindProgramList(SQMModelMgr.SelectPartProgramList(0, busOrg.BUS_ORG_ID));
pnlPartProgram.Visible = true;
break;
case "notify":
pnlEscalation.Visible = true;
UpdateNotifyActionList("");
break;
default:
pnlBusOrgEdit.Visible = true;
DisplayBusOrg();
break;
}
}
}
protected void SaveDept()
{
bool success;
if (uclAdminEdit.IsNew)
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
DEPARTMENT deptNew = new DEPARTMENT();
deptNew = uclAdminEdit.ReadDepartment(deptNew);
LocalOrg().DeptList.Add(SQMModelMgr.CreateDepartment(entities, busOrg, deptNew, SessionManager.UserContext.UserName()));
}
else
{
DEPARTMENT dept = (DEPARTMENT)LocalOrg().EditObject;
dept = uclAdminEdit.ReadDepartment(dept);
SQMModelMgr.UpdateDepartment(entities, dept, SessionManager.UserContext.UserName());
LocalOrg().DeptList[LocalOrg().DeptList.FindIndex(d => (d.DEPT_ID == dept.DEPT_ID))] = dept;
}
LocalOrg().EditObject = null;
DoDeptList();
pnlAdminEdit.Visible = false;
}
public void DisplayBusOrg(COMPANY company, BUSINESS_ORG busOrg)
{
pnlBusOrgHdr.Visible = true;
lblOrgName_out.Text = busOrg.ORG_NAME;
lblLocCode_out.Text = busOrg.DUNS_CODE;
if (busOrg.PARENT_BUS_ORG_ID == busOrg.BUS_ORG_ID || busOrg.PARENT_BUS_ORG_ID < 1)
{
lblParentBU_out.Text = "Top Level";
}
else
{
if (SessionManager.ParentBusinessOrg == null)
{
if ((SessionManager.ParentBusinessOrg = SQMModelMgr.LookupParentBusOrg(null, busOrg)) == null)
{
SessionManager.ParentBusinessOrg = busOrg;
}
}
BUSINESS_ORG parentOrg = (BUSINESS_ORG)SessionManager.ParentBusinessOrg;
lblParentBU_out.Text = parentOrg.ORG_NAME;
}
}
protected void SaveLabor()
{
bool success;
if (uclAdminEdit.IsNew)
{
BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg;
LABOR_TYPE laborNew = new LABOR_TYPE();
laborNew = uclAdminEdit.ReadLaborType(laborNew);
LocalOrg().LaborList.Add(SQMModelMgr.CreateLaborType(entities, busOrg, laborNew, SessionManager.UserContext.UserName()));
}
else
{
LABOR_TYPE labor = (LABOR_TYPE)LocalOrg().EditObject;
labor = SQMModelMgr.LookupLaborType(entities, (decimal)labor.COMPANY_ID, (decimal)labor.BUS_ORG_ID, 0, (decimal)labor.LABOR_TYP_ID, "", false);
labor = uclAdminEdit.ReadLaborType(labor);
SQMModelMgr.UpdateLaborType(entities, labor, SessionManager.UserContext.UserName());
LocalOrg().LaborList[LocalOrg().LaborList.FindIndex(d => (d.LABOR_TYP_ID == labor.LABOR_TYP_ID))] = labor;
}
LocalOrg().EditObject = null;
DoLaborList();
pnlAdminEdit.Visible = false;
}
public void gvBusOrgList_OnRowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
if ((!e.Row.RowType.ToString().Trim().Equals(System.Web.UI.WebControls.ListItemType.Header.ToString())) & (!e.Row.RowType.ToString().Trim().Equals(System.Web.UI.WebControls.ListItemType.Footer.ToString())))
{
System.Web.UI.WebControls.Label lbl = new Label();
System.Web.UI.WebControls.HiddenField hfField = new HiddenField();
try
{
lbl = (Label)e.Row.Cells[0].FindControl("lblStatus");
hfField = (HiddenField)e.Row.Cells[0].FindControl("hfStatus");
lbl.Text = WebSiteCommon.GetStatusString(hfField.Value);
BUSINESS_ORG busOrg = orgList[e.Row.RowIndex];
GridView gv = (GridView)e.Row.Cells[0].FindControl("gvPlantGrid");
gv.DataSource = busOrg.PLANT;
gv.DataBind();
totalRowCount += gv.Rows.Count;
}
catch
{
}
}
}
protected void DisplayIssue()
{
tbPartNumber.Text = qualityIssue.Part.PART_NUM;
tbSupplier.Text = qualityIssue.Supplier.COMPANY_NAME;
gvQISamples.DataSource = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE;
gvQISamples.DataBind();
if (!qualityIssue.IsNew)
{
// PROB_DEFINE probDefine = new PROB_DEFINE();
// probDefine = qualityIssue.UpdateProblemDefinition(probDefine);
lblIssueDate_out.Text = WebSiteCommon.LocalTime((DateTime)qualityIssue.Incident.CREATE_DT, SessionManager.UserContext.TimeZoneID).ToString();
uclSearchBar.TitleItem.Text = qualityIssue.IssueID;
uclSearchBar.TitleItem.Visible = lblIssueDate_out.Visible = true;
tbDateDetected.Text = WebSiteCommon.FormatDateString(WebSiteCommon.LocalTime(qualityIssue.Incident.INCIDENT_DT, SessionManager.UserContext.TimeZoneID), false);
tbIssueDesc.Text = qualityIssue.Incident.DESCRIPTION;
SetListSelectedTextValue(ddlQualityIssueType, qualityIssue.IssueOccur.PROBLEM_TYPE);
if (!string.IsNullOrEmpty(qualityIssue.IssueOccur.SOURCE))
{
rblSource.SelectedValue = qualityIssue.IssueOccur.SOURCE;
}
BUSINESS_ORG orginBusOrg = SQMModelMgr.LookupBusOrg((decimal)qualityIssue.Incident.BUS_ORG_ID);
if (orginBusOrg == null)
{
lblOriginator_out.Text = qualityIssue.Incident.CREATE_BY;
}
else
{
lblOriginator_out.Text = qualityIssue.Incident.CREATE_BY + " (" + orginBusOrg.ORG_NAME + ")";
}
ddlPlant.SelectedValue = qualityIssue.Incident.PLANT_ID.ToString();
ddlPlantLine.SelectedValue = qualityIssue.Incident.PLANT_ID.ToString();
if (qualityIssue.Incident.PLANT_LINE_ID > -1)
{
ddlPlantLine.SelectedValue = qualityIssue.Incident.PLANT_LINE_ID.ToString();
}
if (qualityIssue.IssueOccur.CUSTOMER_ID > 0)
{
ddlCustomer.SelectedValue = qualityIssue.IssueOccur.CUSTOMER_ID.ToString();
}
if (qualityIssue.IssueOccur.CUSTOMER_PLANT_ID > 0)
{
ddlCustomerPlant.SelectedValue = qualityIssue.IssueOccur.CUSTOMER_PLANT_ID.ToString();
}
tbNCLotNum.Text = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().LOT_NUM;
tbNCContainer.Text = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().CONTAINER_NUM;
tbNCTotalQty.Text = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_QTY.ToString();
tbNCSampleQty.Text = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_QTY.ToString();
tbNCNonConformQty.Text = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_NC_QTY.ToString();
tbTotalEstNCQty.Text = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_NC_QTY.ToString();
int nRow = -1;
foreach (QI_OCCUR_SAMPLE sample in qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE)
{
GridViewRow row = gvQISamples.Rows[++nRow];
DropDownList ddl = (DropDownList)row.FindControl("ddlPrimaryNC");
SetListSelectedTextValue(ddl, qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().PROBLEM_PRIMARY);
ddl = (DropDownList)row.FindControl("ddlSecondaryNC");
SetListSelectedTextValue(ddl, qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().PROBLEM_SECONDARY);
TextBox tb = (TextBox)row.FindControl("tbNCCount");
tb.Text = Math.Max(1, Convert.ToDecimal(qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().PROBLEM_COUNT)).ToString();
}
tbObservations.Text = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().SAMPLE_COMMENTS;
ddlDisposition.SelectedValue = qualityIssue.IssueOccur.DISPOSITION;
if (!string.IsNullOrEmpty(qualityIssue.IssueOccur.RESPONSIBLE))
{
rblResponsible.SelectedValue = qualityIssue.IssueOccur.RESPONSIBLE;
}
cbActionRequired.Checked = (bool)qualityIssue.IssueOccur.ACTION_REQD;
tbComments.Text = qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().ITEM_COMMENTS;
btnPrintLabel.OnClientClick = "Popup('../Problem/QualityIssue_Label.aspx?issue=" + qualityIssue.IssueOccur.QIO_ID.ToString() + "', 'newPage', 600, 450); return false;";
}
}
protected void Page_Load(object sender, EventArgs e)
{
SQMLoader dataLoader = new SQMLoader().Initialize(1, "");
// if (dataLoader.LoadPerson() != 99)
// return;
if (dataLoader.LoadBusOrgs() != 99)
{
return;
}
// if (dataLoader.LoadPlants() != 99)
// return;
// if (dataLoader.LoadParts() != 99)
// return;
// if (dataLoader.LoadNonConformances() != 99)
// return;
using (SQM.Website.PSsqmEntities ctx = new SQM.Website.PSsqmEntities())
{
ctx.ContextOptions.LazyLoadingEnabled = false;
BUSINESS_ORG buOrg = new BUSINESS_ORG();
buOrg.COMPANY_ID = 3;
buOrg.BUS_ORG_ID = 2;
SQMModelMgr.SelectBusOrgList(ctx, 5, 0, true);
//SQMModelMgr.CreateBusOrgNonConf(ctx, buOrg);
//List<vw_CompanyNonConformance> NCList = SQMModelMgr.SelectCompanyNCList(1, 1, false);
//SQMModelMgr.UpdateCompanyNCList(NCList, 1, 1);
//COMPANY company = new COMPANY();
//SQMModelMgr.SetGridCode((object)company, company.EntityState, 1);
//PERSON person = SQMModelMgr.LookupPerson(ctx, "mike", false);
//COMPANY co = SQMModelMgr.LookupCompany(ctx, "dunsSUPC", false);
//List<PART> partList = SQMModelMgr.SelectPartList(ctx, 1);
//PART pt = partList[0];
//List<PLANT> plantList = SQMModelMgr.SelectPlantList(ctx, 3, 0);
//PLANT pl = plantList[0];
// var bu_rec = (from b in ctx.COMPANies
// select b).ToList();
//COMPANY comp = bu_rec[1];
//comp.LAST_UPD_BY = "me";
//comp.LAST_UPD_DT = DateTime.Now;
// comp.CS_COMPANY_OVER_F = "Y";
// comp = (COMPANY)SQMModelMgr.SetPropertyValue((object)comp, "LAST_UPD_BY", "jack");
// comp = (COMPANY)SQMModelMgr.SetPropertyValue((object)comp, "CS_COMPANY_OVER_F", "Y");
/*
* COMPANY newcomp = new COMPANY();
* newcomp.SD_ID = 0;
* newcomp.ULT_DUNS_CODE = "duns002";
* newcomp.ULT_GRID_CODE = "";
* newcomp.COMPANY_NAME = newcomp.UNIQUE_ID_NAME = "SUPPLIER B";
* newcomp.CS_COMPANY_OVER_F = "";
* newcomp.STATUS = "A";
* newcomp.CREATE_BY = newcomp.LAST_UPD_BY = "me";
* newcomp.CREATE_DT = newcomp.LAST_UPD_DT = DateTime.Now;
* ctx.COMPANies.AddObject(newcomp);
*/
//ctx.SaveChanges();
}
}
protected void btnUploadFile_Click(object sender, EventArgs e)
{
byte[] fileContent;
if (ddlDataType.SelectedValue.Equals(""))
{
SetStatusMessage("You must select a data type from the drop down list");
}
else if (ddlPlantSelect.SelectedIndex == 0 && ddlDataType.SelectedValue.Equals("RECEIPT"))
{
SetStatusMessage("You must select a Receiving Location to upload a receipt record");
}
else
{
// validate the date in the select control
periodYear = 0;
periodMonth = 0;
List <SETTINGS> sets = SQMSettings.SelectSettingsGroup("FILE_UPLOAD", ""); // ABW 20140805
int primaryCompany = Convert.ToInt32(sets.Find(x => x.SETTING_CD == "CompanyID").VALUE);
PSsqmEntities Entities = new PSsqmEntities();
BUSINESS_ORG busOrg = SQMModelMgr.LookupBusOrg(Entities, primaryCompany, "", true, false);
string fileName = "";
lblSummaryList.Visible = false;
if (flUpload.HasFile)
{
btnUpload.Enabled = false;
selectedFile = tbFileSelected.Text = flUpload.FileName;
int fileLen = flUpload.PostedFile.ContentLength;
if (fileLen < 5)
{
SetStatusMessage("The file does not contain relevant data: " + flUpload.FileName);
return;
}
fileDelimiter = sets.Find(x => x.SETTING_CD == "FileDelimiter1").VALUE.ToCharArray();
plantDataMultiplier = 1;
fileName = ddlDataType.SelectedValue.ToString() + ".TXT";
try
{
string fileType = flUpload.PostedFile.ContentType;
fileContent = new byte[Convert.ToInt32(fileLen)];
int nBytes = flUpload.PostedFile.InputStream.Read(fileContent, 0, Convert.ToInt32(fileLen));
}
catch
{
SetStatusMessage("Error encountered opening or acquiring the file: " + flUpload.FileName);
return;
}
//fileReader = new SQMFileReader().InitializeCSV(1, flUpload.PostedFile.FileName, fileContent, fileDelimiter, plantDataMultiplier);
fileReader = new SQMFileReader().InitializeCSV(primaryCompany, fileName, fileContent, fileDelimiter, plantDataMultiplier, periodYear, periodMonth, busOrg.PREFERRED_CURRENCY_CODE);
if (ddlDataType.SelectedValue.Equals("RECEIPT"))
{
fileReader.LocationCode = SQMModelMgr.LookupPlant(Convert.ToDecimal(ddlPlantSelect.SelectedValue)).DUNS_CODE;
}
if (fileReader.Status < 0)
{
SetStatusMessage("Error encountered loading the file: " + flUpload.FileName);
return;
}
ProcessFile();
if (ddlDataType.SelectedValue.Equals("RECEIPT"))
{
dvPlantSelect.Style.Add("display", "inline");
}
}
else
{
SetStatusMessage("The selected file is empty: " + flUpload.FileName);
}
}
}
