Пример #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            var emp = advanceDeductionDataGridView.DataSource;

            List <DL.AdvanceDeduction> viewSalarySheets = (List <DL.AdvanceDeduction>)emp;


            DateTime From = dateTimePicker1.Value;
            int      id   = Convert.ToInt32(comboBox4.SelectedValue);

            DL.Section section = db.Sections.Find(id);


            SalaryReportParameter salaryReportParameter = new SalaryReportParameter();

            salaryReportParameter.Unit       = section.Department.Unit.Name;
            salaryReportParameter.Department = section.Department.Name;
            salaryReportParameter.Section    = section.Name;
            salaryReportParameter.Date       = DateTime.Now;

            using (AdvancedeductionCrystalReport salaryCrystalReport = new AdvancedeductionCrystalReport(salaryReportParameter, viewSalarySheets))
            {
                salaryCrystalReport.ShowDialog();
            }
        }
Пример #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            DateTime        From         = dateTimePicker1.Value;
            int             id           = Convert.ToInt32(comboBox4.SelectedValue);
            List <Employee> employeesALL = db.Employees.Where(a => a.SectionId == id).ToList();
            List <Employee> employees    = employeesALL.Where(a => a.IsActive(From)).ToList();

            PopulateGrid(employees);

            DL.Section section = db.Sections.Find(id);
            label5.Text = "U: " + section.Department.Unit.Name + ";  D: " + section.Department.Name + ";  S: " + section.Name;
        }
Пример #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            DateTime       dateTime    = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
            int            id          = Convert.ToInt32(comboBox4.SelectedValue);
            List <DL.Loan> loans       = db.Loans.Where(a => a.Employee.SectionId == id).ToList();
            List <DL.Loan> currentLone = loans.Where(a => a.IsLoanPaid(dateTime)).ToList();

            List <ViewLoan> viewLoans = GetLoanList(currentLone, dateTime);

            viewLoanDataGridView.DataSource = null;
            viewLoanDataGridView.DataSource = viewLoans;


            DL.Section section = db.Sections.Find(id);
            label5.Text = "Unit:" + section.Department.Unit.Name + ", Department:" + section.Department.Name + ", Section:" + section.Name;
        }
Пример #4
0
        private void employeesDataGridView_CellContentClick(object sender, EventArgs e)
        {
            try
            {
                var      emp      = employeesDataGridView.CurrentRow;
                Employee emp2     = (Employee)emp.DataBoundItem;
                Employee employee = db.Employees.Find(emp2.Id);

                if (employee.SectionId != null)
                {
                    DL.Section section = db.Sections.Find(employee.SectionId);
                    LoadCompany();
                    //comboBox1.SelectedItem = section.Department.Unit.Company.Name;
                    ////LoadCombobox2();

                    //comboBox2.SelectedItem = section.Department.Unit.Name;
                    //comboBox3.SelectedItem = section.Department.Name;
                    //sectionIdComboBox.SelectedValue = section.Id;

                    comboBox1.SelectedText  = section.Department.Unit.Company.Name;
                    comboBox1.SelectedValue = section.Department.Unit.Company.Id;

                    comboBox2.SelectedText  = section.Department.Unit.Name;
                    comboBox2.SelectedValue = section.Department.Unit.Id;

                    comboBox3.SelectedText  = section.Department.Name;
                    comboBox3.SelectedValue = section.Department.Id;

                    sectionIdComboBox.SelectedText  = section.Name;
                    sectionIdComboBox.SelectedValue = section.Id;
                    //Display image
                }
                else
                {
                    LoadCompany();
                }


                pictureBox1.Image = null;
                pictureBox1.Image = new Bitmap(employee.ImagePath);
                checkBox1.Checked = false;
            }
            catch (Exception)
            {
            }
        }
