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 GetLastMonthEmpDetails()
{
EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL();
try
{
EmployeeDetailsR _employeeDetailsr = _employeedetailsbll.GetLastMonthEmpDetails();
if (_employeeDetailsr != null)
{
lblLastTotalEmp.Text = _employeeDetailsr.LastMonthCurrentEmp.ToString();
lblLastLeft.Text = _employeeDetailsr.TotalSeperation.ToString();
lblLastNewJoining.Text = _employeeDetailsr.LastaMonthTotalNewJoin.ToString();
lblLastOTHour.Text = _employeeDetailsr.TotalOverTime.ToString();
lblLastOTTaka.Text = _employeeDetailsr.TotalOTTaka.ToString();
lblTotalSal.Text = _employeeDetailsr.TotalGrossSalary.ToString();
}
}
catch (Exception)
{
throw;
}
}
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;
}
}
public static List <LastMonthEmployeeDetails> GetLastMonthEmp()
{
EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL();
EmployeeDetailsR _employeeDetailsr = _employeedetailsbll.GetLastMonthEmpDetails();
int LastMonthCurrentEmp = Convert.ToInt32(_employeeDetailsr.LastMonthCurrentEmp.ToString());
int TotalSeperation = Convert.ToInt32(_employeeDetailsr.TotalSeperation.ToString());
int TotalOverTime = Convert.ToInt32(_employeeDetailsr.TotalOverTime.ToString());
int TotalOTTaka = Convert.ToInt32(_employeeDetailsr.TotalOTTaka.ToString());
int LastaMonthTotalNewJoin = Convert.ToInt32(_employeeDetailsr.LastaMonthTotalNewJoin.ToString());
int TotalGrossSalary = Convert.ToInt32(_employeeDetailsr.TotalGrossSalary.ToString());
List <LastMonthEmployeeDetails> dataAttd = new List <LastMonthEmployeeDetails>()
{
new LastMonthEmployeeDetails {
totalEmp = "Current Emp", TotalValue = LastMonthCurrentEmp
},
new LastMonthEmployeeDetails {
totalEmp = "Total Left", TotalValue = TotalSeperation
},
new LastMonthEmployeeDetails {
totalEmp = "Total OT", TotalValue = TotalOverTime
},
new LastMonthEmployeeDetails {
totalEmp = "Total OT Taka", TotalValue = TotalOTTaka
},
new LastMonthEmployeeDetails {
totalEmp = "New Join", TotalValue = LastaMonthTotalNewJoin
},
new LastMonthEmployeeDetails {
totalEmp = "Total Salary", TotalValue = TotalGrossSalary
}
};
return(dataAttd);
}
