public static List <InventoryDetails> GetInventoryData() { EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL(); InventoryDetailsR _InventoryDetailsR = _employeedetailsbll.GetInventoryDetails(); int TotalStock = Convert.ToInt32(_InventoryDetailsR.TotalStock.ToString()); int TotalPurchase = Convert.ToInt32(_InventoryDetailsR.TotalPurchase.ToString()); int TotalIssue = Convert.ToInt32(_InventoryDetailsR.TotalIssue.ToString()); int TotalDamage = Convert.ToInt32(_InventoryDetailsR.TotalDamage.ToString()); int TotalReturn = Convert.ToInt32(_InventoryDetailsR.TotalReturn.ToString()); List <InventoryDetails> dataAtt = new List <InventoryDetails>() { new InventoryDetails { totalStock = "Total Stock", totalIssue = TotalStock }, new InventoryDetails { totalStock = "Total Purchase", totalIssue = TotalPurchase }, new InventoryDetails { totalStock = "Total Issue", totalIssue = TotalIssue }, new InventoryDetails { totalStock = "Total Damage", totalIssue = TotalDamage }, new InventoryDetails { totalStock = "Total Return", totalIssue = TotalReturn } }; return(dataAtt); }
private void GetAttendanceDetails() { EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL(); try { string status = ""; string startdate = ""; string endDate = ""; AttendanceDetailsR _attendanceDetailsR = _employeedetailsbll.GetAttendanceDetails(); if (_attendanceDetailsR != null) { lblTotalPresent.Text = _attendanceDetailsR.TotalPresent.ToString(); lblTotalAbsent.Text = _attendanceDetailsR.TotalAbsent.ToString(); lblTotalLate.Text = _attendanceDetailsR.TotalLate.ToString(); lblTotalLeave.Text = _attendanceDetailsR.TotalLeave.ToString(); lblTOtlaOt.Text = _attendanceDetailsR.TotalOT.ToString(); lblTotalEmp.Text = _attendanceDetailsR.CurrentEmployee.ToString(); //string mn = cTestChart.FindControl("amni").ToString(); //mn = _attendanceDetailsR.TotalPresent.ToString(); } } catch (Exception) { throw; } }
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 GetPosDetails() { EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL(); try { POSDetails _Pos = _employeedetailsbll.GetPosDetails(); if (_Pos != null) { lblTicketSale.Text = _Pos.TicketSale.ToString(); lblFoodSale.Text = _Pos.FoodSale.ToString(); } } catch (Exception) { throw; } }
private void GetInventoryDetails() { EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL(); try { InventoryDetailsR _inventory = _employeedetailsbll.GetInventoryDetails(); if (_inventory != null) { lblTotalStock.Text = _inventory.TotalStock.ToString(); lblTotalPurchase.Text = _inventory.TotalPurchase.ToString(); lblTotalIssue.Text = _inventory.TotalIssue.ToString(); lblTotalDamage.Text = _inventory.TotalDamage.ToString(); lblTotalReturn.Text = _inventory.TotalReturn.ToString(); } } catch (Exception) { throw; } }
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 <POS_Details> GettPOSData() { EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL(); POSDetails _POSDetailsR = _employeedetailsbll.GetPosDetails(); int TicketSales = Convert.ToInt32(_POSDetailsR.TicketSale.ToString()); int FoodSales = Convert.ToInt32(_POSDetailsR.FoodSale.ToString()); List <POS_Details> dataAtt = new List <POS_Details>() { new POS_Details { Ticket_Sale = "Ticket Sales", Food_Sale = TicketSales }, new POS_Details { Ticket_Sale = "Food Sales", Food_Sale = FoodSales } }; return(dataAtt); }
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); }
public static List <AttendanceDetailsd> GetAttendanceDatad() { EmployeeDetailsBLL _employeedetailsbll = new EmployeeDetailsBLL(); AttendanceDetailsR _attendanceDetailsR = _employeedetailsbll.GetAttendanceDetails(); int TotalPresent = Convert.ToInt32(_attendanceDetailsR.TotalPresent.ToString()); int TotalAbsent = Convert.ToInt32(_attendanceDetailsR.TotalAbsent.ToString()); int TotalLate = Convert.ToInt32(_attendanceDetailsR.TotalLate.ToString()); int TotalLeave = Convert.ToInt32(_attendanceDetailsR.TotalLeave.ToString()); int TotalOt = Convert.ToInt32(_attendanceDetailsR.TotalOT.ToString()); int TotalEmp = Convert.ToInt32(_attendanceDetailsR.CurrentEmployee.ToString()); List <AttendanceDetailsd> dataAttd = new List <AttendanceDetailsd>() { new AttendanceDetailsd { totalPresent = "Total", totalAbsent = TotalEmp }, new AttendanceDetailsd { totalPresent = "Present", totalAbsent = TotalPresent }, new AttendanceDetailsd { totalPresent = "Absent", totalAbsent = TotalAbsent }, new AttendanceDetailsd { totalPresent = "Late", totalAbsent = TotalLate }, new AttendanceDetailsd { totalPresent = "Leave", totalAbsent = TotalLeave }, new AttendanceDetailsd { totalPresent = "OT", totalAbsent = TotalOt } }; return(dataAttd); }
public static IEmployeeDetailsBLL createEmployeeDetailsBLL() { IEmployeeDetailsBLL objemployeedetailsbll = new EmployeeDetailsBLL(); return(objemployeedetailsbll); }