Пример #5
0
        private void LoadCascadingDropDown()
        {
            checkBox4.Checked = false;
            try
            {
                var      emp      = employeesDataGridView.CurrentRow;
                Employee emp2     = (Employee)emp.DataBoundItem;
                Employee employee = db.Employees.Find(emp2.Id);
                //Is Active Status
                if (!employee.IsActive(DateTime.Now))
                {
                    inActiveCheckBox.Checked = true;
                    List <InActiveHistory> inActiveHistories = db.InActiveHistories.Where(a => a.EmployeeId == employee.Id).OrderBy(a => a.From).ToList();
                    inActiveDateTimePicker.Value = inActiveHistories[inActiveHistories.Count - 1].From;
                }
                else
                {
                    inActiveCheckBox.Checked     = false;
                    inActiveDateTimePicker.Value = DateTime.Now;
                }

                DL.Section section = db.Sections.Find(employee.SectionId);

                comboBox10.SelectedText  = section.Department.Unit.Company.Name;
                comboBox10.SelectedValue = section.Department.Unit.Company.Id;

                comboBox9.SelectedText  = section.Department.Unit.Name;
                comboBox9.SelectedValue = section.Department.Unit.Id;

                comboBox8.SelectedText  = section.Department.Name;
                comboBox8.SelectedValue = section.Department.Id;

                comboBox7.SelectedText  = section.Name;
                comboBox7.SelectedValue = section.Id;


                //Image Load
                pictureBox2.Image = null;
                pictureBox2.Image = new Bitmap(employee.ImagePath);
                checkBox4.Checked = false;
            }
            catch (Exception Ex)
            {
            }
        }
Пример #6
0
        private void button5_Click(object sender, EventArgs e)
        {
            var emp = viewOTDataGridView1.DataSource;

            List <ViewOT> viewSalarySheets = (List <ViewOT>)emp;


            DateTime From = dateTimePicker1.Value;
            DateTime Loop = new DateTime(From.Year, From.Month, 1);
            int      id   = Convert.ToInt32(comboBox4.SelectedValue);

            DL.Section section = db.Sections.Find(id);


            SalaryReportParameter salaryReportParameter = new SalaryReportParameter();

            salaryReportParameter.Unit       = section.Department.Unit.Name;
            salaryReportParameter.Department = section.Department.Name;
            salaryReportParameter.Section    = section.Name;
            salaryReportParameter.Date       = From;
            do
            {
                salaryReportParameter.Days = salaryReportParameter.Days + 1;
                if (Loop.DayOfWeek.ToString() == "Friday")
                {
                    salaryReportParameter.Weekend = salaryReportParameter.Weekend + 1;
                }

                var Holiday = db.Holidays.FirstOrDefault(a => a.DepartmentId == section.DepartmentId && a.From <= Loop && a.To >= Loop);
                if (Holiday != null)
                {
                    salaryReportParameter.Holiday = salaryReportParameter.Holiday + 1;
                }
                Loop = Loop.AddDays(1);
            } while (Loop.Month == From.Month);


            using (OTPaymentCrystalComReport salaryCrystalReport = new OTPaymentCrystalComReport(salaryReportParameter, viewSalarySheets))
            {
                salaryCrystalReport.ShowDialog();
            }
        }
Пример #7
0
        private void button5_Click(object sender, EventArgs e)
        {
            var emp = viewBonusDataGridView.DataSource;

            List <DL.ViewBonus> viewSalarySheets = (List <ViewBonus>)emp;



            int   bonusId = Convert.ToInt32(comboBox1.SelectedValue);
            Bonus bonus   = db.Bonus.Find(bonusId);

            DateTime To   = bonus.Date;
            DateTime From = To.AddYears(-1);

            int id = Convert.ToInt32(comboBox3.SelectedValue);

            DL.Department department = db.Departments.Find(id);

            int id2 = Convert.ToInt32(comboBox4.SelectedValue);

            DL.Section section = db.Sections.Find(id2);



            BonusCrystalPar salaryReportParameter = new BonusCrystalPar();

            salaryReportParameter.Unit       = department.Unit.Name;
            salaryReportParameter.Department = department.Name;
            salaryReportParameter.Section    = section.Name;
            salaryReportParameter.Date       = DateTime.Now;
            salaryReportParameter.BonusDate  = bonus.Date;
            salaryReportParameter.Festival   = bonus.Reason;

            // Calculate Company Wise
            List <Employee> employeesALL = db.Employees.Where(a => a.Section.Department.Unit.CompanyId == department.Unit.CompanyId).ToList();
            List <Employee> employees    = employeesALL.Where(a => a.IsActive(To) && a.IsEdited == true).ToList();

            try
            {
                List <ViewBonus> viewSalarySheetsCompany = GetList(employees);
                salaryReportParameter.CTE = viewSalarySheetsCompany.Sum(a => a.Bonus).ToString();
                salaryReportParameter.UTE = viewSalarySheetsCompany.Where(a => a.section.Department.UnitId == department.UnitId).Sum(a => a.Bonus).ToString();
                salaryReportParameter.DTE = viewSalarySheetsCompany.Where(a => a.section.DepartmentId == department.Id).Sum(a => a.Bonus).ToString();
                salaryReportParameter.STE = viewSalarySheets.Sum(a => a.Bonus).ToString();


                salaryReportParameter.CTB = viewSalarySheetsCompany.Count.ToString();
                salaryReportParameter.UTB = viewSalarySheetsCompany.Count(a => a.section.Department.UnitId == department.UnitId).ToString();
                salaryReportParameter.DTB = viewSalarySheetsCompany.Count(a => a.section.DepartmentId == department.Id).ToString();
                salaryReportParameter.STB = viewSalarySheets.Count.ToString();
            }
            catch
            {
            }



            using (BonusCrystalReport salaryCrystalReport = new BonusCrystalReport(salaryReportParameter, viewSalarySheets))
            {
                salaryCrystalReport.ShowDialog();
            }
        }
