public static List <EmployeeDetailsd> GetChartDatad()
{
//string sConnString = "Data Source=192.168.0.7;Initial Catalog=ERPSSL_Crescent;User ID=sa;Password=ssl@1234;Connect Timeout=30;";
//SqlConnection con = new SqlConnection(sConnString);
//SqlCommand cmd = new SqlCommand("select Top 1 FirstName as TotalActionEmp, count (FirstName) as TotalNewJoin from HRM_PersonalInformations where EID='00001'", con);
// // cmd.CommandType = CommandType.TableDirect;
// SqlDataAdapter da = new SqlDataAdapter();
// da.SelectCommand = cmd;
// DataTable dt = new DataTable();
// da.Fill(dt);
EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL();
EmployeeDetailsR _employeeDetailsr = _employeedetailsbll.GetEmployeeDetails();
int TotalEmp = Convert.ToInt32(_employeeDetailsr.TotalEmployee.ToString());
int TotalSeperation = Convert.ToInt32(_employeeDetailsr.TotalInactive.ToString());
int CurrentEmp = Convert.ToInt32(_employeeDetailsr.CurrentEmp.ToString());
int NewJoining = Convert.ToInt32(_employeeDetailsr.TotalNewJoin.ToString());
int TotalMale = Convert.ToInt32(_employeeDetailsr.TotalMale.ToString());
int TotalFemal = Convert.ToInt32(_employeeDetailsr.TotalFemale.ToString());
List <EmployeeDetailsd> dataList = new List <EmployeeDetailsd>()
{
new EmployeeDetailsd {
TotalActionEmp = "Total Employee", TotalNewJoin = TotalEmp
},
new EmployeeDetailsd {
TotalActionEmp = "Total Seperation", TotalNewJoin = TotalSeperation
},
new EmployeeDetailsd {
TotalActionEmp = "Current Employee", TotalNewJoin = CurrentEmp
},
new EmployeeDetailsd {
TotalActionEmp = "Total Male", TotalNewJoin = TotalMale
},
new EmployeeDetailsd {
TotalActionEmp = "Total Female", TotalNewJoin = TotalFemal
},
new EmployeeDetailsd {
TotalActionEmp = "New Joining", TotalNewJoin = NewJoining
}
};
//foreach (DataRow dtrow in dt.Rows)
//{
// EmployeeDetails details = new EmployeeDetails();
// details.TotalActionEmp = dtrow[0].ToString();
// details.TotalNewJoin = (int)dtrow[1];
// dataList.Add(details);
//}
return(dataList);
}
private void GetEmployeeDetails()
{
EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL();
try
{
EmployeeDetailsR _employeeDetailsr = _employeedetailsbll.GetEmployeeDetails();
if (_employeeDetailsr != null)
{
lblTotalEmployee.Text = _employeeDetailsr.TotalEmployee.ToString();
lblTotalSepartion.Text = _employeeDetailsr.TotalInactive.ToString();
lblCurrentEmp.Text = _employeeDetailsr.CurrentEmp.ToString();
lblTotalFemale.Text = _employeeDetailsr.TotalFemale.ToString();
lblTotalMale.Text = _employeeDetailsr.TotalMale.ToString();
lblNewjoining.Text = _employeeDetailsr.TotalNewJoin.ToString();
}
}
catch (Exception)
{
throw;
}
}
