//[AllowAnonymous]
//public CaptchaImageResult ShowCaptchaImage()
//{
// return new CaptchaImageResult();
//}
#region Dashboard(AR)
//[Authorize]
//[OutputCache(Duration = 300, VaryByParam = "none")]
public ActionResult Dashboard()
{
if (Session["userInfo"] == null)
{
return(Redirect(@Url.Action("Index")));
}
DashboardDocs _DashboardDocs = null;
ViewBag.RoleId = RoleId;
ViewBag.UserId = UserId;
ViewBag.UserName = UserName;
ViewBag.UserSessionEmployeeId = UserSessionEmployeeId;
var balance = BAL.PreferencesBAL.GetManageLeaveDetails(this.BusinessId).FirstOrDefault();
ViewBag.NoOfLeaves = balance == null ? 0 : balance.Leavevalue;
_DashboardDocs = BAL.Dashboard.GetDashboardDocs(BusinessId, UserId, RoleId, UserSessionEmployeeId);
// ViewBag.NoOfLeaves = _DashboardDocs.CountOfNoOfLeaves;
ViewBag.NoOfResignations = _DashboardDocs.CountOfNoOfResignations;
ViewBag.PendingTimesheets = _DashboardDocs.CountOfPendingTimeSheets;
ViewBag.NoOfNewJoinees = _DashboardDocs.CountOfNoOfNewJoinees;
ViewBag.PayrollHeadCount = _DashboardDocs.NoOfEmployees;
ViewBag.PayrollFnfPending = 0;
ViewBag.PayrollOnNotice = 0;
Session["HeadCount"] = _DashboardDocs.NoOfEmployees;
Session["GrossSalary"] = _DashboardDocs.GrossSalary;
Session["TotalDeductions"] = _DashboardDocs.TotalDeductions;
Session["ProvidentFund"] = _DashboardDocs.ProvidentFund;
Session["ProfessionTax"] = _DashboardDocs.ProfessionTax;
Session["TotalESIC"] = _DashboardDocs.TotalESIC;
var loggeduserinfo = (BAL.LoggedUser)Session["userInfo"];
if (loggeduserinfo.BusinessStatusId != (int)BusinessStatus.Activated)
{
return(Redirect(@Url.Action("Index")));
}
return(View());
}
public static DashboardDocs GetDashboardDocs(int BusinessId, int UserId, int RoleId, int UserSessionEmployeeId)
{
DashboardDocs _DashboardDocs = new DashboardDocs();
List <NoOfLeaves> _NoOfLeaves = new List <NoOfLeaves>();
List <PendingTimeSheets> _PendingTimeSheets = new List <PendingTimeSheets>();
List <NoOfResignations> _NoOfResignations = new List <NoOfResignations>();
List <NoOfNewJoinees> _NoOfNewJoinees = new List <NoOfNewJoinees>();
List <NoOfEmployessInfo> _NoOfEmployessInfo = new List <NoOfEmployessInfo>();
List <GrossSalaryInfo> _GrossSalaryInfo = new List <GrossSalaryInfo>();
List <DeductionsInfo> _DeductionsInfo = new List <DeductionsInfo>();
int UserEmployeeId = UserSessionEmployeeId;
using (var Cmd = new DBSqlCommand())
{
try
{
Cmd.AddParameters(BusinessId, CommonConstants.BusinessID, SqlDbType.Int);
Cmd.AddParameters(UserId, CommonConstants.UserId, SqlDbType.Int);
Cmd.AddParameters(RoleId, CommonConstants.RoleId, SqlDbType.Int);
Cmd.AddParameters(UserEmployeeId, CommonConstants.UserEmployeeId, SqlDbType.Int);
DataSet ireader = Cmd.ExecuteDataDataSet(SqlProcedures.usp_EmployeeDashboardDetails);
DataSet ireader1 = Cmd.ExecuteDataDataSet(SqlProcedures.usp_HRDashboardDetails);
for (var i = 0; i < ireader.Tables[0].Rows.Count; i++)
{
_DashboardDocs.CountOfNoOfLeaves = (int)ireader.Tables[0].Rows[i]["CountOfNoOfLeaves"];
}
_DashboardDocs.NoOfLeaves = _NoOfLeaves;
for (var i = 0; i < ireader.Tables[0].Rows.Count; i++)
{
_DashboardDocs.CountOfPendingTimeSheets = (int)ireader.Tables[0].Rows[i]["CountOfPendingTimeSheets"];
}
_DashboardDocs.PendingTimeSheets = _PendingTimeSheets;
for (var i = 0; i < ireader.Tables[0].Rows.Count; i++)
{
_DashboardDocs.CountOfNoOfResignations = (int)ireader.Tables[0].Rows[i]["CountOfNoOfResignations"];
}
_DashboardDocs.NoOfResignations = _NoOfResignations;
for (var i = 0; i < ireader.Tables[0].Rows.Count; i++)
{
_DashboardDocs.CountOfNoOfNewJoinees = (int)ireader.Tables[0].Rows[i]["CountOfNoOfNewJoinees"];
}
_DashboardDocs.NoOfNewJoinees = _NoOfNewJoinees;
for (var i = 0; i < ireader1.Tables[0].Rows.Count; i++)
{
_DashboardDocs.NoOfEmployees = (int)ireader1.Tables[0].Rows[i]["EmployeeCount"];
}
_DashboardDocs.NoOfEmployessInfo = _NoOfEmployessInfo;
for (var i = 0; i < ireader1.Tables[1].Rows.Count; i++)
{
_DashboardDocs.GrossSalary = (decimal)ireader1.Tables[1].Rows[i]["GrossSalary"];
_DashboardDocs.TotalESIC = (decimal)ireader1.Tables[1].Rows[i]["TotalESIC"];
}
_DashboardDocs.GrossSalaryInfo = _GrossSalaryInfo;
for (var i = 0; i < ireader1.Tables[3].Rows.Count; i++)
{
_DashboardDocs.ProvidentFund = (decimal)ireader1.Tables[3].Rows[i]["ProvidentFund"];
_DashboardDocs.ProfessionTax = (int)ireader1.Tables[3].Rows[i]["ProfessionTax"];
_DashboardDocs.TotalDeductions = (decimal)ireader1.Tables[3].Rows[i]["TotalDeductions"];
}
_DashboardDocs.DeductionsInfo = _DeductionsInfo;
return(_DashboardDocs);
}
catch (Exception Ex)
{
throw Ex;
throw new ArgumentException("Exception in GetDashboardDocs. Exception :" + Ex.Message);
}
finally
{
_DashboardDocs = null;
}
}
}
