private void GetData()
{
try
{
List <AccountCode> data = new AccountCodeDAL().GetAccountCodes().ToList();
if (data.Count == 0)
{
data = new List <AccountCode>();
data.Add(new AccountCode()
{
AccountCode1 = string.Empty, ParentAccountCode = string.Empty
});
List <DAL.YearUploadSetup> GetData = new YearUploadDAL().GetYearUpload();
DAL.YearUploadSetup curryear = GetData.Where(x => x.BudgetYear == DateTime.Now.Year).FirstOrDefault();
if (curryear.ToString().Count() > 0)
{
if (!GetData.Where(y => y.BudgetYear == curryear.BudgetYear).Select(z => z.Status.Contains("A")).FirstOrDefault())
{
btnFileUpload.HRef = "#";
}
}
}
Session["AccountCodesData"] = data;
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
private void FillChild(string type, TreeNode parent, int ParentId = 0, string ParentAccountCode = "")
{
if (type == "SD")
{
var nodes = new SegmentDetailsDAL().GetSegmentDetails().ToList().Where(x => x.Status == "A" && x.ParentDetailID == ParentId);
foreach (var node in nodes)
{
TreeNode child = new TreeNode(node.DetailCode + " - " + node.DetailDesc, node.SegmentDetailID.ToString());
child.SelectAction = TreeNodeSelectAction.None;
child.Collapse();
parent.ChildNodes.Add(child);
FillChild("SD", child, node.SegmentDetailID, string.Empty);
}
}
else if (type == "MG")
{
var nodes = new AccountCodeDAL().GetAccountCodes().ToList().Where(x => x.Status == "A" && x.ParentAccountCode == ParentAccountCode);
foreach (var node in nodes)
{
TreeNode child = new TreeNode(node.AccountCode1 + " - " + node.AccountDesc, node.AccountCode1);
child.SelectAction = TreeNodeSelectAction.None;
child.Collapse();
parent.ChildNodes.Add(child);
FillChild("MG", child, 0, node.AccountCode1);
}
}
}
protected void btnSaveWorkflow_OnClick(object sender, EventArgs e)
{
try
{
/*User Mengurus Workflow - start*/
List <UserMengurusWorkflow> lstAccountCode = new List <UserMengurusWorkflow>();
GetNodeRecursiveAC(tvMengurus.Nodes, lstAccountCode);
List <string> ParAccCode = new AccountCodeDAL().GetAccountCodes().ToList().Select(x => x.ParentAccountCode).Distinct().ToList();
for (int i = 0; i < ParAccCode.Count; i++)
{
lstAccountCode = lstAccountCode.Where(x => x.AccountCode != ParAccCode[i]).ToList();
}
Session["UserMengurusWorkflow"] = lstAccountCode;
/*User Mengurus Workflow - end*/
/*User Perjawatan Workflow - START*/
List <UserPerjawatanWorkflow> lstServiceCode = new List <UserPerjawatanWorkflow>();
for (int i = 0; i < gvPerjawatanWorkFlow.Rows.Count; i++)
{
if (((CheckBox)gvPerjawatanWorkFlow.Rows[i].Cells[0].FindControl("chkSelect")).Checked)
{
lstServiceCode.Add(new UserPerjawatanWorkflow()
{
GroupPerjawatanCode = gvPerjawatanWorkFlow.DataKeys[i]["GroupPerjawatanCode"].ToString(),
Status = "A"
});
}
}
Session["UserPerjawatanWorkflow"] = lstServiceCode;
/*User Perjawatan Workflow - END*/
/*User Segment Details Workflow - START*/
List <UserSegDtlWorkflow> lstSegmentDetail = new List <UserSegDtlWorkflow>();
foreach (TreeNode node in tvSegmentDetails.CheckedNodes)
{
GetNodeRecursiveSD(node, lstSegmentDetail);
}
List <int> ParSegDtls = new SegmentDetailsDAL().GetSegmentDetails().ToList().Select(x => Convert.ToInt32(x.ParentDetailID)).Distinct().ToList();
for (int i = 0; i < ParSegDtls.Count; i++)
{
lstSegmentDetail = lstSegmentDetail.Where(x => x.SegmentDetailID != ParSegDtls[i]).ToList();
}
Session["UserSegmentDetailsWorkflow"] = lstSegmentDetail;
/*User Segment Details Workflow - END*/
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "GetWorkflowFlag", "WorkflowFlag();", true);
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
private void GetData()
{
try
{
List <AccountCode> lstAccountCode = new AccountCodeDAL().GetAccountCodes().Where(x => x.Status == "A").ToList();
List <AccountCode> AccountCodesData = new List <AccountCode>();
if (AuthUser.JuncUserRoles.FirstOrDefault().RoleID == 3 || AuthUser.JuncUserRoles.FirstOrDefault().RoleID == 4)
{
AccountCodesData = lstAccountCode;
}
else
{
AccountCodesData = AuthUser.UserMengurusWorkflows.Where(x => x.Status == "A").Select(x => x.AccountCode1).ToList();
if (AccountCodesData.Count == 0)
{
lstAccountCode = new List <AccountCode>();
}
else
{
List <string> lstprntcodes = AccountCodesData.Select(x => x.ParentAccountCode).Distinct().ToList();
while (lstprntcodes.Count > 0)
{
List <AccountCode> lstprnts = lstAccountCode.Where(x => lstprntcodes.Contains(x.AccountCode1)).ToList();
foreach (AccountCode o in lstprnts)
{
if (AccountCodesData.Where(x => x.AccountCode1 == o.AccountCode1).Count() == 0)
{
AccountCodesData.Add(o);
}
}
lstprntcodes = lstprnts.Select(x => x.ParentAccountCode).Distinct().ToList();
}
}
}
Session["AccountCodesData"] = lstAccountCode;
List <int> lstperiod = GetSelectedPeriods();
List <PeriodMenguru> PeriodData = new PeriodMengurusDAL().GetPeriodMengurus().Where(x => x.Status == "A" && lstperiod.Contains(x.PeriodMengurusID))
.OrderBy(x => x.MengurusYear).ThenBy(x => x.FieldMenguru.FieldMengurusDesc).ToList();
List <PeriodMenguru> FixedData = ((List <FieldMenguru>)Session["FixedFieldMengurus"]).Where(x => lstperiod.Contains(x.FieldMengurusID))
.Select(x => new PeriodMenguru
{
PeriodMengurusID = lstperiod.Contains(x.FieldMengurusID) ? x.FieldMengurusID : 0,
MengurusYear = DateTime.Now.Year,
FieldMenguru = new FieldMenguru
{
FieldMengurusID = x.FieldMengurusID,
FieldMengurusDesc = x.FieldMengurusDesc,
Status = x.Status
}
}).OrderBy(x => x.MengurusYear).ThenBy(x => x.FieldMenguru.FieldMengurusDesc).ToList();
FixedData.AddRange(PeriodData);
Session["PeriodData"] = FixedData;
bool CanEdit = false;
List <BudgetMenguru> BudgetData = new BudgetMengurusDAL().GetBudgetMengurusStatus(GetSelectedSegmentDetails(), ref CanEdit)
.Where(x => x.Status == "A")
.Select(x => new BudgetMenguru
{
BudgetMengurusID = 0,
AccountCode = x.AccountCode,
PeriodMengurusID = x.PeriodMengurusID,
Status = x.Status,
Remarks = string.Empty,
Amount = (AccountCodesData.Where(y => y.ParentAccountCode == x.AccountCode).Count() == 0) ? x.Amount : 0
})
.GroupBy(x => new
{
x.AccountCode,
x.PeriodMengurusID,
x.Status
})
.Select(x => new BudgetMenguru
{
AccountCode = x.Key.AccountCode,
PeriodMengurusID = x.Key.PeriodMengurusID,
Status = x.Key.Status,
Amount = x.Sum(y => y.Amount)
})
.ToList();
Session["BudgetData"] = BudgetData;
Session["CanEdit"] = CanEdit;
if (!CanEdit)
{
chkKeterangan.Checked = false;
chkPengiraan.Checked = false;
}
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
protected void gvUsers_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "EditRow")
{
ClearPageData();
GridViewRow selectedRow = gvUsers.Rows[Convert.ToInt32(e.CommandArgument)];
selectedRow.Style["background-color"] = "skyblue";
MasterUser objMasterUser = DAL.UsersDAL.StaticUserId(Convert.ToInt32(gvUsers.DataKeys[selectedRow.RowIndex]["UserID"]), "");
MembershipUser _MembershipUser = Membership.GetUser(objMasterUser.UserName);
if ((Guid)_MembershipUser.ProviderUserKey == objMasterUser.UUID)
{
Session["SelectedMasterUser"] = objMasterUser;
username.Value = objMasterUser.UserName.Trim();
email.Value = objMasterUser.UserEmail.Trim();
question.Value = objMasterUser.SecQuestion.Trim();
answer.Value = Security.Decrypt(objMasterUser.SecAnswer.Trim());
fullname.Value = objMasterUser.FullName.Trim();
icno.Value = objMasterUser.UserIC.Trim();
dept.Value = objMasterUser.Department.Trim();
phone.Value = objMasterUser.UserPhoneNo.Trim();
designation.Value = objMasterUser.Designation.Trim();
fax.Value = objMasterUser.Fax.Trim();
offaddress.Value = objMasterUser.OfficeAddress.Trim();
period.Value = objMasterUser.PeriodOfService.Trim();
grade.Value = objMasterUser.PositionGrade.Trim();
title.Value = objMasterUser.Title.Trim();
status.SelectedIndex = -1;
status.Items.FindByValue(new Helper().GetItemStatusEnumName(Convert.ToChar(objMasterUser.UserStatus))).Selected = true;
role.SelectedIndex = -1;
ListItem item = role.Items.FindByValue(new UsersRoleDAL().ListUserRole().Where(x => x.UserID == objMasterUser.UserID)
.Select(y => Convert.ToString(y.RoleID)).FirstOrDefault());
if (item != null)
{
role.SelectedValue = item.Value;
}
/*User Mengurus Workflow - start*/
List <AccountCode> lstAccCode = objMasterUser.UserMengurusWorkflows.Where(x => x.Status == "A").Select(x => x.AccountCode1).ToList();
List <string> lstParAccCode = lstAccCode.Select(x => x.ParentAccountCode).Distinct().ToList();
while (lstParAccCode.Count() > 0)
{
List <AccountCode> lstObjPar = new AccountCodeDAL().GetAccountCodes().ToList().Where(x => lstParAccCode.Contains(x.AccountCode1)).ToList();
foreach (AccountCode ac in lstObjPar)
{
if (lstAccCode.Where(x => x.AccountCode1 == ac.AccountCode1).Count() == 0)
{
lstAccCode.Add(ac);
}
}
lstParAccCode = lstObjPar.Select(x => x.ParentAccountCode).Distinct().ToList();
}
PopulateACChild(tvMengurus.Nodes, lstAccCode);
/*User Mengurus Workflow - end*/
/*User Perjawatan Workflow - start*/
List <string> lstServiceCode = objMasterUser.UserPerjawatanWorkflows.Where(x => x.Status == "A").Select(x => x.GroupPerjawatanCode).ToList();
for (int i = 0; i < gvPerjawatanWorkFlow.Rows.Count; i++)
{
((CheckBox)gvPerjawatanWorkFlow.Rows[i].Cells[0].FindControl("chkSelect")).Checked = lstServiceCode.Contains(gvPerjawatanWorkFlow.DataKeys[i]["GroupPerjawatanCode"].ToString());
}
/*User Perjawatan Workflow - end*/
/*User Segment Details Workflow - start*/
List <SegmentDetail> lstSegDtls = objMasterUser.UserSegDtlWorkflows.Where(x => x.Status == "A").Select(x => x.SegmentDetail).ToList();
List <int> lstParSegDtls = lstSegDtls.Select(x => Convert.ToInt32(x.ParentDetailID)).Distinct().ToList();
while (lstParSegDtls.Count > 0)
{
List <SegmentDetail> lstParObj = new SegmentDetailsDAL().GetSegmentDetails().ToList().Where(x => lstParSegDtls.Contains(x.SegmentDetailID)).ToList();
foreach (SegmentDetail o in lstParObj)
{
if (lstSegDtls.Where(x => x.SegmentDetailID == o.SegmentDetailID).Count() == 0)
{
lstSegDtls.Add(o);
}
}
lstParSegDtls = lstParObj.Select(x => Convert.ToInt32(x.ParentDetailID)).Distinct().ToList();
}
Boolean TVcheckbox = false;
foreach (TreeNode node in tvSegmentDetails.Nodes)
{
TVcheckbox = PopulateSDChild(node, lstSegDtls, 0);
if (TVcheckbox == true)
{
node.Checked = true;
}
}
/*User Segment Details Workflow - end*/
//Change workflow button colors accordingly - start
if (role.SelectedValue != "3")
{
CustomizeButtonWorkflow(lstAccCode.Select(x => x.AccountCode1).ToList(), lstServiceCode, lstSegDtls.Select(x => x.SegmentDetailID).ToList());
}
//Change workflow button colors accordingly - end
ChangePageMode(Helper.PageMode.Edit);
form_Wiz.Visible = true;
}
}
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}