protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (hid.Value == "Update")
{
CapexType exp = null; bool rst = false;
exp = LookUpBLL.GetCapexType(Convert.ToInt32(txtID.Text));
if (exp != null)
{
exp.Name = txtDept.Text.ToUpper();
// exp.GLCode = txtcode.Text;
if (chkActive.Checked)
{
exp.isActive = true;
}
else
{
exp.isActive = false;
}
rst = LookUpBLL.UpdateCapexType(exp);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
BudgetYear byr = (BudgetYear)Session["budgetYr"];
bool result = false;
CapexType exp = new CapexType();
exp.Name = txtDept.Text.ToUpper();
exp.BudgetYearID = byr.ID;
// exp.GLCode = txtcode.Text;
if (chkActive.Checked)
{
exp.isActive = true;
}
else
{
exp.isActive = false;
}
result = LookUpBLL.AddCapexType(exp);
if (result)
{
BindGrid();
txtDept.Text = "";
//txtcode.Text = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
private void BindGrid()
{
gvDir.DataSource = LookUpBLL.GetGradeList();
gvDir.DataBind();
}
private void BindGrid()
{
gvDir.DataSource = LookUpBLL.GetReinvestList();
gvDir.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (hid.Value == "Update")
{
CustomerType ast = null; bool rst = false;
ast = LookUpBLL.GetCustomerType(Convert.ToInt32(txtID.Text));
if (ast != null)
{
ast.Name = txtAsset1.Text;
if (chkActive.Checked)
{
ast.isActive = true;
}
else
{
ast.isActive = false;
}
//ast.RecoveryTypeID = int.Parse(ddlDir.SelectedValue);
rst = LookUpBLL.UpdateCustomerType(ast);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
string asstNme = "";
asstNme = txtAsset1.Text;
bool result = false;
CustomerType ast = new CustomerType();
ast.Name = asstNme;
if (chkActive.Checked)
{
ast.isActive = true;
}
else
{
ast.isActive = false;
}
// ast.RecoveryTypeID = int.Parse(ddlDir.SelectedValue);
result = LookUpBLL.AddCustomerType(ast);
if (result)
{
BindGrid();
txtAsset1.Text = "";
// ddlDir.SelectedValue = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!.";
Utility.WriteError("Error: " + ex.InnerException);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (hid.Value == "Update")
{
IndirectBudgetItem ast = null; bool rst = false; decimal uprice = 0;
ast = LookUpBLL.GetIndirectItem(Convert.ToInt32(txtID.Text));
if (ast != null)
{
ast.Name = txtName.Text;
ast.IndirectTypeID = int.Parse(ddlDir.SelectedValue);
ast.Code = txtcode.Text;
ast.DelFlg = "N";
rst = LookUpBLL.UpdateIndirectItem(ast);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
string asstNme = ""; decimal uprice = 0;
asstNme = txtName.Text;
bool result = false;
IndirectBudgetItem ast = new IndirectBudgetItem();
ast.Name = txtName.Text;
ast.IndirectTypeID = int.Parse(ddlDir.SelectedValue);
ast.Code = txtcode.Text;
ast.DelFlg = "N";
result = LookUpBLL.AddIndirectItem(ast);
if (result)
{
BindGrid();
txtName.Text = "";
ddlDir.SelectedValue = "";
txtcode.Text = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!.";
Utility.WriteError("Error: " + ex.InnerException);
}
}
private void BindGrid()
{
gvCommon.DataSource = LookUpBLL.GetAssetList();
gvCommon.DataBind();
}
private void BindGrid()
{
gvDir.DataSource = LookUpBLL.GetSalaryElementList();
gvDir.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (hid.Value == "Update")
{
BudgetYear mak = null; bool rst = false; int year = 0;
mak = LookUpBLL.GetBudgetYear(Convert.ToInt32(txtID.Text));
if (mak != null)
{
if (!int.TryParse(txtDept.Text, out year))
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Year must be numeric!!.";
return;
}
mak.Year = year.ToString();
mak.StartDate = DateTime.Parse(txtDate.Text, culture);
mak.EndDate = DateTime.Parse(txtEDate.Text, culture);
if (chkActive.Checked)
{
LookUpBLL.DeactivateAllBudgetYear();
mak.IsActive = true;
}
else
{
mak.IsActive = false;
}
rst = LookUpBLL.UpdateBudgetYear(mak);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
int mak = 0;
if (!int.TryParse(txtDept.Text, out mak))
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Year must be numeric!!.";
return;
}
bool result = false;
BudgetYear byr = new BudgetYear();
byr.Year = mak.ToString();
byr.StartDate = DateTime.Parse(txtDate.Text, culture);
byr.EndDate = DateTime.Parse(txtEDate.Text, culture);
if (chkActive.Checked)
{
LookUpBLL.DeactivateAllBudgetYear();
byr.IsActive = true;
}
else
{
byr.IsActive = false;
}
result = LookUpBLL.AddBudgetYear(byr);
if (result)
{
BindGrid();
txtDept.Text = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
protected void btnReturn_Click(object sender, EventArgs e)
{
try
{
AppUser usr = null;
if (Session["user"] != null)
{
usr = (AppUser)Session["user"];
}
else
{
Response.Redirect("../Login.aspx", false);
return;
}
if (string.IsNullOrEmpty(txtcomment.Text))
{
modalErr.Visible = true;
modalErr.InnerText = "Comment is required!!!";
mpeAppr.Show();
return;
}
bool isset = false; AppUser budgetInputer = new AppUser();
int deptID = int.Parse(ddlDept.SelectedValue);
List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptID).ToList();
if (budMenuLst.Count() > 0)
{
foreach (DeptBudgetItem dm in budMenuLst)
{
if (dm.Code == "CA")//for capex
{
Utility.UpdateBudgetCapex((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4);
}
if (dm.Code == "DI")
{
Utility.UpdateBudgetDirect((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4);
}
if (dm.Code == "ID")
{
Utility.UpdateBudgetIndirect((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4);
}
if (dm.Code == "MO")
{
Utility.UpdateBudgetMovable((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4);
}
if (dm.Code == "RE")
{
Utility.UpdateBudgetRevenue((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4);
}
if (dm.Code == "SA")
{
Utility.UpdateBudgetExistingSf((int)Utility.BudgetItemStatus.Returned_For_Correction, deptID, usr.FullName, 4);
}
}
BudgetYear budYr = (BudgetYear)Session["budgetYr"];
List <TrackApproval> getTrackApproval = null;
getTrackApproval = LookUpBLL.GetTrackApproval(deptID, budYr.ID).ToList();
if (getTrackApproval != null && getTrackApproval.Count() > 0)
{
TrackApproval appTrack = getTrackApproval.FirstOrDefault();
appTrack.status = (int)Utility.BudgetItemStatus.Returned_For_Correction;
appTrack.ActionBy = usr.FullName;
LookUpBLL.UpdateApprovalStatus(appTrack);
dvExco.Visible = false;
//success.Visible = true;
//success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Budget has been successfully returned to HOD.";
//return;
}
else
{
LookUpBLL.AddApprovaltrack(new TrackApproval()
{
BudgetYr = budYr.ID, DepartmentID = deptID, ActionBy = usr.FullName, dateApproved = DateTime.Now, status = (int)Utility.BudgetItemStatus.Returned_For_Correction
});
dvExco.Visible = false;
//success.Visible = true;
//success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Budget has been successfully approved.";
//return;
}
isset = true;
}
if (isset)
{
BindGrid();
//sending mail
string body = "";
string from = ConfigurationManager.AppSettings["exUser"].ToString();
string siteUrl = ConfigurationManager.AppSettings["siteUrl"].ToString();
string appLogo = ConfigurationManager.AppSettings["appLogoUrl"].ToString();
string hodEmail = Utility.GetUsersEmailAdd(deptApprRole, deptID);
string subject = "Budget Item Correction Notification";
string FilePath = Server.MapPath("EmailTemplates/");
if (File.Exists(FilePath + "ReturnBudget.htm"))
{
FileStream f1 = new FileStream(FilePath + "ReturnBudget.htm", FileMode.Open);
StreamReader sr = new StreamReader(f1);
body = sr.ReadToEnd();
body = body.Replace("@add_appLogo", appLogo);
body = body.Replace("@siteUrl", siteUrl);
body = body.Replace("@BudgetElement", ddlDept.SelectedItem.Text + " Department");
body = body.Replace("@add_Comment", txtcomment.Text); //Replace the values from DB or any other source to personalize each mail.
f1.Close();
}
string rst = "";
try
{
rst = Utility.SendMail(budgetInputer.Email, from, hodEmail, subject, body);
}
catch { }
if (rst.Contains("Successful"))
{
success.Visible = true;
success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Action was successful. Notification has been sent to HOD";
return;
}
else
{
success.Visible = true;
success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Action was successful.Notification could NOT be sent at this time";
return;
}
}
else
{
BindGrid();
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. kindly try again.If error persist contact Administrator!!.";
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!.";
Utility.WriteError("Error: " + ex.Message);
}
}
protected void btnMDFinal_Click(object sender, EventArgs e)
{
try
{
AppUser usr = null;
if (Session["user"] != null)
{
usr = (AppUser)Session["user"];
}
else
{
Response.Redirect("../Login.aspx", false);
return;
}
int deptID = int.Parse(ddlDept.SelectedValue);
List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptID).ToList();
if (budMenuLst.Count() > 0)
{
foreach (DeptBudgetItem dm in budMenuLst)
{
if (dm.Code == "CA")//for capex
{
Utility.UpdateBudgetCapex((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2);
}
if (dm.Code == "DI")
{
Utility.UpdateBudgetDirect((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2);
}
if (dm.Code == "ID")
{
Utility.UpdateBudgetIndirect((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2);
}
if (dm.Code == "MO")
{
Utility.UpdateBudgetMovable((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2);
}
if (dm.Code == "RE")
{
Utility.UpdateBudgetRevenue((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2);
}
if (dm.Code == "SA")
{
Utility.UpdateBudgetExistingSf((int)Utility.BudgetItemStatus.MD_Approved, deptID, usr.FullName, 2);
}
}
BudgetYear budYr = (BudgetYear)Session["budgetYr"];
List <TrackApproval> getTrackApproval = null;
getTrackApproval = LookUpBLL.GetTrackApproval(deptID, budYr.ID).ToList();
if (getTrackApproval != null && getTrackApproval.Count() > 0)
{
TrackApproval appTrack = getTrackApproval.FirstOrDefault();
appTrack.status = (int)Utility.BudgetItemStatus.MD_Approved;
appTrack.ActionBy = usr.FullName;
LookUpBLL.UpdateApprovalStatus(appTrack);
dvExco.Visible = false;
success.Visible = true;
success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Budget has been successfully approved.";
return;
}
else
{
LookUpBLL.AddApprovaltrack(new TrackApproval()
{
BudgetYr = budYr.ID, DepartmentID = deptID, ActionBy = usr.FullName, dateApproved = DateTime.Now, status = (int)Utility.BudgetItemStatus.MD_Approved
});
dvExco.Visible = false;
success.Visible = true;
success.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>Budget has been successfully approved.";
return;
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!.";
Utility.WriteError("Error: " + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
error.Visible = false; success.Visible = false;
try
{
// hidEDPending.Value = ""; hidMDPending.Value = "";
// btnCorrect.Visible = false;
// btnMD.Visible = false;
//dvExco.Visible = false;
if (Session["user"] != null)
{
usr = (AppUser)Session["user"];
budYr = (BudgetYear)Session["budgetYr"];
}
else
{
Response.Redirect("Login.aspx", false);
return;
}
if (!IsPostBack)
{
lbDept.Text = usr.Department.Name.ToUpper();
lbyr.Text = budYr.Year;
int budyrID = budYr.ID;
int deptID = usr.DepartmentID.Value;
List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptID).ToList();
if (budMenuLst.Count() > 0)
{
foreach (DeptBudgetItem dm in budMenuLst)
{
if (dm.Code == "CA")//for capex
{
Utility.ComputeBudgetSummaryCapexProjection(budyrID, deptID);
}
if (dm.Code == "DI")
{
Utility.ComputeBudgetSummaryDirectProjection(budyrID, deptID);
}
if (dm.Code == "ID")
{
Utility.ComputeBudgetSummaryIndirectProjection(budyrID, deptID);
}
if (dm.Code == "MO")
{
Utility.ComputeBudgetSummaryFixedAsset(budyrID, deptID);
}
if (dm.Code == "RE")
{
Utility.ComputeBudgetSummaryRevenue(budyrID, deptID);
}
if (dm.Code == "SA")
{
Utility.ComputeBudgetSummaryExistingStff(budyrID, deptID);
}
}
}
if (User.IsInRole(AdminRole) || User.IsInRole(PBMgrRole) || User.IsInRole(PBOffRole))
{
dvFilter.Visible = true;
Utility.BindDept(ddlDept);
List <Department> deptList = DepartmentBLL.GetDeptList();
}
if (User.IsInRole(MDRole))
{
dvFilter.Visible = true;
Utility.BindDept(ddlDept);
List <Department> deptList = DepartmentBLL.GetDeptList();
lbDept.Visible = false;
}
if (User.IsInRole(EDRole))
{
dvFilter.Visible = true;
Utility.BindDept(ddlDept, usr.Department.DirectorateID.Value);
List <Department> deptList = DepartmentBLL.GetDeptList(usr.Department.DirectorateID.Value);
lbDept.Visible = false;
}
BindGrid();
if (User.IsInRole(deptApprRole))
{
List <TrackApproval> getTrackApproval = null;
getTrackApproval = LookUpBLL.GetTrackApproval(usr.DepartmentID.Value, budYr.ID).ToList();
if (getTrackApproval != null && getTrackApproval.Count() > 0)
{
TrackApproval tt = getTrackApproval.FirstOrDefault();
if (tt.status == (int)Utility.BudgetItemStatus.Returned_For_Correction)
{
dvDept.Visible = true;
dvExco.Visible = false;
//hidEDPending.Value = "1";
}
}
else
{
dvDept.Visible = true;
dvExco.Visible = false;
//hidEDPending.Value = "1";
}
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
usr = (AppUser)Session["user"]; budYr = (BudgetYear)Session["budgetYr"];
if (ddlDept.SelectedValue != "")
{
int deptId = int.Parse(ddlDept.SelectedValue); budYr = (BudgetYear)Session["budgetYr"];
int budyrID = budYr.ID;
if (User.IsInRole(EDRole))
{
List <TrackApproval> getTrackApproval = null;
getTrackApproval = LookUpBLL.GetTrackApproval(deptId, budYr.ID).ToList();
if (getTrackApproval != null && getTrackApproval.Count() > 0)
{
TrackApproval tt = getTrackApproval.FirstOrDefault();
if (tt.status == (int)Utility.BudgetItemStatus.Pending_ED_Approval)
{
dvExco.Visible = true;
btnCorrect.Visible = true;
hidEDPending.Value = "1";
}
if (tt.status == (int)Utility.BudgetItemStatus.Pending_MD_Approval)
{
dvExco.Visible = true;
btnCorrect.Visible = false;
btnReturn.Visible = true;
btnReturn.Text = "Return For Correction After Review";
hidEDPending.Value = "1";
}
//dvExco.Visible = false;
//btnCorrect.Visible = false;
//hidEDPending.Value = "1";
}
List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptId).ToList();
if (budMenuLst.Count() > 0)
{
foreach (DeptBudgetItem dm in budMenuLst)
{
if (dm.Code == "CA")//for capex
{
Utility.ComputeBudgetSummaryCapexProjection(budyrID, deptId);
}
if (dm.Code == "DI")
{
Utility.ComputeBudgetSummaryDirectProjection(budyrID, deptId);
}
if (dm.Code == "ID")
{
Utility.ComputeBudgetSummaryIndirectProjection(budyrID, deptId);
}
if (dm.Code == "MO")
{
Utility.ComputeBudgetSummaryFixedAsset(budyrID, deptId);
}
if (dm.Code == "RE")
{
Utility.ComputeBudgetSummaryRevenue(budyrID, deptId);
}
if (dm.Code == "SA")
{
Utility.ComputeBudgetSummaryExistingStff(budyrID, deptId);
}
}
}
}
gvDept.DataSource = CommonBLL.GetBudgetSummaryList(budYr.ID).Where(d => d.DepartmentID == deptId).ToList();
gvDept.DataBind();
lbmsg.Text = "";
lbmsg.Text = ddlDept.SelectedItem.Text + " Department Budgets";
if (User.IsInRole(MDRole))
{
List <TrackApproval> getTrackApproval = null;
getTrackApproval = LookUpBLL.GetTrackApproval(deptId, budYr.ID).ToList();
if (getTrackApproval != null && getTrackApproval.Count() > 0) //if selected department has been pushed for approval
{
TrackApproval tt = getTrackApproval.FirstOrDefault();
if (tt.status == (int)Utility.BudgetItemStatus.Pending_MD_Approval)
{
dvExco.Visible = true;
btnMD.Visible = true;
hidMDPending.Value = "1";
}
if (tt.status == (int)Utility.BudgetItemStatus.Pending_MD_Final_Approval)
{
dvExco.Visible = true;
btnMD.Visible = false;
btnReject.Visible = false;
btnMDFinal.Visible = true;
hidMDPending.Value = "1";
}
}
else
{
dvExco.Visible = false;
btnMD.Visible = false;
}
}
if (User.IsInRole(AdminRole) || User.IsInRole(PBMgrRole) || User.IsInRole(PBOffRole))
{
List <TrackApproval> getTrackApproval = null;
getTrackApproval = LookUpBLL.GetTrackApproval(deptId, budYr.ID).ToList();
if (getTrackApproval != null && getTrackApproval.Count() > 0)//if selected department has been pushed for approval
{
TrackApproval tt = getTrackApproval.FirstOrDefault();
if (tt.status == (int)Utility.BudgetItemStatus.Pending_ReAlignment)
{
dvPB.Visible = true;
btnMD.Visible = false;
hidMDPending.Value = "1";
List <DeptBudgetItem> budMenuLst = LookUpBLL.GetDeptMenuItem(deptId).ToList();
if (budMenuLst.Count() > 0)
{
foreach (DeptBudgetItem dm in budMenuLst)
{
if (dm.Code == "CA")//for capex
{
Utility.ComputeBudgetSummaryCapexProjection(budyrID, deptId);
}
if (dm.Code == "DI")
{
Utility.ComputeBudgetSummaryDirectProjection(budyrID, deptId);
}
if (dm.Code == "ID")
{
Utility.ComputeBudgetSummaryIndirectProjection(budyrID, deptId);
}
if (dm.Code == "MO")
{
Utility.ComputeBudgetSummaryFixedAsset(budyrID, deptId);
}
if (dm.Code == "RE")
{
Utility.ComputeBudgetSummaryRevenue(budyrID, deptId);
}
if (dm.Code == "SA")
{
Utility.ComputeBudgetSummaryExistingStff(budyrID, deptId);
}
}
}
}
gvDept.DataSource = CommonBLL.GetBudgetSummaryList(budYr.ID).Where(d => d.DepartmentID == deptId).ToList();
gvDept.DataBind();
lbPBmsg.Text = "";
lbPBmsg.Text = ddlDept.SelectedItem.Text + " Department Budgets";
}
else
{
dvExco.Visible = false;
btnMD.Visible = false;
}
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
decimal costmth = 0; decimal costyr = 0;
try
{
if (hid.Value == "Update")
{
Grade grd = null; bool rst = false;
grd = LookUpBLL.GetGrade(Convert.ToInt32(txtID.Text));
if (grd != null)
{
// if (!decimal.TryParse(txtCostMth.Text, out costmth) || !decimal.TryParse(txtCostYr.Text, out costyr))
// {
// error.Visible = true;
// error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Cost must be numeric!!.";
// return;
// }
grd.Name = txtDept.Text.ToUpper();
grd.CostPerMonth = costmth;
grd.CostPerYear = costyr;
if (chkActive.Checked)
{
grd.isActive = true;
}
else
{
grd.isActive = false;
}
rst = LookUpBLL.UpdateGrade(grd);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
// int mak = 0;
//if (!decimal.TryParse(txtCostMth.Text, out costmth) || !decimal.TryParse(txtCostYr.Text, out costyr))
//{
// error.Visible = true;
// error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Cost must be numeric!!.";
// return;
//}
bool result = false;
Grade grd = new Grade();
grd.Name = txtDept.Text.ToUpper();
grd.CostPerMonth = costmth;
grd.CostPerYear = costyr;
if (chkActive.Checked)
{
grd.isActive = true;
}
else
{
grd.isActive = false;
}
result = LookUpBLL.AddGrade(grd);
if (result)
{
BindGrid();
txtDept.Text = "";
// txtCostYr.Text = "";
// txtCostMth.Text = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
decimal Amt = 0; decimal costyr = 0;
try
{
if (hid.Value == "Update")
{
GradeSalaryElement grd = null; bool rst = false;
grd = LookUpBLL.GetGradeSalElement(Convert.ToInt32(hidGrd.Value), Convert.ToInt32(hidEle.Value));
if (grd != null)
{
if (!decimal.TryParse(txtAmt.Text, out Amt))
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Cost must be numeric!!.";
return;
}
grd.SalElementID = int.Parse(ddlEle.SelectedValue);
grd.GradeId = int.Parse(ddlGrd.SelectedValue);
grd.Amount = Amt;
if (chkActive.Checked)
{
grd.isActive = true;
}
else
{
grd.isActive = false;
}
rst = LookUpBLL.UpdateGradeSalElement(grd);
if (rst != false)
{
BindGrid(0, 0);
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
// int mak = 0;
if (!decimal.TryParse(txtAmt.Text, out Amt))
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Cost must be numeric!!.";
return;
}
bool result = false;
GradeSalaryElement grd = new GradeSalaryElement();
grd.SalElementID = int.Parse(ddlEle.SelectedValue);
grd.GradeId = int.Parse(ddlGrd.SelectedValue);
grd.Amount = Amt;
if (chkActive.Checked)
{
grd.isActive = true;
}
else
{
grd.isActive = false;
}
result = LookUpBLL.AddGradeSalElement(grd);
if (result)
{
BindGrid(0, 0);
ddlGrd.SelectedValue = "";
ddlEle.SelectedValue = "";
txtAmt.Text = "";
// txtCostYr.Text = "";
// txtCostMth.Text = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (hid.Value == "Update")
{
SalaryElement ast = null; bool rst = false; decimal uprice = 0;
ast = LookUpBLL.GetSalaryElement(Convert.ToInt32(txtID.Text));
if (ast != null)
{
ast.Elements = txtName.Text.ToUpper();
ast.CategoryId = int.Parse(ddlCat.SelectedValue);
ast.Code = txtDept.Text;
if (chkActive.Checked)
{
ast.isActive = true;
}
else
{
ast.isActive = false;
}
rst = LookUpBLL.UpdateSalaryElement(ast);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
string asstNme = ""; decimal uprice = 0;
asstNme = txtName.Text;
bool result = false;
SalaryElement ast = new SalaryElement();
ast.Code = txtDept.Text;
ast.Elements = asstNme;
ast.CategoryId = int.Parse(ddlCat.SelectedValue);
if (chkActive.Checked)
{
ast.isActive = true;
}
else
{
ast.isActive = false;
}
result = LookUpBLL.AddSalaryElement(ast);
if (result)
{
BindGrid();
txtName.Text = "";
ddlCat.SelectedValue = "";
txtDept.Text = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!.";
Utility.WriteError("Error: " + ex.InnerException);
}
}
private void BindGrid()
{
gvDir.DataSource = LookUpBLL.GetBudgetYearList();
gvDir.DataBind();
}
private void BindGrid()
{
gvVehicleM.DataSource = LookUpBLL.GetTrackerCoyList();
gvVehicleM.DataBind();
}
private void BindGrid()
{
gvCommon.DataSource = LookUpBLL.GetIndirectItemList();
gvCommon.DataBind();
}
private void BindGrid()
{
gvLocation.DataSource = LookUpBLL.GetFleetLocationList();
gvLocation.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!HttpContext.Current.User.Identity.IsAuthenticated)
{
Response.Redirect("~/Login.aspx", false);
return;
}
if (Session["user"] == null)
{
Response.Redirect("~/Login.aspx", false);
return;
}
if (!IsPostBack)
{
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
if (HttpContext.Current.User.IsInRole(AdminRole) || HttpContext.Current.User.IsInRole(PBMgrRole) || HttpContext.Current.User.IsInRole(PBOffRole) || HttpContext.Current.User.IsInRole(EDRole) || HttpContext.Current.User.IsInRole(MDRole))
{
dvAdmin.Visible = true;
dvAdminAll.Visible = true;
rListAdmin.DataSource = LookUpBLL.GetBudgetMenuList();
rListAdmin.DataBind();
dvATCMenu.Visible = true;
//dvAsset.Visible = true;
//dvCredit.Visible = true;
// dvFinSer.Visible = true;
}
Label lblfnm = (Label)LoginView1.FindControl("lbFName");
Label lblRole = (Label)LoginView1.FindControl("lbRole");
AppUser userdata = new AppUser();
if (Session["user"] != null)
{
userdata = (AppUser)Session["user"];
// userdata=UserBLL.GetUserByUserName(HttpContext.Current.User.Identity.Name);
lblfnm.Text = userdata.FullName;
lblRole.Text = userdata.UserRole;
if (!HttpContext.Current.User.IsInRole(AdminRole))
{
int deptId = userdata.DepartmentID.Value;
rListMenu.DataSource = LookUpBLL.GetDeptMenuItem(deptId);
rListMenu.DataBind();
dvUsers.Visible = true;
}
if (HttpContext.Current.User.IsInRole(DeptApproverRole))
{
dvATCMenu.Visible = true;
}
if (HttpContext.Current.User.IsInRole(EDRole) || HttpContext.Current.User.IsInRole(MDRole))
{
dvAdmin.Visible = false;
dvAdminAll.Visible = false;
//rListAdmin.DataSource = LookUpBLL.GetBudgetMenuList();
//rListAdmin.DataBind();
dvUsers.Visible = false;
//dvAsset.Visible = true;
//dvCredit.Visible = true;
// dvFinSer.Visible = true;
}
}
else
{
Response.Redirect("~/Login.aspx", false);
return;
}
}
else
{
Response.Redirect("~/Login.aspx", false);
return;
}
}
}catch (Exception ex)
{
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
AppUser usr = null;
if (Session["user"] != null)
{
usr = (AppUser)Session["user"];
}
else
{
Response.Redirect("../Login.aspx", false);
return;
}
string compName = ""; int custtype = 0; string Addr = ""; decimal uPrice = 0; decimal minOrder = 0; string email = "";
string mobileno = ""; int pipeSection = 0; int paymtFlg = 0; int vatFlg = 0; string contactPer = "";
if (hid.Value == "Update")
{
if (!decimal.TryParse(txtPrice.Text, out uPrice) || !decimal.TryParse(txtMinOrder.Text, out minOrder))
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>UnitPrice and minimum order must be numeric!!.";
return;
}
int Id = int.Parse(Request.QueryString["Id"].ToString());
GSS_Customer c = LookUpBLL.GetGssCustomer(Id);
c.CompanyName = txtAsset1.Text;
c.CustomerTypeID = int.Parse(ddlDir.SelectedValue);
c.CompanyAddress = txtaddr.Text;
c.ContactPerson = txtperson.Text;
c.MobileNo = txtPhone.Text;
c.Email = txtEmail.Text;
c.PipelineSectionID = int.Parse(ddlSection.SelectedValue);
c.PaymentTermFlg = int.Parse(ddlTerm.SelectedValue);
c.VATFlg = int.Parse(ddlVat.SelectedValue);
c.UnitPrice = uPrice;
c.MinimumOrderVolume = minOrder;
c.LastUpdatedBy = usr.FullName;
c.LastUpdatedDate = DateTime.Now;
if (chkCap.Checked)
{
c.CapitalRecovery = true;
}
else
{
c.CapitalRecovery = false;
}
if (chkActive.Checked)
{
c.isActive = true;
}
else
{
c.isActive = false;
}
if (LookUpBLL.UpdateGssCustomer(c))
{
ClearInput();
Response.Redirect("ManageGssCustomer.aspx?success=2&&newRecordId=" + c.ID.ToString(), false);
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
if (!decimal.TryParse(txtPrice.Text, out uPrice) || !decimal.TryParse(txtMinOrder.Text, out minOrder))
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button>UnitPrice and minimum order must be numeric!!.";
return;
}
GSS_Customer c = new GSS_Customer();
c.CompanyName = txtAsset1.Text;
c.CustomerTypeID = int.Parse(ddlDir.SelectedValue);
c.CompanyAddress = txtaddr.Text;
c.ContactPerson = txtperson.Text;
c.MobileNo = txtPhone.Text;
c.Email = txtEmail.Text;
c.PipelineSectionID = int.Parse(ddlSection.SelectedValue);
c.PaymentTermFlg = int.Parse(ddlTerm.SelectedValue);
c.VATFlg = int.Parse(ddlVat.SelectedValue);
c.UnitPrice = uPrice;
c.MinimumOrderVolume = minOrder;
c.AddedBy = usr.FullName;
c.DateAdded = DateTime.Now;
if (chkCap.Checked)
{
c.CapitalRecovery = true;
}
else
{
c.CapitalRecovery = false;
}
if (chkActive.Checked)
{
c.isActive = true;
}
else
{
c.isActive = false;
}
if (LookUpBLL.AddGssCustomer(c))
{
ClearInput();
Response.Redirect("ManageGssCustomer.aspx?success=1&&newRecordId=" + c.ID.ToString(), false);
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (hid.Value == "Update")
{
Asset ast = null; bool rst = false; decimal uprice = 0;
ast = LookUpBLL.GetAsset(Convert.ToInt32(txtID.Text));
if (ast != null)
{
if (!decimal.TryParse(txtPrice.Text, out uprice))
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Unitprice must be numeric!!.";
return;
}
ast.AssetName = txtAsset1.Text;
ast.AssetTypeID = int.Parse(ddlDir.SelectedValue);
ast.UnitPrice = uprice;
ast.DelFlg = "N";
rst = LookUpBLL.UpdateAsset(ast);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
string asstNme = ""; decimal uprice = 0;
asstNme = txtAsset1.Text;
if (!decimal.TryParse(txtPrice.Text, out uprice))
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Unitprice must be numeric!!.";
return;
}
bool result = false;
Asset ast = new Asset();
ast.AssetName = asstNme;
ast.AssetTypeID = int.Parse(ddlDir.SelectedValue);
ast.UnitPrice = uprice;
ast.DelFlg = "N";
result = LookUpBLL.AddAsset(ast);
if (result)
{
BindGrid();
txtAsset1.Text = "";
ddlDir.SelectedValue = "";
txtPrice.Text = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> An error occured. Kindly try again. If error persist contact Administrator!!.";
Utility.WriteError("Error: " + ex.InnerException);
}
}
private void BindGrid()
{
gvDir.DataSource = LookUpBLL.GetIndirectTypeList();
gvDir.DataBind();
}
private void BindGrid()
{
gvCommon.DataSource = LookUpBLL.GetCustomerTypeList();
gvCommon.DataBind();
}
private void BindGrid()
{
gvCommon.DataSource = LookUpBLL.GetPipelineSectionList(false);
gvCommon.DataBind();
}
private void BindGrid()
{
gvDir.DataSource = LookUpBLL.GetExpenseTypeList();
gvDir.DataBind();
}
private void BindGrid()
{
gvVehicleM.DataSource = LookUpBLL.GetVehicleTypeList();
gvVehicleM.DataBind();
}
private void BindGrid(int grade, int elem)
{
gvDir.DataSource = LookUpBLL.GetGradeSalElementList(grade, elem);
gvDir.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
NewHire stf = null;
try
{
usr = (AppUser)Session["user"]; budYr = (BudgetYear)Session["budgetYr"];
Grade gd = LookUpBLL.GetGrade(int.Parse(ddlgrade.SelectedValue));
if (hid.Value == "Update")
{
bool rst = false; int tot = 0; int month = int.Parse(ddlMonth.SelectedValue);
stf = CommonBLL.GetNewHire(Convert.ToInt32(txtID.Text));
if (stf != null)
{
if (!int.TryParse(txtTot.Text, out tot))
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Total must be numeric!!.";
return;
}
stf.TotalNumber = tot;
stf.GradeID = int.Parse(ddlgrade.SelectedValue);
stf.DepartmentID = usr.DepartmentID;
stf.Status = (int)Utility.BudgetItemStatus.Pending_Approval;
stf.MonthYear = month;
if (gd != null)
{
stf.TotalCost = tot * gd.CostPerMonth * Utility.GetOutstandingMonth(month);
}
stf.BudgetYrID = budYr.ID;
rst = CommonBLL.UpdateNewHire(stf);
if (rst != false)
{
BindGrid();
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record updated successfully!!.";
return;
}
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not updated. Kindly try again. If error persist contact Administrator!!.";
}
}
else
{
int tot = 0;
if (!int.TryParse(txtTot.Text, out tot))
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Total must be numeric!!.";
return;
}
bool result = false;
stf = new NewHire(); int month = int.Parse(ddlMonth.SelectedValue);
stf.GradeID = int.Parse(ddlgrade.SelectedValue);
stf.DepartmentID = usr.DepartmentID;
stf.AddedBy = User.Identity.Name;
stf.DateAdded = DateTime.Now;
stf.TotalNumber = tot;
stf.BudgetYrID = budYr.ID;
stf.MonthYear = int.Parse(ddlMonth.SelectedValue);
stf.Status = (int)Utility.BudgetItemStatus.Pending_Approval;
if (gd != null)
{
stf.TotalCost = tot * gd.CostPerMonth * Utility.GetOutstandingMonth(month);
}
result = CommonBLL.AddNewHire(stf);
if (result)
{
BindGrid();
txtTot.Text = "";
ddlgrade.SelectedValue = "";
success.Visible = true;
success.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button> Record added successfully!!.";
return;
}
else
{
error.Visible = true;
error.InnerHtml = " <button type='button' class='close' data-dismiss='alert'>×</button>Record could Not added. Kindly try again. If error persist contact Administrator!!.";
}
}
}
catch (Exception ex)
{
error.Visible = true;
error.InnerHtml = "<button type='button' class='close' data-dismiss='alert'>×</button> An error occurred. kindly try again!!!";
Utility.WriteError("Error: " + ex.Message);
}
}
