public static string GetServiceDetail(string RGroup, string EmployeeType, string OfficeType, string RetireYear, string OfficeWise, string District, string IsVerified)
{
try
{
Dashboard_DBLayer objDashboard_DBLayer = new Dashboard_DBLayer();
DataTable dt = new DataTable();
if (IsVerified != "")
{
dt = objDashboard_DBLayer.GetServiceDetail(EmployeeType, OfficeType, (RetireYear != "" ? Convert.ToInt32(RetireYear) : 0), OfficeWise, District, (IsVerified != "" ? true : false), (Convert.ToBoolean(IsVerified)));
}
else
{
dt = objDashboard_DBLayer.GetServiceDetail(EmployeeType, OfficeType, (RetireYear != "" ? Convert.ToInt32(RetireYear) : 0), OfficeWise, District, false);
}
RGroup = (RGroup == "" ? "EmployeeCode" : RGroup);
if (RGroup != "")
{
string strRGroup = JsonConvert.SerializeObject((new DataView(dt).ToTable(true, RGroup, "EmployeeName")));
return(JsonConvert.SerializeObject(dt) + "E_E" + strRGroup);
}
else
{
return(JsonConvert.SerializeObject(dt) + "E_E" + "");
}
}
catch (Exception ex)
{
return("");
}
}
public static string GetULBEmployeeCount(string empType)
{
try
{
Dashboard_DBLayer objDashboard_DBLayer = new Dashboard_DBLayer();
DataTable dt = new DataTable();
dt = objDashboard_DBLayer.GetULBEmployeeStatistics(empType);
DataTable dtOffices = new DataTable();
dtOffices = new DataView(dt).ToTable(true, "OfficeType");
ArrayList arrList = new ArrayList(dtOffices.Rows.Count);
foreach (DataRow dr in dtOffices.Rows)
{
string[] arrString = new string[]
{
dr[0].ToString(), dt.Compute("SUM(EmployeeCount)", "OfficeType = '" + dr[0].ToString() + "'").ToString()
};
arrList.Add(arrString);
}
DataTable dtDistricts = new DataTable();
dtDistricts = new DataView(dt).ToTable(true, "EnglishName");
ArrayList arrDistricts = new ArrayList(dtDistricts.Rows.Count);
int ind = 1;
string[] arrDistCol = new string[dtOffices.Rows.Count + 1];
arrDistCol[0] = "Offices";
//Add Column
foreach (DataRow dr in dtOffices.Rows)
{
arrDistCol[ind] = dr[0].ToString();
ind++;
}
arrDistricts.Add(arrDistCol);
foreach (DataRow Disdr in dtDistricts.Rows)
{
string[] arrString = new string[dtOffices.Rows.Count + 1];
arrString[0] = Disdr[0].ToString();
ind = 1;
foreach (DataRow dr in dtOffices.Rows)
{
arrString[ind] = dt.Compute("SUM(EmployeeCount)", "OfficeType = '" + dr[0].ToString() + "' And EnglishName = '" + Disdr[0].ToString() + "'").ToString();
ind++;
}
arrDistricts.Add(arrString);
}
string str = JsonConvert.SerializeObject(arrList) + "E_E" + JsonConvert.SerializeObject(arrDistricts);
return(str);
}
catch (Exception ex)
{
return("");
}
}
public static string GetEmployeeDetail(string RGroup, string EmployeeType, string OfficeType, string RetirementYear, string OfficeWise, string District, string Designation, string EmployeeName, string EmployeeKey, string JoiningYear, string IsVerified)
{
try
{
Dashboard_DBLayer objDashboard_DBLayer = new Dashboard_DBLayer();
DataTable dt = new DataTable();
if (IsVerified != "")
{
dt = objDashboard_DBLayer.GetEmployeePrimaryDetail(EmployeeType, OfficeType, (RetirementYear != "" ? Convert.ToInt32(RetirementYear) : 0), OfficeWise, District, Designation, EmployeeName, (EmployeeKey != "" ? Convert.ToInt32(EmployeeKey) : 0), (JoiningYear != "" ? Convert.ToInt32(JoiningYear) : 0), (IsVerified != "" ? true : false), (Convert.ToBoolean(IsVerified)));
}
else
{
dt = objDashboard_DBLayer.GetEmployeePrimaryDetail(EmployeeType, OfficeType, (RetirementYear != "" ? Convert.ToInt32(RetirementYear) : 0), OfficeWise, District, Designation, EmployeeName, (EmployeeKey != "" ? Convert.ToInt32(EmployeeKey) : 0), (JoiningYear != "" ? Convert.ToInt32(JoiningYear) : 0));
}
if (RGroup != "")
{
string strRGroup = JsonConvert.SerializeObject((new DataView(dt).ToTable(true, RGroup)));
return(JsonConvert.SerializeObject(dt) + "E_E" + strRGroup);
}
else
{
return(JsonConvert.SerializeObject(dt) + "E_E" + "");
}
}
catch (Exception ex)
{
return("");
}
}
public static string GetEmployeeCount()
{
try
{
Dashboard_DBLayer objDashboard_DBLayer = new Dashboard_DBLayer();
return(JsonConvert.SerializeObject(objDashboard_DBLayer.GetEmployeeStatistics()));
}
catch (Exception ex)
{
return("");
}
}
public static ICollection <ListItem> GetEmployeeCode()
{
try
{
Dashboard_DBLayer objDashboard_DBLayer = new Dashboard_DBLayer();
return(objDashboard_DBLayer.GetEmployeeCode());
}
catch (Exception ex)
{
return(null);
}
}
public static string GetEmployeeRetirement(string empType)
{
try
{
Dashboard_DBLayer objDashboard_DBLayer = new Dashboard_DBLayer();
DataTable dt = new DataTable();
dt = objDashboard_DBLayer.GetEmployeeRetirement(empType);
DataTable dtOffices = new DataTable();
dtOffices = new DataView(dt).ToTable(true, "OfficeType");
DataTable dtYear = new DataTable();
dtYear = new DataView(dt).ToTable(true, "RetYear");
ArrayList arrYear = new ArrayList(dtYear.Rows.Count);
int ind = 1;
string[] arrYearCol = new string[dtOffices.Rows.Count + 1];
arrYearCol[0] = "Year";
//Add Column
foreach (DataRow dr in dtOffices.Rows)
{
arrYearCol[ind] = dr[0].ToString();
ind++;
}
arrYear.Add(arrYearCol);
//Add Rows
foreach (DataRow Disdr in dtYear.Rows)
{
string[] arrString = new string[dtOffices.Rows.Count + 1];
arrString[0] = Disdr[0].ToString();
ind = 1;
foreach (DataRow dr in dtOffices.Rows)
{
arrString[ind] = dt.Compute("SUM(RetEmployee)", "OfficeType = '" + dr[0].ToString() + "' And RetYear = " + Disdr[0].ToString() + "").ToString();
ind++;
}
arrYear.Add(arrString);
}
string str = JsonConvert.SerializeObject(arrYear) + "E_E" + JsonConvert.SerializeObject(dt);
return(str);
}
catch (Exception ex)
{
return("");
}
}
public static string GetEmployeeLocationWise(string empType)
{
try
{
Dashboard_DBLayer objDashboard_DBLayer = new Dashboard_DBLayer();
DataTable dt = new DataTable();
dt = objDashboard_DBLayer.GetEmployeeLocationWise(empType);
string str = JsonConvert.SerializeObject(dt);
return(str);
}
catch (Exception ex)
{
return("");
}
}
public static ICollection <ListItem> GetColumnData(string columnname)
{
try
{
string tablename = "";
if (columnname == "OfficeType" || columnname == "OfficeName")
{
tablename = "dbo.OfficeMaster";
}
else if (columnname == "District")
{
columnname = "EnglishName";
tablename = "dbo.DistrictMaster";
}
else if (columnname == "Designation")
{
columnname = "EnglishName";
tablename = "dbo.DesignationMaster";
}
else if (columnname == "SubDesignation")
{
columnname = "EnglishName";
tablename = "dbo.SubDesignationMaster";
}
else if (columnname == "Gender")
{
columnname = "EmpGender";
tablename = "dbo.EmployeeMaster";
}
else
{
tablename = "dbo.EmployeeMaster";
}
Dashboard_DBLayer objDashboard_DBLayer = new Dashboard_DBLayer();
return(objDashboard_DBLayer.GetColumnValues(columnname, tablename));
}
catch (Exception ex)
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lblCurrDate.Text = "Dated: " + DateTime.Now.Date.ToShortDateString();
Dashboard_DBLayer db = new Dashboard_DBLayer();
dsEmp = db.GetEmployeeDetail(Request.QueryString.Get("EK").ToString());
if (dsEmp.Tables[0].Rows.Count > 0)
{
employeecode.InnerText = dsEmp.Tables[0].Rows[0]["EmployeeCode"].ToString();
employeename2.InnerText = dsEmp.Tables[0].Rows[0]["EmployeeName"].ToString();
employeename.InnerText = "Employee Detail - " + dsEmp.Tables[0].Rows[0]["EmployeeName"].ToString();
currposting.InnerText = dsEmp.Tables[0].Rows[0]["OfficeName"].ToString();
designationname.InnerText = dsEmp.Tables[0].Rows[0]["DesignationName"].ToString();
empdob.InnerText = dsEmp.Tables[0].Rows[0]["EmpDOB"].ToString();
empdor.InnerText = dsEmp.Tables[0].Rows[0]["EmpDOR"].ToString();
vetanmaan.InnerText = dsEmp.Tables[0].Rows[0]["Vetanmaan"].ToString();
gradevetan.InnerText = dsEmp.Tables[0].Rows[0]["GradeVetan"].ToString();
JoiningDate.InnerText = dsEmp.Tables[0].Rows[0]["EmpDOJ"].ToString();
SourceRecruitment.InnerText = dsEmp.Tables[0].Rows[0]["SourceOfAppointment"].ToString();
ClassName.InnerText = dsEmp.Tables[0].Rows[0]["ClassName"].ToString();
AppointmentOrderNo.InnerText = dsEmp.Tables[0].Rows[0]["Appointment_Order"].ToString();
gender.InnerText = dsEmp.Tables[0].Rows[0]["Gender"].ToString();
}
dsTransfer = db.GetTransferDetail(employeecode.InnerText);
dsQualification = db.GetQualificationDetail(employeecode.InnerText);
dsACR = db.GetACRDetail(employeecode.InnerText);
}
}