private void CreateRecord(int formId)
{
CxOperationalLicensesForm.CreateRecord(formId, User.Identity.Name);
BackPanel.Visible = true;
ConfirmButtonPanel.Visible = false;
DetailPanel.Visible = false;
ShowInfo(MessagePanel, Resources.Resource.mCreateOK);
}
private void DeleteRecord(int code)
{
CxOperationalLicensesForm.DeleteRecord(code);
BackPanel.Visible = true;
ConfirmButtonPanel.Visible = false;
DetailPanel.Visible = false;
ShowInfo(MessagePanel, Resources.Resource.mDeleteOK);
}
private void BindEntities(int pageNumber)
{
int year = int.Parse(ddlYear.SelectedValue);
int periodicity = int.Parse(ddlPeriodicity.SelectedValue);
User user = WebSecurity.GetUserInfo(Page.User.Identity.Name);
IQueryable <OperationalLicensesForm> forms = CxOperationalLicensesForm.GetForms(pageNumber, year, periodicity, user.FunctionalAreaID);
var results = from f in forms
select new
{
OperationalLicensesFormId = f.OperationalLicensesFormID,
FormDescription = f.Form.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;
}
}
private void UpdateRecord(int operationalLicensesFormID, int formState)
{
HiddenField currentDevPhase = null;
TextBox currentPUN = null;
CxOperationalLicensesForm.UpdateRecord(operationalLicensesFormID, User.Identity.Name, formState);
foreach (GridViewRow currentExport in FormGridView.Rows)
{
currentDevPhase = currentExport.FindControl("DevelopmentPhaseIdHidden") as HiddenField;
currentPUN = currentExport.FindControl("ProductionUnitsNumberText") as TextBox;
if (currentDevPhase.Value != "" && currentPUN.Text != "")
{
CxOperationalLicensesForm.CreateFormPhaseRecord(operationalLicensesFormID, User.Identity.Name, formState, int.Parse(currentDevPhase.Value), int.Parse(currentPUN.Text));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetTransactionOptions(Options, true, false, false, false, false, false, false);
SetPageDescription(Resources.MainMenu.IM_03_03);
currentOption = Options.SelectedValue;
string pu = Request.QueryString["PU"];
string olfid = Request.QueryString["FID"];
string stateid = Request.QueryString["ST"];
if (olfid != null)
{
CompanyFormID.Value = olfid;
currentOption = "UPD";
OptionsPanel.Visible = false;
SearchPanel.Visible = false;
DetailPanel.Visible = true;
ConfirmButtonPanel.Visible = true;
OperationalLicensesForm entity = CxOperationalLicensesForm.GetFormById(int.Parse(olfid));
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;
FormGridView.Columns[0].Visible = false;
FormMessageLiteral.Text = "";
}
FillDateLiteral.Text = DateTime.Now.ToShortDateString();
ShowCurrentForm(int.Parse(olfid));
}
}
else
{
currentOption = Options.SelectedValue;
User user = WebSecurity.GetUserInfo(Page.User.Identity.Name);
int? companyId = user.CompanyID;
}
}
private static void ProcessLateOperationalLicensesForm(Form currentForm)
{
int? alarmRangeUser = 0;
int? alarmRangeManager = 0;
int? alarmRangeExecutive = 0;
bool userAlert = false;
bool managerAlert = false;
bool executiveAlert = false;
IQueryable <OperationalLicensesForm> forms = CxOperationalLicensesForm.GetFormsNotApproved(currentForm.FormID);
var result = forms.ToList();
// for each form not apporved (formState!=4)
foreach (OperationalLicensesForm 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, 0, 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, 0, 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, 0, f1.Form.FormType.FunctionalAreaID, f1.Form.Description, f1.PeriodNumber, f1.Form.Periodicity.Code, f1.FormDate);
executiveAlert = true;
}
CxOperationalLicensesForm.UpdateAlertDate(f1.OperationalLicensesFormID, 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;
}
}
