private void OpenRecord()
{
dtUSD = objPayMgr.SelectUSDRate("");
grList.DataSource = dtUSD;
grList.DataBind();
foreach (GridViewRow gRow in grList.Rows)
{
gRow.Cells[2].Text = Common.DisplayDate(gRow.Cells[2].Text);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string strFiscalYear = "";
string strFiscalStartDate = "";
string userid = txtuserid.Text.ToString();
string password = txtpassword.Text.ToString();
string strInputPwd = Common.getHashValue(password);
DataTable dtUser = new DataTable();
UserManager objUserMgr = new UserManager();
Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr();
dtUser = objUserMgr.SelectUserInfo(userid, "Y");
// Payroll Fiscal Year
DataTable dtPayOpt = objOptMgr.SelectpaySlipOption("OC03");
if (dtPayOpt.Rows.Count > 0)
{
strFiscalYear = dtPayOpt.Rows[0]["OPTVALUE"].ToString().Trim();
strFiscalStartDate = dtPayOpt.Rows[0]["PAYROLLVALIDFROM"].ToString().Trim();
}
if (dtUser.Rows.Count > 0)
{
#region user view insert delete permission
string sql = "Select distinct v.ViewId,v.ViewName,v.ShowToPage,v.ParentId,up.ViewPerm,up.InsertPerm,up.DeletePerm,up.InterventionId" +
",up.HeadOfficeId,up.CCOId,up.ZoneId,up.UnitId,up.AreaId,up.BranchId,up.DistrictId,up.UpazillaId,up.ProjectId,up.GradeId,up.SectorId from ViewName v, userprivs up," +
"userinfo ui where v.ViewId=up.VIEWID AND ui.USERID=up.USERID AND up.ViewPerm='Y' AND v.VIEWID<>1 AND ui.Userid='"
+ userid.Trim() + "' order by viewid";
DataTable dtUserPermisson = objUserMgr.Dbconnect.CreateDT(sql, "UserPermisson");
ViewPermission viewPerm = null;
List <ViewPermission> viewPermList = new List <ViewPermission>();
UserAccess.Access.UserId = userid;
foreach (DataRow arow in dtUserPermisson.Rows)
{
decimal currentPage = Convert.ToDecimal(arow["ViewId"].ToString());
decimal curIntervention = Convert.ToDecimal(arow["InterventionId"]);
decimal curHeadOffice = Convert.ToDecimal(arow["HeadOfficeId"]);
decimal curCCO = Convert.ToDecimal(arow["CCOId"]);
decimal curZone = Convert.ToDecimal(arow["ZoneId"]);
decimal curUnit = Convert.ToDecimal(arow["UnitId"]);
decimal curArea = Convert.ToDecimal(arow["AreaId"]);
decimal curBranch = Convert.ToDecimal(arow["BranchId"]);
decimal curDistrict = Convert.ToDecimal(arow["DistrictId"]);
decimal curUpazilla = Convert.ToDecimal(arow["UpazillaId"]);
decimal curProject = Convert.ToDecimal(arow["ProjectId"]);
decimal curGrade = Convert.ToDecimal(arow["GradeId"]);
decimal curSector = Convert.ToDecimal(arow["SectorId"]);
viewPerm = viewPermList.Find(x => x.PageId == currentPage);
if (viewPerm == null)
{
viewPerm = new ViewPermission();
viewPerm.PageId = currentPage;
viewPerm.InsertPerm = arow["InsertPerm"].ToString();
viewPerm.DeletePerm = arow["DeletePerm"].ToString();
viewPerm.ViewPerm = arow["ViewPerm"].ToString();
viewPerm.InterventionIds = new List <decimal?>();
viewPerm.HeadOfficeIds = new List <decimal?>();
viewPerm.CCOIds = new List <decimal?>();
viewPerm.ZoneIds = new List <decimal?>();
viewPerm.UnitIds = new List <decimal?>();
viewPerm.AreaIds = new List <decimal?>();
viewPerm.BranchIds = new List <decimal?>();
viewPerm.DistrictIds = new List <decimal?>();
viewPerm.UpazillaIds = new List <decimal?>();
viewPerm.ProjectIds = new List <decimal?>();
viewPerm.GradeIds = new List <decimal?>();
viewPerm.SectorIds = new List <decimal?>();
viewPermList.Add(viewPerm);
}
if (!viewPerm.InterventionIds.Exists(ii => ii == curIntervention))
{
viewPerm.InterventionIds.Add(curIntervention);
}
if (!viewPerm.HeadOfficeIds.Exists(ii => ii == curHeadOffice))
{
viewPerm.HeadOfficeIds.Add(curHeadOffice);
}
if (!viewPerm.CCOIds.Exists(ii => ii == curCCO))
{
viewPerm.CCOIds.Add(curCCO);
}
if (!viewPerm.ZoneIds.Exists(ii => ii == curZone))
{
viewPerm.ZoneIds.Add(curZone);
}
if (!viewPerm.UnitIds.Exists(ii => ii == curUnit))
{
viewPerm.UnitIds.Add(curUnit);
}
if (!viewPerm.AreaIds.Exists(ii => ii == curArea))
{
viewPerm.AreaIds.Add(curArea);
}
if (!viewPerm.BranchIds.Exists(ii => ii == curBranch))
{
viewPerm.BranchIds.Add(curBranch);
}
if (!viewPerm.DistrictIds.Exists(ii => ii == curDistrict))
{
viewPerm.DistrictIds.Add(curDistrict);
}
if (!viewPerm.UpazillaIds.Exists(ii => ii == curUpazilla))
{
viewPerm.UpazillaIds.Add(curUpazilla);
}
if (!viewPerm.ProjectIds.Exists(ii => ii == curProject))
{
viewPerm.ProjectIds.Add(curProject);
}
if (!viewPerm.GradeIds.Exists(ii => ii == curGrade))
{
viewPerm.GradeIds.Add(curGrade);
}
if (!viewPerm.SectorIds.Exists(ii => ii == curSector))
{
viewPerm.SectorIds.Add(curSector);
}
}
UserAccess.Access.viewPerms = viewPermList;
#endregion
Session["LOGINID"] = Common.getMaxId("UserInOutHistory", "LogInId");
foreach (DataRow row in dtUser.Rows)
{
//if (strInputPwd != "")
//{
if (string.Compare(row["Password"].ToString().Trim(), strInputPwd) == 0)
{
if (strInputPwd != "0")
{
Session["USERID"] = userid.ToString();
Session["USERNAME"] = row["FullName"].ToString();
Session["EMPID"] = row["EMPID"].ToString();
Session["EMAILID"] = row["OfficeEmail"].ToString();
Session["INTERVENIONNAME"] = row["DivisionName"].ToString();
Session["INTERVENIONID"] = row["DivisionId"].ToString();
Session["OFFICEID"] = row["OfficeId"].ToString();
Session["OFFICENAME"] = row["OfficeTitle"].ToString();
Session["SALARYLOC"] = row["SalLocId"].ToString();
Session["TEAM"] = row["DEPTNAME"].ToString();
Session["TEAMID"] = row["DEPTID"].ToString();
Session["EMPLOYEEID"] = row["EmpId"].ToString().Trim();
Session["ISADMIN"] = row["IsAdmin"].ToString().Trim();
Session["DESIGNATION"] = row["JobTitleName"].ToString().Trim();
Session["FISCALYRID"] = strFiscalYear;
Session["FISCALSTARTDATE"] = strFiscalStartDate;
Session["USDRATE"] = Convert.ToDouble(objPayMgr.SelectUSDRate());
objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()),
Common.SetDateTime(DateTime.Now.ToString()), "S", "N");
DataTable dtTaskPermission = objUserMgr.GetUserTaskPermission(Session["USERID"].ToString(), "1", "T103");
if (dtTaskPermission.Rows.Count > 0)
{
Response.Redirect("File/Home.aspx");
}
else
{
Response.Redirect("Default.aspx");
}
}
else
{
Session["USERID"] = "";
Session["USERNAME"] = "";
Session["EMPID"] = "";
Session["EMAILID"] = "";
Session["INTERVENIONNAME"] = "";
Session["INTERVENIONID"] = "";
Session["OFFICEID"] = "";
Session["OFFICENAME"] = "";
Session["SALARYLOC"] = "";
Session["TEAM"] = "";
Session["TEAM"] = "";
Session["EMPLOYEEID"] = "";
Session["ISADMIN"] = "";
Session["TEAMID"] = "";
Session["DESIGNATION"] = "";
Session["ISADMIN"] = "";
Session["FISCALYRID"] = "";
Session["FISCALSTARTDATE"] = "";
Session["USDRATE"] = "";
Response.Redirect("~/index.aspx?inval=Y");
lblMsg.Text = "";
objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()),
Common.SetDateTime(DateTime.Now.ToString()), "U", "N");
this.FillOptionValue();
}
}
else
{
objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()),
Common.SetDateTime(DateTime.Now.ToString()), "U", "N");
lblMsg.Text = "Invalid User Id or Password.";
}
}
}
else
{
//Session["USERID"] = "";
Session["USERNAME"] = "";
Session["EMPID"] = "";
Session["EMAILID"] = "";
Session["COUNTRYDIRECTOR"] = "";
Session["INTERVENIONNAME"] = "";
Session["INTERVENIONID"] = "";
Session["OFFICEID"] = "";
Session["OFFICENAME"] = "";
Session["SALARYLOC"] = "";
//Session["PROGRAM"] = "";
//Session["PROGRAMID"] = "";
Session["TEAM"] = "";
Session["TEAMID"] = "";
Session["EMPLOYEEID"] = "";
Session["ISADMIN"] = "";
Session["ISSHIFTINCHR"] = "";
Session["DESIGNATION"] = "";
Session["LOCATION"] = "";
// Payroll
Session["FISCALYRID"] = "";
Session["USERID"] = txtuserid.Text.Trim();
objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()),
Common.SetDateTime(DateTime.Now.ToString()), "U", "N");
Response.Redirect("~/index.aspx?inval=Y");
lblMsg.Text = "";
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string strFiscalYear = "";
string strFiscalStartDate = "";
string userid = txtuserid.Text.ToString();
string password = txtpassword.Text.ToString();
string strInputPwd = Common.getHashValue(password);
DataTable dtUser = new DataTable();
UserManager objUserMgr = new UserManager();
Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr();
dtUser = objUserMgr.SelectUserInfo(userid, "Y");
// Payroll Fiscal Year
DataTable dtPayOpt = objOptMgr.SelectpaySlipOption("OC03");
if (dtPayOpt.Rows.Count > 0)
{
strFiscalYear = dtPayOpt.Rows[0]["OPTVALUE"].ToString().Trim();
strFiscalStartDate = dtPayOpt.Rows[0]["PAYROLLVALIDFROM"].ToString().Trim();
}
if (dtUser.Rows.Count > 0)
{
Session["LOGINID"] = Common.getMaxId("UserInOutHistory", "LogInId");
foreach (DataRow row in dtUser.Rows)
{
//if (strInputPwd != "")
//{
if (string.Compare(row["Password"].ToString().Trim(), strInputPwd) == 0)
{
if (strInputPwd != "0")
{
Session["USERID"] = userid.ToString();
Session["USERNAME"] = row["FullName"].ToString();
Session["EMPID"] = row["EMPID"].ToString();
Session["EMAILID"] = row["OfficeEmail"].ToString();
Session["OFFICE"] = row["DivisionName"].ToString();
Session["TEAM"] = row["DEPTNAME"].ToString();
Session["TEAMID"] = row["DEPTID"].ToString();
Session["EMPLOYEEID"] = row["EmpId"].ToString().Trim();
Session["ISADMIN"] = row["IsAdmin"].ToString().Trim();
Session["ISPAYADMIN"] = row["IsPayAdmin"].ToString().Trim();
Session["USERROLE"] = row["UserRole"].ToString().Trim();
Session["DESIGNATION"] = row["JobTitleName"].ToString().Trim();
Session["FISCALYRID"] = strFiscalYear;
Session["FISCALSTARTDATE"] = strFiscalStartDate;
Session["USDRATE"] = Convert.ToDouble(objPayMgr.SelectUSDRate());
objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()),
Common.SetDateTime(DateTime.Now.ToString()), "S", "N");
DataTable dtTaskPermission = objUserMgr.GetUserTaskPermission(Session["USERID"].ToString(), "1", "T103");
if (dtTaskPermission.Rows.Count > 0)
{
Response.Redirect("File/Home.aspx");
}
else
{
Response.Redirect("Default.aspx");
}
}
else
{
Session["USERID"] = "";
Session["USERNAME"] = "";
Session["EMPID"] = "";
Session["EMAILID"] = "";
Session["OFFICE"] = "";
Session["TEAM"] = "";
Session["TEAM"] = "";
Session["EMPLOYEEID"] = "";
Session["ISADMIN"] = "";
Session["ISPAYADMIN"] = "";
Session["TEAMID"] = "";
Session["DESIGNATION"] = "";
Session["ISADMIN"] = "";
Session["FISCALYRID"] = "";
Session["FISCALSTARTDATE"] = "";
Session["USDRATE"] = "";
Response.Redirect("index.aspx?inval=Y");
lblMsg.Text = "";
objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()),
Common.SetDateTime(DateTime.Now.ToString()), "U", "N");
this.FillOptionValue();
}
}
else
{
objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()),
Common.SetDateTime(DateTime.Now.ToString()), "U", "N");
lblMsg.Text = "Invalid User Id or Password.";
}
}
}
else
{
//Session["USERID"] = "";
Session["USERNAME"] = "";
Session["EMPID"] = "";
Session["EMAILID"] = "";
Session["COUNTRYDIRECTOR"] = "";
Session["OFFICE"] = "";
Session["PROGRAM"] = "";
Session["OFFICEID"] = "";
Session["PROGRAMID"] = "";
Session["TEAM"] = "";
Session["TEAMID"] = "";
Session["EMPLOYEEID"] = "";
Session["ISADMIN"] = "";
Session["ISSHIFTINCHR"] = "";
Session["DESIGNATION"] = "";
Session["LOCATION"] = "";
// Payroll
Session["FISCALYRID"] = "";
Session["USERID"] = txtuserid.Text.Trim();
//objUserMgr.InsertUserInOutHistory(Session["LOGINID"].ToString(), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()),
// Common.SetDateTime(DateTime.Now.ToString()), "U", "N");
Response.Redirect("index.aspx?inval=Y");
lblMsg.Text = "";
}
}