private void BindEntities(int pageNumber) { int companyId = int.Parse(ddlCompany.SelectedValue); int productionUnitId = int.Parse(ddlProductionUnit.SelectedValue); IQueryable <HumanResourceForm> forms = CxHumanResourceForm.GetForms(pageNumber, companyId, productionUnitId); var results = from f in forms select new { HumanResourceFormID = f.HumanResourceFormID, FormDescription = f.Form.Description, Company = f.ProductionUnit.Company.CompanyName, ProductionUnitDescription = f.ProductionUnit.Description, PeriodicityDescription = f.Form.Periodicity.Description, PeriodNumber = f.PeriodNumber, PeriodicityCode = f.Form.Periodicity.Code, FormDate = f.FormDate, FormState = f.State.Description, }; var listEntities = results.ToList(); GridView1.DataSource = listEntities.Take(10); GridView1.DataBind(); //int pageSize = PageRecordsInput.Text == "" ? GridView1.PageSize : int.Parse(PageRecordsInput.Text); int pageSize = GridView1.PageSize; if (listEntities.Count == 0) { ShowInfo(MessagePanel, Resources.Resource.mNoRecordsFound); ListPanel.Visible = false; PagingPanel.Visible = false; } else { if (listEntities.Count > pageSize) { SetPages(ddlPaging, pageNumber + 1); PagingPanel.Visible = true; ddlPaging.SelectedIndex = pageNumber - 1; } else { PagingPanel.Visible = false; } DetailPanel.Visible = false; BackPanel.Visible = false; ConfirmButtonPanel.Visible = false; ListPanel.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SetTransactionOptions(Options, true, false, false, false, false, false, false); SetPageDescription(Resources.MainMenu.IM_03_05); currentOption = Options.SelectedValue; string pu = Request.QueryString["PU"]; string fefid = Request.QueryString["FID"]; string stateid = Request.QueryString["ST"]; if (fefid != null) { CompanyFormID.Value = fefid; currentOption = "UPD"; OptionsPanel.Visible = false; SearchPanel.Visible = false; DetailPanel.Visible = true; ConfirmButtonPanel.Visible = true; HumanResourceForm entity = CxHumanResourceForm.GetFormById(int.Parse(fefid)); FormMessageLiteral.Text = GetPeriodMessage(Resources.Resource.lForm2Message, entity.PeriodNumber, entity.Form.Periodicity.Code, entity.FormDate); if (stateid == "3") { DetailPanel.Enabled = false; ApprovePanel.Visible = true; ConfirmButtonPanel.Visible = false; FormMessageLiteral.Text = ""; } ProductionUnitLiteral.Text = pu; FillDateLiteral.Text = DateTime.Now.ToShortDateString(); ShowCurrentForm(int.Parse(fefid)); } } else { currentOption = Options.SelectedValue; User user = WebSecurity.GetUserInfo(Page.User.Identity.Name); int? companyId = user.CompanyID; if (companyId != null && companyId != 0) { ddlCompany.SelectedValue = companyId.ToString(); ddlCompany.Enabled = false; } } }
private static void ProcessLateHumanResourceForm(Form currentForm) { int? alarmRangeUser = 0; int? alarmRangeManager = 0; int? alarmRangeExecutive = 0; bool userAlert = false; bool managerAlert = false; bool executiveAlert = false; IQueryable <HumanResourceForm> forms = CxHumanResourceForm.GetFormsNotApproved(currentForm.FormID); var result = forms.ToList(); // for each form not apporved (formState!=4) foreach (HumanResourceForm f1 in result) { alarmRangeUser = f1.Form.AlarmRangeUser; alarmRangeManager = f1.Form.AlarmRangeManager; alarmRangeExecutive = f1.Form.AlarmRangeExecutive; int lateDays = GetFormLateDays(f1.FormDate, f1.Form.Periodicity.Code); if (lateDays >= alarmRangeUser && f1.UserAlertDate == null) { Goodies.SendEmail(Properties.Settings.Default.LateNotificationMessage, f1.ProductionUnitID, f1.Form.FormType.FunctionalAreaID, f1.Form.Description, f1.PeriodNumber, f1.Form.Periodicity.Code, f1.FormDate); userAlert = true; } if (lateDays >= alarmRangeManager && f1.ManagerAlertDate == null) { Goodies.SendManagerEmail(Properties.Settings.Default.LateNotificationMessage, f1.ProductionUnitID, f1.Form.FormType.FunctionalAreaID, f1.Form.Description, f1.PeriodNumber, f1.Form.Periodicity.Code, f1.FormDate); managerAlert = true; } if (lateDays >= alarmRangeExecutive && f1.ExecutiveAlertDate == null) { Goodies.SendExecutiveEmail(Properties.Settings.Default.LateNotificationMessage, f1.ProductionUnitID, f1.Form.FormType.FunctionalAreaID, f1.Form.Description, f1.PeriodNumber, f1.Form.Periodicity.Code, f1.FormDate); executiveAlert = true; } CxHumanResourceForm.UpdateAlertDate(f1.HumanResourceFormID, userAlert, managerAlert, executiveAlert); } }
private void BindZEEUserForms(User user) { SmizeeContext db = new Models.SmizeeContext(); string userName = Page.User.Identity.Name; Guid? userId = user.UserId; int? functionalAreaId = user.FunctionalAreaID; CleanMessage(MessagePanel, ErrorPanel); var ffInQueueX = from f in CxFinancialSDZEEForm.GetUserFormsInQueue(db, userName, functionalAreaId) select f; var ffInQueue = from f in ffInQueueX select new { //FormId = f.FormID, CompanyFormID = f.FinancialSDZEEFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = "ZEE", FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var olfInQueueX = from f in CxOperationalLicensesForm.GetUserFormsInQueue(db, userName, functionalAreaId) select f; var olfInQueue = from f in olfInQueueX select new { //FormId = f.FormID, CompanyFormID = f.OperationalLicensesFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = "ZEE", FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var ofInQueueX = from f in CxOperationalForm.GetUserFormsInQueue(db, userName, functionalAreaId) select f; var ofInQueue = from f in ofInQueueX select new { //FormId = f.FormID, CompanyFormID = f.OperationalFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = "ZEE", FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var hrfInQueueX = from f in CxHumanResourceSDZEEForm.GetUserFormsInQueue(db, userName, functionalAreaId) select f; var hrfInQueue = from f in hrfInQueueX select new { //FormId = f.FormID, CompanyFormID = f.HumanResourceSDZEEFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = "ZEE", FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var f0X = from f in CxFinancialExportForm.GetFormsForApproval(db, userName, 0, null, functionalAreaId) select new { CompanyFormID = f.FinancialExportFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = f.ProductionUnit.Description, FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var f1X = from f in CxFinancialForm.GetFormsForApproval(db, userName, 0, null, functionalAreaId) select new { CompanyFormID = f.FinancialFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = f.ProductionUnit.Description, FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var f3X = from f in CxHumanResourceForm.GetFormsForApproval(db, userName, 0, null, functionalAreaId) select new { CompanyFormID = f.HumanResourceFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = f.ProductionUnit.Description, FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var f4X = from f in CxHumanResourceQualificationForm.GetFormsForApproval(db, userName, 0, null, functionalAreaId) select new { CompanyFormID = f.HumanResourceQualificationFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = f.ProductionUnit.Description, FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var fInQueue = ffInQueue.Union(ofInQueue); fInQueue = fInQueue.Union(olfInQueue); fInQueue = fInQueue.Union(hrfInQueue); fInQueue = fInQueue.Union(f0X); fInQueue = fInQueue.Union(f1X); fInQueue = fInQueue.Union(f3X); fInQueue = fInQueue.Union(f4X); int formStateId = int.Parse(ddlFormState.SelectedValue); var listEntities = fInQueue.Where(f => formStateId == 0 | f.FormStateId == formStateId).ToList(); gvFormsInQueue.DataSource = listEntities; gvFormsInQueue.DataBind(); if (listEntities.Count == 0) { ShowInfo(MessagePanel, Resources.Resource.mNoRecordsFound); ListPanel.Visible = false; } else { ListPanel.Visible = true; } }
private void BindUserForms(Guid?userId, int?companyId, int?functionalAreaId) { SmizeeContext db = new Models.SmizeeContext(); string userName = Page.User.Identity.Name; if (functionalAreaId == 0) { functionalAreaId = null; } CleanMessage(MessagePanel, ErrorPanel); var upu = from f in CxUserProductionUnit.GetProductionUnitsByUserId(db, userId) select f; var fefInQueueX = from f in CxFinancialExportForm.GetUserFormsInQueue(db, userName, companyId, null, functionalAreaId) select f; var fefInQueue = from f in fefInQueueX join y1 in upu on f.ProductionUnitID equals y1.ProductionUnitID select new { FormId = f.FormID, CompanyFormID = f.FinancialExportFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = f.ProductionUnit.Description, FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var ffInQueueX = from f in CxFinancialForm.GetUserFormsInQueue(db, userName, companyId, null, functionalAreaId) select f; var ffInQueue = from f in ffInQueueX join y1 in upu on f.ProductionUnitID equals y1.ProductionUnitID select new { FormId = f.FormID, CompanyFormID = f.FinancialFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = f.ProductionUnit.Description, FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var hrfInQueueX = from f in CxHumanResourceForm.GetUserFormsInQueue(db, userName, companyId, null, functionalAreaId) select f; var hrfInQueue = from f in hrfInQueueX join y1 in upu on f.ProductionUnitID equals y1.ProductionUnitID select new { FormId = f.FormID, CompanyFormID = f.HumanResourceFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = f.ProductionUnit.Description, FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var x = from f in CxHumanResourceQualificationForm.GetUserFormsInQueue(db, userName, companyId, null, functionalAreaId) select f; var hrqfInQueue = from f in x join y1 in upu on f.ProductionUnitID equals y1.ProductionUnitID select new { FormId = f.FormID, CompanyFormID = f.HumanResourceQualificationFormID, FormDescription = f.Form.Description, Periodicity = f.Form.Periodicity.Description, ProductionUnit = f.ProductionUnit.Description, FormPage = f.Form.FormType.FormPage, FormStateId = f.StateID, FormState = f.State.Description, FormDate = f.FormDate, PeriodicityCode = f.Form.Periodicity.Code, PeriodNumber = f.PeriodNumber }; var fInQueue = fefInQueue.Union(ffInQueue); fInQueue = fInQueue.Union(hrfInQueue); fInQueue = fInQueue.Union(hrqfInQueue); int formStateId = int.Parse(ddlFormState.SelectedValue); var listEntities = fInQueue.Where(f => formStateId == 0 | f.FormStateId == formStateId).ToList(); gvFormsInQueue.DataSource = listEntities; gvFormsInQueue.DataBind(); if (listEntities.Count == 0) { ShowInfo(MessagePanel, Resources.Resource.mNoRecordsFound); ListPanel.Visible = false; } else { ListPanel.Visible = true; } }