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();
}
}
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();
}
}
public OTPaymentCrystalReport(SalaryReportParameter salaryReportParameter, List <ViewOT> vS)
{
InitializeComponent();
viewSalarySheets = vS;
SalaryReportParameter = salaryReportParameter;
}
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);
}
public AdvancedeductionCrystalReport(SalaryReportParameter salaryReportParameter, List <DL.AdvanceDeduction> vS)
{
InitializeComponent();
viewSalarySheets = vS;
SalaryReportParameter = salaryReportParameter;
}