Пример #8
0
        private List <ViewBonus> GetList(List <Employee> employees)
        {
            int   bonusId = Convert.ToInt32(comboBox1.SelectedValue);
            Bonus bonus   = db.Bonus.Find(bonusId);


            DateTime To   = bonus.Date;
            DateTime From = To.AddYears(-1);


            List <ViewBonus> viewBonus = new List <ViewBonus>();

            foreach (Employee employee in employees)
            {
                ViewBonus view = new ViewBonus();
                try
                {
                    DateTime JoiningDate = Convert.ToDateTime(employee.HireDate);
                    view.JoiningDate = JoiningDate;
                    TimeSpan timeSpan = To.Subtract(JoiningDate);
                    view.Year = timeSpan.TotalDays / 365;
                }
                catch
                {
                }
                DL.Section section = db.Sections.Find(employee.SectionId);
                view.section           = section;
                view.CompanyPercentage = bonus.Amount;
                view.Emp_Id            = employee.Emp_Id;
                view.Name = employee.EmpFullName;

                if (employee.IsWorker == true)
                {
                    List <WorkerDesignationHistory> workerDesignationHistories = db.WorkerDesignationHistories.Where(a => a.EmployeeId == employee.Id && a.From <= To).ToList();
                    if (workerDesignationHistories.Count > 0)
                    {
                        DateTime maxDate = workerDesignationHistories.Max(a => a.From);

                        WorkerDesignationHistory workerDesignationHistory = workerDesignationHistories.FirstOrDefault(a => a.From == maxDate);


                        // Find Salary Grade At That Time
                        DL.WorkerDesignation     workerDesignation  = db.WorkerDesignations.Find(workerDesignationHistory.WorkerDesignationId);
                        List <ShadowSalaryGrade> shadowSalaryGrades = db.ShadowSalaryGrades.Where(a => a.UpdatedAt <= To && a.RoWId == workerDesignation.SalaryGrade.Id).ToList();
                        DateTime D2 = DateTime.Now;
                        if (shadowSalaryGrades.Count > 0)
                        {
                            D2 = shadowSalaryGrades.Max(a => a.UpdatedAt);
                            var shadowgrade = shadowSalaryGrades.FirstOrDefault(a => a.RoWId == workerDesignation.SalaryGrade.Id && a.UpdatedAt == D2);
                            view.Grade = workerDesignation.Name;
                            view.Gross = shadowgrade.Total;
                            view.Basic = shadowgrade.Salary;
                        }
                    }
                }
                else
                {
                    List <Salary> salaries = db.Salaries.Where(a => a.EmployeeId == employee.Id && a.Date <= To).ToList();
                    if (salaries.Count > 0)
                    {
                        DateTime maxDate = salaries.Max(a => a.Date);

                        Salary salary = salaries.FirstOrDefault(a => a.Date == maxDate);

                        //view.Grade = salary.;
                        view.Gross = salary.Amount;


                        List <SalarySetting> salarySettings = db.SalarySettings.Where(a => a.Date <= To).ToList();
                        if (salarySettings.Count > 0)
                        {
                            DateTime      maxDate2 = salarySettings.Max(a => a.Date);
                            SalarySetting settings = salarySettings.FirstOrDefault(a => a.Date == maxDate2);
                            view.Basic = salary.Amount * (100 / settings.Basic);
                        }
                    }
                }


                //Count Employee attendance
                List <Emp_CheckInOut> emp_CheckInOuts = db.Emp_CheckInOuts.Where(a => a.UserId == employee.Emp_Id).ToList();

                var DayCount = emp_CheckInOuts.Where(a => a.CHECKTIME >= From && a.CHECKTIME <= To).GroupBy(a => a.CHECKTIME.Date).ToList();
                view.Days = DayCount.Count - 1;

                viewBonus.Add(view);
            }

            return(viewBonus.ToList());
        }
