protected void rcmb_AppCycle_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_AppCycle.SelectedIndex > 0)
{
Color[] barColors = new Color[8] {
Color.Purple,
Color.SteelBlue,
Color.Aqua,
Color.Yellow,
Color.Navy,
Color.Green,
Color.Blue,
Color.Red
};
DataTable dt = Dal.ExecuteQuery("EXEC USP_PMS_APPRAISALSTATUS @MODE=9, @APP_STATUS_APPRAISALCYCLE =" + Convert.ToInt32(rcmb_AppCycle.SelectedItem.Value));
if (dt.Rows.Count > 0)
{
String[] Rating = new String[] { "A", "B", "C" };
List <String> diffRating = new List <String>();
String[] diffRatingArr = new String[] { };
for (int dtIndex = 0; dtIndex < dt.Rows.Count; dtIndex++)
{
diffRating.Add(Convert.ToString(dt.Rows[dtIndex][0]));
}
diffRatingArr = diffRating.ToArray();
String[] array = new String[] { };
IEnumerable <String> diff = Rating.Except(diffRatingArr);
array = diff.Cast <String>().ToArray <String>();
for (int arrayIndex = 0; arrayIndex < array.Count <String>(); arrayIndex++)
{
dt.Rows.Add(array[arrayIndex], 0, 0, array[arrayIndex] + "-" + 0);
}
DataColumn dc = new DataColumn();
dc.ColumnName = "value";
dt.Columns.Add(dc);
dt.Rows[0][4] = "1";
dt.Rows[1][4] = "2";
dt.Rows[2][4] = "3";
RadChart2.DataSource = dt;
RadChart2.DataBind();
int i = 0;
foreach (var item in RadChart2.Series[0].Items)
{
item.Appearance.FillStyle.MainColor = barColors[i++];
}
RadChart2.Visible = true;
}
else
{
RadChart2.Visible = false;
BLL.ShowMessage(this, "No Records are Available for the Selected Parameters.");
return;
}
}
else
{
RadChart2.Visible = false;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Pms_Rating_chart", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
void InitRadChart()
{
#region pregunta 1
RadChart1.Clear();
SetXAxis("1.- ¿Te Gustan Los VideoJuegos??", 3500, RadChart1);
RadChart1.PlotArea.XAxis.LayoutMode = ChartAxisLayoutMode.Between;
RadChart1.PlotArea.YAxis.AutoScale = false;
SetYAxis(500);
ChartSeries series1 = new ChartSeries("Si", ChartSeriesType.Bar);
series1.ActiveRegionUrl = "#P2";
SetSeriesAppearance(series1);
RadChart1.Series.Add(series1);
ChartSeries series2 = new ChartSeries("No", ChartSeriesType.Bar);
series2.ActiveRegionUrl = "#P3";
SetSeriesAppearance(series2);
RadChart1.Series.Add(series2);
ChartSeries series3 = new ChartSeries("Un poco", ChartSeriesType.Bar);
series3.ActiveRegionUrl = "#P4";
SetSeriesAppearance(series3);
RadChart1.Series.Add(series3);
series1.AddItem(1300);
series2.AddItem(1200);
series3.AddItem(1000);
#endregion
#region pregunta 2
RadChart2.Clear();
SetXAxis(" 2.- ¿Que tiempo te la pasas jugando al día?", 3500, RadChart2);
RadChart2.PlotArea.XAxis.LayoutMode = ChartAxisLayoutMode.Between;
RadChart2.PlotArea.YAxis.AutoScale = false;
SetYAxis(500);
ChartSeries series1G2 = new ChartSeries("2 hrs al día", ChartSeriesType.Bar);
SetSeriesAppearance(series1G2);
RadChart2.Series.Add(series1G2);
ChartSeries series2G2 = new ChartSeries("Entre 4 y 6 horas", ChartSeriesType.Bar);
SetSeriesAppearance(series2G2);
RadChart2.Series.Add(series2G2);
ChartSeries series3G2 = new ChartSeries("Todo el día", ChartSeriesType.Bar);
SetSeriesAppearance(series3G2);
RadChart2.Series.Add(series3G2);
series1G2.AddItem(1100);
series2G2.AddItem(1300);
series3G2.AddItem(1100);
#endregion
#region pregunta 2
RadChart3.Clear();
SetXAxis("3.- ¿Por que no te gustan?", 3500, RadChart3);
RadChart3.PlotArea.XAxis.LayoutMode = ChartAxisLayoutMode.Between;
RadChart3.PlotArea.YAxis.AutoScale = false;
SetYAxis(500);
ChartSeries series1G3 = new ChartSeries("Es una perdida de tiempo", ChartSeriesType.Bar);
SetSeriesAppearance(series1G3);
RadChart3.Series.Add(series1G3);
ChartSeries series2G3 = new ChartSeries("No tengo una consola", ChartSeriesType.Bar);
SetSeriesAppearance(series2G3);
RadChart3.Series.Add(series2G3);
ChartSeries series3G3 = new ChartSeries("No me gustan", ChartSeriesType.Bar);
SetSeriesAppearance(series3G3);
RadChart3.Series.Add(series3G3);
series1G3.AddItem(700);
series2G3.AddItem(800);
series3G3.AddItem(2000);
#endregion
#region pregunta 2
RadChart4.Clear();
SetXAxis(" 4.- ¿Que Juego te gusta mas?", 3500, RadChart4);
RadChart4.PlotArea.XAxis.LayoutMode = ChartAxisLayoutMode.Between;
RadChart4.PlotArea.YAxis.AutoScale = false;
SetYAxis(500);
series1G4 = new ChartSeries("Mario", ChartSeriesType.Bar);
SetSeriesAppearance(series1G4);
RadChart4.Series.Add(series1G4);
ChartSeries series2G4 = new ChartSeries("Fifa 11", ChartSeriesType.Bar);
SetSeriesAppearance(series2G4);
RadChart4.Series.Add(series2G4);
ChartSeries series3G4 = new ChartSeries("Stars wars", ChartSeriesType.Bar);
SetSeriesAppearance(series3G4);
RadChart4.Series.Add(series3G4);
series1G4.AddItem(600);
series2G4.AddItem(800);
series3G4.AddItem(2100);
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
loadPeriod();
SMHR_PERIOD _obj_smhr_Period = new SMHR_PERIOD();
_obj_smhr_Period.OPERATION = operation.Empty;
_obj_smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_DetailsLoad = BLL.get_PeriodHeaderDetails(_obj_smhr_Period);
if (dt_DetailsLoad.Rows.Count > 0)
{
rcmbPeriod.SelectedIndex = rcmbPeriod.Items.FindItemIndexByValue(Convert.ToString(dt_DetailsLoad.Rows[0][0]));
}
loadPeriodElement();
SMHR_PERIODDTL obj_smhr_Prddtl = new SMHR_PERIODDTL();
obj_smhr_Prddtl.OPERATION = operation.Empty;
obj_smhr_Prddtl.PRDDTL_PERIOD_ID = Convert.ToInt32(dt_DetailsLoad.Rows[0][0]);
DataTable dtPrddtl = BLL.get_PeriodDetails(obj_smhr_Prddtl);
if (dtPrddtl.Rows.Count > 0)
{
rcmbPeriodElement.SelectedIndex = rcmbPeriodElement.Items.FindItemIndexByValue(Convert.ToString(dtPrddtl.Rows[0][0]));
}
}
#region Display Leave-Balance in Pie-Chart
if (!Page.IsPostBack)
{
bool status = false;
Color[] barColors = new Color[8] {
Color.Purple,
Color.SteelBlue,
Color.Aqua,
Color.Yellow,
Color.Navy,
Color.Green,
Color.Blue,
Color.Red
};
SMHR_PERIOD obj_smhr_Period = new SMHR_PERIOD();
obj_smhr_Period.OPERATION = operation.Empty;
obj_smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_PeriodHeaderDetails(obj_smhr_Period);
if (dt_Details.Rows.Count != 0)
{
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
_obj_smhr_Dashboard.OPERATION = operation.Select_New;
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODID = Convert.ToInt32(dt_Details.Rows[0][0]);
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
DataTable dt_LeaveBalance = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_LeaveBalance.Rows.Count != 0)
{
for (int dt_rowcount = 0; dt_rowcount < dt_LeaveBalance.Rows.Count; dt_rowcount++)
{
if (dt_LeaveBalance.Rows.Count == 1)
{
if (Convert.ToDouble(dt_LeaveBalance.Rows[dt_rowcount]["LT_CURRENTBALANCE"]) == 0.00)
{
lbl_ZeroLeaves.Visible = true;
lbl_ZeroLeaves.Text = "No leaves available";
status = true;
}
}
}
if (status == false)
{
int i = 0;
RadChart2.Visible = true;
RadChart2.DataSource = dt_LeaveBalance;
RadChart2.DataBind();
foreach (var item in RadChart2.Series[0].Items)
{
item.Appearance.FillStyle.MainColor = barColors[i++];
}
}
}
else
{
lbl_ZeroLeaves.Visible = true;
lbl_ZeroLeaves.Text = "No leaves available";
}
}
else
{
BLL.ShowMessage(this, "Current Period does not contains Leave Balances");
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LeaveChart", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
Session["DASHBOARD"] = "true";
}
if (Convert.ToString(Session["EMP_ID"]) == "")
{
Response.Redirect("Login.aspx", false);
}
if (!Page.IsPostBack)
{
lbl_Birthday.Text = "BIRTHDAY REMINDERS - " + DateTime.Now.ToLongDateString().ToUpper();
getBirthday();
string str_Loginid = Convert.ToString(Session["USER_ID"]);
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
//CODE FOR FETCHING EMPLOYEE NAME
_obj_smhr_Dashboard.OPERATION = operation.Select;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(str_Loginid);
DataTable dt_getEMP_NAME = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_getEMP_NAME.Rows.Count != 0)
{
lbl_EmpName.Text = Convert.ToString(dt_getEMP_NAME.Rows[0][0]);
lbl_EmpBloodGroup.Text = Convert.ToString(dt_getEMP_NAME.Rows[0][1]);
}
else
{
BLL.ShowMessage(this, "No employee name exists for this login id");
//Response.Redirect("~/Login.aspx");
}
//CODE FOR FETCHING EMPLOYEE ID
_obj_smhr_Dashboard.OPERATION = operation.Select_Emp;
_obj_smhr_Dashboard.SMHR_DASHBOARD_LOGIN_ID = Convert.ToInt32(str_Loginid);
DataTable dt_getEMP_ID = BLL.get_EMP_ID(_obj_smhr_Dashboard);
string STR_EMP_ID = Convert.ToString(dt_getEMP_ID.Rows[0][0]);
lbl_EmpId.Text = STR_EMP_ID;
//CODE FOR FETCHING EMPLOYEE DESIGNATION
_obj_smhr_Dashboard.OPERATION = operation.Select_Pos;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_getEMP_DESG = BLL.get_EMP_ID(_obj_smhr_Dashboard);
lbl_EmpDesignation.Text = Convert.ToString(dt_getEMP_DESG.Rows[0][0]);
//CODE FOR FETCHING EMPLOYEE DEPARTMENT
_obj_smhr_Dashboard.OPERATION = operation.Select_Dept;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_getEMP_DEPT = BLL.get_EMP_ID(_obj_smhr_Dashboard);
lbl_EmpDepartment.Text = Convert.ToString(dt_getEMP_DEPT.Rows[0][0]);
//NO of Pending Leave Applications
_obj_smhr_Leaveapp = new SMHR_LEAVEAPP();
_obj_smhr_Leaveapp.OPERATION = operation.Check_New;
_obj_smhr_Leaveapp.LEAVEAPP_STATUS = Convert.ToInt32(0);
_obj_smhr_Leaveapp.LEAVEAPP_APPROVEDBY = Convert.ToInt32(STR_EMP_ID);
DataTable dt_NoOfPendingLeave = BLL.get_LeaveApp(_obj_smhr_Leaveapp);
lbl_pendingleave.Text = Convert.ToString(dt_NoOfPendingLeave.Rows[0][0]);
//No of Pending Comp-Off Application
_obj_smhr_Compoff = new SMHR_EMPCOMOFF();
_obj_smhr_Compoff.OPERATION = operation.Check_New;
_obj_smhr_Compoff.EMPCOMPOFF_STATUS = Convert.ToInt32(0);
_obj_smhr_Compoff.EMPCOMPOFF_APPROVEDBY = Convert.ToInt32(STR_EMP_ID);
DataTable dt_NoOfPendingCOMPOFF = BLL.get_empcompffs(_obj_smhr_Compoff);
lbl_pendingcompoff.Text = Convert.ToString(dt_NoOfPendingCOMPOFF.Rows[0][0]);
//No of Pending Expense Applications
_obj_smhr_Expense = new SMHR_EXPENSE();
_obj_smhr_Expense.OPERATION = operation.Check_New;
_obj_smhr_Expense.EXPENSE_STATUS = Convert.ToInt32(0);
_obj_smhr_Expense.EXPENSE_APPROVEDBY = Convert.ToInt32(STR_EMP_ID);
DataTable dt_NoOfPendingExpense = BLL.get_Expense(_obj_smhr_Expense);
lbl_pendingexpense.Text = Convert.ToString(dt_NoOfPendingExpense.Rows[0][0]);
//No of Pending Loan Applications
//EMPLOYEE LEAVE APPLICATION STATUS
_obj_smhr_Leaveapp = new SMHR_LEAVEAPP();
_obj_smhr_Leaveapp.OPERATION = operation.Select_New;
_obj_smhr_Leaveapp.EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_leavestatus = BLL.get_LeaveApp(_obj_smhr_Leaveapp);
int int_NoOfLeaves = dt_leavestatus.Rows.Count;
if (int_NoOfLeaves == 0)
{
lbl_MgrLeaveAppStatus.Text = "No leave application status available";
//BLL.ShowMessage(this, "No data available");
}
else
{
int lastLeaveStatus = Convert.ToInt32(dt_leavestatus.Rows[int_NoOfLeaves - 1][0]);
if (lastLeaveStatus == 0)
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Pending";
}
else if (lastLeaveStatus == 1)
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Approved";
}
else if (lastLeaveStatus == 2)
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Rejected";
}
else if (lastLeaveStatus == 3)
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Cancelled";
}
else
{
lbl_MgrLeaveAppStatus.Text = "Leave Application Not Found";
}
}
//EMPLOYEE COMP-OFF APPLICATION STATUS
_obj_smhr_Compoff = new SMHR_EMPCOMOFF();
_obj_smhr_Compoff.OPERATION = operation.Select_New;
_obj_smhr_Compoff.EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_compoff = BLL.get_empcompffs(_obj_smhr_Compoff);
int int_NoOfCompOff = dt_compoff.Rows.Count;
if (int_NoOfCompOff == 0)
{
lbl_MgrCompOffAppStatus.Text = "No comp-off application status available";
// BLL.ShowMessage(this, "No data available");
}
else
{
int lastCompOffStatus = Convert.ToInt32(dt_compoff.Rows[(int_NoOfCompOff) - 1][0]);
if (lastCompOffStatus == 0)
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Application Pending";
}
else if (lastCompOffStatus == 1)
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Application Approved";
}
else if (lastCompOffStatus == 2)
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Applicaiton Rejected";
}
else if (lastCompOffStatus == 3)
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Application Cancelled";
}
else
{
lbl_MgrCompOffAppStatus.Text = "Comp-Off Application Not Found";
}
}
//EMPLOYEE EXPENSE APPLICATION STATUS
_obj_smhr_Expense = new SMHR_EXPENSE();
_obj_smhr_Expense.OPERATION = operation.Select_New;
_obj_smhr_Expense.EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_expense = BLL.get_Expense(_obj_smhr_Expense);
int int_NoOfExpense = dt_compoff.Rows.Count;
if (int_NoOfExpense == 0)
{
lbl_MgrExpenseAppStatus.Text = "No expense application status available";
}
else
{
int lastExpenseStatus = Convert.ToInt32(dt_compoff.Rows[(int_NoOfExpense) - 1][0]);
if (lastExpenseStatus == 0)
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Pending";
}
else if (lastExpenseStatus == 1)
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Approved";
}
else if (lastExpenseStatus == 2)
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Rejected";
}
else if (lastExpenseStatus == 3)
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Cancelled";
}
else
{
lbl_MgrExpenseAppStatus.Text = "Expense Application Not Found";
}
}
//Modified
#region Pie-Chart for Ytd Balances
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
string str_MonthNo = DateTime.Now.Month.ToString();
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string str_Period_Month = mfi.GetMonthName(Convert.ToInt32(str_MonthNo));
string str_Period_Year = DateTime.Now.Year.ToString();
string str_PeriodName = str_Period_Month.ToUpper() + " " + str_Period_Year;
_obj_smhr_Dashboard.OPERATION = operation.Check_New;
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODNAME = str_PeriodName;
DataTable dt_PeriodID = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_PeriodID.Rows.Count == 0)
{
//DataTable dt_ZeroYtdBalance = new DataTable();
//BLL.ShowMessage(this, "No data available");
}
string str_PeriodId = Convert.ToString(dt_PeriodID.Rows[0][0]);
_obj_smhr_Dashboard.OPERATION = operation.Check1;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODID = Convert.ToInt32(str_PeriodId);
DataTable dt_YtdBalance = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_YtdBalance.Rows.Count == 0)
{
DataTable dt_ZeroYtdBalance = new DataTable();
DataRow dr_ZeroYtdBalance = dt_ZeroYtdBalance.NewRow();
DataColumn dc_ZeroYtdBalance = new DataColumn();
DataColumn dc_ZeroPayItem_PayDesc = new DataColumn();
dc_ZeroYtdBalance.ColumnName = "YtdBalance";
dc_ZeroPayItem_PayDesc.ColumnName = "payitem_paydesc";
dt_ZeroYtdBalance.Columns.Add(dc_ZeroYtdBalance);
dt_ZeroYtdBalance.Columns.Add(dc_ZeroPayItem_PayDesc);
dr_ZeroYtdBalance["YtdBalance"] = "0.00";
dr_ZeroYtdBalance["payitem_paydesc"] = "Ytd Balances";
dt_ZeroYtdBalance.Rows.Add(dr_ZeroYtdBalance);
RadChart_YtdBalances.DataSource = dt_ZeroYtdBalance;
RadChart_YtdBalances.DataBind();
//RadChart_YtdBalances.Visible = false;
//BLL.ShowMessage(this, "No data available for ytd balances");
}
else
{
RadChart_YtdBalances.DataSource = dt_YtdBalance;
RadChart_YtdBalances.DataBind();
}
#endregion
//Pie-chart
#region Pie-Chart for Leave Balance
bool status = false;
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
string str_Current_Year = DateTime.Now.Year.ToString();
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODNAME = str_Current_Year;
_obj_smhr_Dashboard.OPERATION = operation.Select_Period;
DataTable dt_Period_ID = BLL.get_EMP_ID(_obj_smhr_Dashboard);
string str_Period_Name = Convert.ToString(dt_Period_ID.Rows[0][0]);
_obj_smhr_Dashboard.OPERATION = operation.Select_New;
_obj_smhr_Dashboard.SMHR_DASHBOARD_PERIODNAME = str_Period_Name;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_LeaveBalance = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_LeaveBalance.Rows.Count != 0)
{
for (int int_rowcount = 0; int_rowcount < dt_LeaveBalance.Rows.Count; int_rowcount++)
{
if (Convert.ToDouble(dt_LeaveBalance.Rows[int_rowcount]["LT_CURRENTBALANCE"]) == 0.00)
{
//BLL.ShowMessage(this, "No leaves to have fun");
lbl_zeroleave.Visible = true;
lbl_zeroleave.Text = "No leaves available";
status = true;
}
}
if (status == false)
{
RadChart2.Visible = true;
RadChart2.DataSource = dt_LeaveBalance;
RadChart2.DataBind();
}
}
else
{
lbl_zeroleave.Visible = true;
lbl_zeroleave.Text = "No leaves available";
//BLL.ShowMessage(this, "No data available for leave balances");
}
#endregion
#region Pie-Chart for Performance Hikes
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
_obj_smhr_Dashboard.OPERATION = operation.Select_Hike;
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(STR_EMP_ID);
DataTable dt_Hike = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dt_Hike.Rows.Count != 0)
{
for (int int_rowcount = 0; int_rowcount < dt_Hike.Rows.Count; int_rowcount++)
{
if (Convert.ToDouble(dt_Hike.Rows[int_rowcount]["Hike"]) == 0.00)
{
//BLL.ShowMessage(this, "No leaves to have fun");
lbl_zerohike.Visible = true;
lbl_zerohike.Text = "No leaves available";
status = true;
}
}
if (status == false)
{
RadChart_Performance.Visible = true;
RadChart_Performance.DataSource = dt_Hike;
RadChart_Performance.DataBind();
}
}
else
{
lbl_zerohike.Visible = true;
lbl_zerohike.Text = "No leaves to have fun";
//BLL.ShowMessage(this, "No data available for leave balances");
}
#endregion
//Code For scrolling text
//_obj_smhr_Recruitmentupdates = new SMHR_RECRUITMENTUPDATES();
//_obj_smhr_Recruitmentupdates.OPERATION = operation.Select_New;
//_obj_smhr_Recruitmentupdates.SMHR_CURRENTDATE = DateTime.Now;
//DataTable dt_RecruitmentUpdates = BLL.get_RecruitmentUpdates(_obj_smhr_Recruitmentupdates);
//if (dt_RecruitmentUpdates.Rows.Count != 0)
//{
// //string str_ReqName = dt_RecruitmentUpdates.Rows[0]["JOBREQ_REQNAME"].ToString();
// Radticker1.DataSource = dt_RecruitmentUpdates;// dt_RecruitmentUpdates;
// Radticker1.DataTextField = "JOBREQ_UPDATE";
// //Radticker1.DataMember = str_ReqName;
// Radticker1.DataBind();
//}
//else
//{
// BLL.ShowMessage(this, "Recruitment are closed now");
//}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Dashboard1", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmbPeriodElement_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmbPeriodElement.SelectedIndex > 0)
{
trLeaveBalance.Visible = true;
bool status = false;
Color[] barColors = new Color[8] {
Color.Purple,
Color.SteelBlue,
Color.Aqua,
Color.Yellow,
Color.Navy,
Color.Green,
Color.Blue,
Color.Red
};
_obj_smhr_Dashboard = new SMHR_DAHSBOARD();
_obj_smhr_Dashboard.OPERATION = operation.Empty;
_obj_smhr_Dashboard.SMHR_DASHBOARD_PRDDTL_ID = Convert.ToInt32(rcmbPeriodElement.SelectedValue);
_obj_smhr_Dashboard.SMHR_DASHBOARD_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
DataTable dtLeaveDtl = BLL.get_EMP_ID(_obj_smhr_Dashboard);
if (dtLeaveDtl.Rows.Count > 0)
{
lbl_ZeroLeaves.Visible = false;
for (int dt_rowcount = 0; dt_rowcount < dtLeaveDtl.Rows.Count; dt_rowcount++)
{
if (dtLeaveDtl.Rows.Count == 1)
{
if (Convert.ToDouble(dtLeaveDtl.Rows[dt_rowcount]["LT_CURRENTBALANCE"]) == 0.00)
{
lbl_ZeroLeaves.Visible = true;
lbl_ZeroLeaves.Text = "No leaves available";
trLeaveBalance.Visible = false;
status = true;
}
}
}
if (status == false)
{
int i = 0;
RadChart2.Visible = true;
RadChart2.DataSource = dtLeaveDtl;
RadChart2.DataBind();
foreach (var item in RadChart2.Series[0].Items)
{
item.Appearance.FillStyle.MainColor = barColors[i++];
}
}
}
else
{
lbl_ZeroLeaves.Visible = true;
lbl_ZeroLeaves.Text = "No leaves available";
trLeaveBalance.Visible = false;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LeaveChart", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
