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 <FinancialSDZEEForm> forms = CxFinancialSDZEEForm.GetForms(pageNumber, year, periodicity, user.FunctionalAreaID);
var results = from f in forms
select new
{
FinancialFormId = f.FinancialSDZEEFormID,
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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetTransactionOptions(Options, true, false, false, false, false, false, false);
//SetTransactionOptions(Options);
SetPageDescription(Resources.MainMenu.IM_03_07);
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;
FinancialSDZEEForm entity = CxFinancialSDZEEForm.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 = "";
}
FillDateLiteral.Text = DateTime.Now.ToShortDateString();
ShowCurrentForm(int.Parse(fefid));
}
}
else
{
currentOption = Options.SelectedValue;
}
}
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;
}
}