Пример #9
0
        private void button2_Click(object sender, EventArgs e)
        {
            var emp = viewSalarySheetDataGridView.DataSource;

            List <ViewSalarySheet> viewSalarySheets = (List <ViewSalarySheet>)emp;


            DateTime From = dateTimePicker1.Value;
            DateTime Loop = new DateTime(From.Year, From.Month, 1);
            int      id   = Convert.ToInt32(comboBox4.SelectedValue);

            DL.Section section = db.Sections.Find(id);


            SalaryReportParameter salaryReportParameter = new SalaryReportParameter();

            salaryReportParameter.Unit       = section.Department.Unit.Name;
            salaryReportParameter.Department = section.Department.Name;
            salaryReportParameter.Section    = section.Name;
            salaryReportParameter.Date       = From;
            do
            {
                salaryReportParameter.Days = salaryReportParameter.Days + 1;
                if (Loop.DayOfWeek.ToString() == "Friday")
                {
                    salaryReportParameter.Weekend = salaryReportParameter.Weekend + 1;
                }

                var Holiday = db.Holidays.FirstOrDefault(a => a.DepartmentId == section.DepartmentId && a.From <= Loop && a.To >= Loop);
                if (Holiday != null)
                {
                    salaryReportParameter.Holiday = salaryReportParameter.Holiday + 1;
                }
                Loop = Loop.AddDays(1);
            } while (Loop.Month == From.Month);

            using (SalaryCrystalReport salaryCrystalReport = new SalaryCrystalReport(salaryReportParameter, viewSalarySheets))
            {
                salaryCrystalReport.ShowDialog();
            }



            //	public partial class SalaryCrystalReport : Form
            //{
            //	List<ViewSalarySheet> viewSalarySheets = new List<ViewSalarySheet>();
            //	SalaryReportParameter SalaryReportParameter = new SalaryReportParameter();

            //	public SalaryCrystalReport(SalaryReportParameter salaryReportParameter, List<ViewSalarySheet> vS)
            //	{
            //		InitializeComponent();
            //		viewSalarySheets = vS;
            //		SalaryReportParameter = salaryReportParameter;
            //	}

            //	private void crystalReportViewer1_Load(object sender, EventArgs e)
            //	{

            //	}

            //	private void SalaryCrystalReport_Load(object sender, EventArgs e)
            //	{
            //		salaryReport1.SetDataSource(viewSalarySheets);
            //		salaryReport1.SetParameterValue("Date", SalaryReportParameter.Date.ToString("dd/MM/yyyy"));
            //		salaryReport1.SetParameterValue("Days", SalaryReportParameter.Days);
            //		salaryReport1.SetParameterValue("Weekend", SalaryReportParameter.Weekend);
            //		salaryReport1.SetParameterValue("Holiday", SalaryReportParameter.Holiday);
            //		salaryReport1.SetParameterValue("Dept", SalaryReportParameter.Department);
            //		salaryReport1.SetParameterValue("Unit", SalaryReportParameter.Unit);
            //		salaryReport1.SetParameterValue("Section", SalaryReportParameter.Section);
            //		crystalReportViewer1.ReportSource = salaryReport1;
            //		crystalReportViewer1.Refresh();
            //	}
            //}

            //DGVPrinter printer = new DGVPrinter();

            //printer.Title = "Salary Report";
            //printer.SubTitle = "Saad Musa Group of Industries";

            //printer.SubTitle = string.Format("Date:{0}", dateTimePicker1.Value.Date);

            //printer.SubTitleFormatFlags = StringFormatFlags.LineLimit |

            //							  StringFormatFlags.NoClip;

            //printer.PageNumbers = true;

            //printer.PageNumberInHeader = false;
            //printer.PrintMargins.Left = 10;
            //printer.PrintMargins.Right = 10;
            //printer.PorportionalColumns = true;

            //printer.HeaderCellAlignment = StringAlignment.Near;

            //printer.Footer = "Saad Musa-Home Textile";

            //printer.FooterSpacing = 15;

            //printer.PageSettings.Landscape = true;

            //printer.PrintDataGridView(viewSalarySheetDataGridView);
        }