private void FrmBaoCaoTonKho_Load(object sender, EventArgs e)
{
LayThongTinBaoCao();
DataTable dsmh = new DataTable();
DataTable ds = new DataTable();
dsmh = bus_baocaotonkho.LayDanhSachMatHang(dto_baocaotonkho);
ds = bus_baocaotonkho.LayDanhSachMatHang(dto_baocaotonkho);
ds.Columns.Add("SLBan");
ds.Columns.Add("SLNhap");
ds.Columns.Add("SLTon");
ds.Columns.Add("SLThuc");
for (int i = 0; i < ds.Rows.Count; i++)
{
ds.Rows[i]["SLBan"] = bus_baocaotonkho.LaySLBan(dto_baocaotonkho, ds.Rows[i]["MaMH"].ToString()).Rows[0][1].ToString();
ds.Rows[i]["SLNhap"] = bus_baocaotonkho.LaySLNhap(dto_baocaotonkho, ds.Rows[i]["MaMH"].ToString()).Rows[0][1].ToString();
double SLTon = Double.Parse(ds.Rows[i]["SLNhap"].ToString()) - Double.Parse(ds.Rows[i]["SLBan"].ToString());//bus_baocaotonkho.TongGiaTriBan(dto_baocaotonkho, ds.Rows[i]["MaMH"].ToString());
ds.Rows[i]["SLTon"] = SLTon.ToString();
double SLThuc = 0;//bus_baocaotonkho.TongGiaTriNhap(dto_baocaotonkho, ds.Rows[i]["MaMH"].ToString());
ds.Rows[i]["SLThuc"] = SLThuc.ToString();
}
ds.Columns.Remove("MaMH");
reportViewer1.Reset();
reportViewer1.LocalReport.ReportEmbeddedResource = "GUI_QLVLXD.BaoCaoTonKho.rdlc";
reportViewer1.LocalReport.DataSources.Clear();
Microsoft.Reporting.WinForms.ReportDataSource newDataSource = new Microsoft.Reporting.WinForms.ReportDataSource("BaocaoTonKho", ds);
newDataSource.Name = "DataSet1";
reportViewer1.LocalReport.DataSources.Add(newDataSource);
List<Microsoft.Reporting.WinForms.ReportParameter> Parameters = new List<Microsoft.Reporting.WinForms.ReportParameter>();
Microsoft.Reporting.WinForms.ReportParameter param = default(Microsoft.Reporting.WinForms.ReportParameter);
param = new Microsoft.Reporting.WinForms.ReportParameter("TuNgay", dto_baocaotonkho.TuNgay);
Parameters.Add(param);
param = new Microsoft.Reporting.WinForms.ReportParameter("DenNgay", dto_baocaotonkho.DenNgay);
Parameters.Add(param);
reportViewer1.LocalReport.SetParameters(Parameters);
this.reportViewer1.RefreshReport();
}
private void frHoaDonIn_Load(object sender, EventArgs e)
{
string mahd = HoaDonDAO.Instance.getMaxMaHD();
HoaDon hd = HoaDonDAO.Instance.getHoaDon(mahd);
KhachHang kh = KhachHangDAO.Instance.getKHbyMaHD(mahd);
this.getCTPYCTableAdapter.Fill(this.QUANLYNHAHANGDataSet.getCTPYC, Data.MaPYC);
Microsoft.Reporting.WinForms.ReportParameter[] p = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("mahd", mahd),
new Microsoft.Reporting.WinForms.ReportParameter("maban", Data.Maban),
new Microsoft.Reporting.WinForms.ReportParameter("ngaylap", hd.Ngaylap.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("makh", kh.Makh),
new Microsoft.Reporting.WinForms.ReportParameter("tenkh", kh.Tenkh),
new Microsoft.Reporting.WinForms.ReportParameter("sdt", kh.Sdt),
new Microsoft.Reporting.WinForms.ReportParameter("chietkhau", Data.ChietkhauHD),
new Microsoft.Reporting.WinForms.ReportParameter("tongtien", Data.TongtienHD),
new Microsoft.Reporting.WinForms.ReportParameter("tongcong", Data.TongcongHD),
};
this.reportViewer1.LocalReport.SetParameters(p);
this.reportViewer1.RefreshReport();
}
private void btnBugRating_Click(object sender, EventArgs e)
{
reportViewer1.Hide();
reportViewer3.Hide();
reportViewer4.Hide();
using (Assignment2Entities5 db = new Assignment2Entities5())
{
GetBugRating_ResultBindingSource.DataSource = db.GetBugRating(cmbFrom.SelectedItem.ToString(), cmbTo.SelectedItem.ToString(), this.projectIDRP);
Microsoft.Reporting.WinForms.ReportParameter[] rPara = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("FromDate", cmbFrom.SelectedItem.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("ToDate", cmbTo.SelectedItem.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("ProjectID", this.projectIDRP)
};
reportViewer2.LocalReport.SetParameters(rPara);
reportViewer2.RefreshReport();
reportViewer2.Show();
reportViewer2.Dock = DockStyle.None;
reportViewer2.BorderStyle = BorderStyle.None;
}
}
public void GenerateReport()
{
// this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns." + this.TemplateValue;
this.stp_AppUsersResultBindingSource.DataSource = _DataSource;
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[3];
string address = AppVars.objSubCompany.Address;
string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo;
string heading = this.ReportHeading;
param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyHeading", AppVars.objSubCompany.CompanyName);
param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", AppVars.objSubCompany.Address);
param[2] = new Microsoft.Reporting.WinForms.ReportParameter("ReportParameterPeriod", heading);
reportViewer1.LocalReport.SetParameters(param);
this.reportViewer1.ZoomPercent = 100;
this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
this.reportViewer1.RefreshReport();
IsReportLoaded = true;
}
private void frmInBaoCaoDoanhThuBanHang_Load(object sender, EventArgs e)
{
Microsoft.Reporting.WinForms.ReportParameter[] pra =
new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("tungay", tungay),
new Microsoft.Reporting.WinForms.ReportParameter("denngay", denngay),
new Microsoft.Reporting.WinForms.ReportParameter("tongtien", tongtien),
new Microsoft.Reporting.WinForms.ReportParameter("tongsl", sl),
new Microsoft.Reporting.WinForms.ReportParameter("ngay1", ngay1),
new Microsoft.Reporting.WinForms.ReportParameter("thang1", thang1),
new Microsoft.Reporting.WinForms.ReportParameter("nam1", nam1),
new Microsoft.Reporting.WinForms.ReportParameter("ngay2", ngay2),
new Microsoft.Reporting.WinForms.ReportParameter("thang2", thang2),
new Microsoft.Reporting.WinForms.ReportParameter("nam2", nam2),
};
this.reportViewerBaoCaoDoanhThuBanHang.LocalReport.SetParameters(pra);
this.HOADONBANHANGTableAdapter.Fill(this.QuanLiBanHang_DotNetDataSet3.HOADONBANHANG, Convert.ToInt32(ngay1),
Convert.ToInt32(ngay2), Convert.ToInt32(thang1), Convert.ToInt32(thang2), Convert.ToInt32(nam1), Convert.ToInt32(nam2)
);
this.reportViewerBaoCaoDoanhThuBanHang.RefreshReport();
}
public OrderPaymentPrint(List <OrderReceipt> dataSource, Dictionary <string, string> item_list)
{
InitializeComponent();
DateTime dateTime = DateTime.UtcNow.Date;
reportViewer.LocalReport.DataSources.Clear();
Microsoft.Reporting.WinForms.ReportParameter[] parameters = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("pTotal", item_list["total"]),
new Microsoft.Reporting.WinForms.ReportParameter("pDiscount", item_list["discount"]),
new Microsoft.Reporting.WinForms.ReportParameter("pOrderNo", item_list["order_id"]),
new Microsoft.Reporting.WinForms.ReportParameter("pOrderType", item_list["order_type"]),
new Microsoft.Reporting.WinForms.ReportParameter("pBarCode", item_list["barcode_image"]),
new Microsoft.Reporting.WinForms.ReportParameter("pPaymentReceived", item_list["payment_received"]),
new Microsoft.Reporting.WinForms.ReportParameter("pCashBack", item_list["cash_back"]),
new Microsoft.Reporting.WinForms.ReportParameter("pSumQty", item_list["sum_qty"]),
new Microsoft.Reporting.WinForms.ReportParameter("pDate", dateTime.ToString("f"))
};
reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("ds", OrderPaymentPrint.ToDataTable(dataSource)));
this.reportViewer.LocalReport.SetParameters(parameters);
this.reportViewer.RefreshReport();
}
private void R_CuentasProveedores_Load(object sender, EventArgs e)
{
Microsoft.Reporting.WinForms.ReportParameter Personas;
if (tagIndicador == 1)
{
Personas = new Microsoft.Reporting.WinForms.ReportParameter("Personas", "clientes");
CuentasCorrientesBindingSource.DataSource = Cdatos_reportes.CuentasClientes(Alta);
}
else if (tagIndicador == 2)
{
Personas = new Microsoft.Reporting.WinForms.ReportParameter("Personas", "proveedores");
CuentasCorrientesBindingSource.DataSource = Cdatos_reportes.CuentasProveedores(Alta);
}
else
{
Personas = new Microsoft.Reporting.WinForms.ReportParameter("Personas", "Usuarios");
CuentasCorrientesBindingSource.DataSource = Cdatos_reportes.CuentasUsuarios(Alta);
}
reportViewer1.LocalReport.SetParameters(Personas);
System.Drawing.Printing.PageSettings page = new System.Drawing.Printing.PageSettings();
page.Margins = new System.Drawing.Printing.Margins(50, 50, 50, 50);
reportViewer1.SetPageSettings(page);
this.reportViewer1.RefreshReport();
}
private void frmContezinoContrato_Load(object sender, EventArgs e)
{
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.ReportEmbeddedResource = "ContezaAdmin.RPT.RPT0001.rdlc";
Microsoft.Reporting.WinForms.ReportParameter[] p = new Microsoft.Reporting.WinForms.ReportParameter[8];
p[0] = new Microsoft.Reporting.WinForms.ReportParameter("PrNomeContezino", vNomeCompleto);
p[1] = new Microsoft.Reporting.WinForms.ReportParameter("PrCPF", vCPF);
p[2] = new Microsoft.Reporting.WinForms.ReportParameter("PrRG", vRG);
p[3] = new Microsoft.Reporting.WinForms.ReportParameter("PrOrgaoEmissor", vOrgaoEmissor);
p[4] = new Microsoft.Reporting.WinForms.ReportParameter("PrCidade", vCidade);
p[5] = new Microsoft.Reporting.WinForms.ReportParameter("PrDia", vDia);
p[6] = new Microsoft.Reporting.WinForms.ReportParameter("PrMes", vMes);
p[7] = new Microsoft.Reporting.WinForms.ReportParameter("PrAno", vAno);
reportViewer1.LocalReport.SetParameters(p);
reportViewer1.LocalReport.Refresh();
reportViewer1.RefreshReport();
//this.reportViewer1.RefreshReport();
}
private void frmInHoaDon_Load(object sender, EventArgs e)
{
InHoaDon_ResultBindingSource.DataSource = HoaDonBUS.InHD(IDHD, IDCH);
HoaDon hd = HoaDonBUS.Get1HD(IDHD, IDCH);
KhachHang kh = KHBUS.GetKHByMAKH(hd.MaKH);
CuaHang ch = CuaHangBUS.GetThongTinCuaHang(hd.MaCuaHang);
Microsoft.Reporting.WinForms.ReportParameter[] rParams = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("DateNhap", hd.NgayLapHD.ToShortDateString().ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TongTien", ChiTietHoaDonBUS.TinhTien_ByMaHD(IDHD, IDCH).ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TenCH", ch.TenCuaHang),
new Microsoft.Reporting.WinForms.ReportParameter("DiaChi", ch.DiaChi),
new Microsoft.Reporting.WinForms.ReportParameter("TenNguoiMua", kh.TenKH),
new Microsoft.Reporting.WinForms.ReportParameter("DiaChiNguoiMua", kh.DiaChi),
new Microsoft.Reporting.WinForms.ReportParameter("SDT", kh.SDT),
new Microsoft.Reporting.WinForms.ReportParameter("HtGiaoHang", hd.HTGiaoHang),
new Microsoft.Reporting.WinForms.ReportParameter("MaHD", IDHD)
};
reportInHD.LocalReport.SetParameters(rParams);
this.reportInHD.RefreshReport();
}
public Relatorio(string Qmin, string Qmax, string Barometro, string SensorTemp, string client, string Endereco, string DataCalibracao
, string DataEmissao, string Tipo, string Diametro, string AnoFabricacao, string Instrucao, string Designacao, string Descricao, string Fluido
, string TemperaturaAmbiente, string PrecaoBarometrica, string UmidadeRelativa, string MedidorM, string ModeloM, string FabricanteM, string NserieM, string MedidorT, string ModeloT, string FabricanteT, string NserieT, string Operador, string FatorKM
, string tx1, string tx2, string tx3, string tx4, string tx5, string tx6, string tx7, string tx8, string tx9, string tx10, string tx11, string tx12, string tx13, string tx14
, string tx15, string tx16, string tx17, string tx18, string tx19, string tx20, string tx21, string tx22, string tx23, string tx24, string tx25, string tx26
, string tx27, string tx28, string tx29, string tx30, string tx31, string tx32, string tx33, string tx34, string tx35, string tx36 /*, string tx37, string tx38
* , string tx39, string tx40*/)
{
InitializeComponent();
Microsoft.Reporting.WinForms.ReportParameter[] p = new Microsoft.Reporting.WinForms.ReportParameter[64];
p[0] = new Microsoft.Reporting.WinForms.ReportParameter("Qmin", Qmin);
p[1] = new Microsoft.Reporting.WinForms.ReportParameter("Qmax", Qmax);
p[2] = new Microsoft.Reporting.WinForms.ReportParameter("Barometro", Barometro);
p[3] = new Microsoft.Reporting.WinForms.ReportParameter("SensorTemp", SensorTemp);
p[4] = new Microsoft.Reporting.WinForms.ReportParameter("client", client);
p[5] = new Microsoft.Reporting.WinForms.ReportParameter("Endereco", Endereco);
p[6] = new Microsoft.Reporting.WinForms.ReportParameter("DataCalibracao", DataCalibracao);
p[7] = new Microsoft.Reporting.WinForms.ReportParameter("DataEmissao", DataEmissao);
p[8] = new Microsoft.Reporting.WinForms.ReportParameter("Tipo", Tipo);
p[9] = new Microsoft.Reporting.WinForms.ReportParameter("Diametro", Diametro);
p[10] = new Microsoft.Reporting.WinForms.ReportParameter("AnoFabricacao", AnoFabricacao);
p[11] = new Microsoft.Reporting.WinForms.ReportParameter("Instrucao", Instrucao);
p[12] = new Microsoft.Reporting.WinForms.ReportParameter("Designacao", Designacao);
p[13] = new Microsoft.Reporting.WinForms.ReportParameter("Descricao", Descricao);
p[14] = new Microsoft.Reporting.WinForms.ReportParameter("Fluido", Fluido);
p[15] = new Microsoft.Reporting.WinForms.ReportParameter("TemperaturaAmbiente", TemperaturaAmbiente);
p[16] = new Microsoft.Reporting.WinForms.ReportParameter("PrecaoBarometrica", PrecaoBarometrica);
p[17] = new Microsoft.Reporting.WinForms.ReportParameter("UmidadeRelativa", UmidadeRelativa);
p[18] = new Microsoft.Reporting.WinForms.ReportParameter("MedidorM", MedidorM);
p[19] = new Microsoft.Reporting.WinForms.ReportParameter("ModeloM", ModeloM);
p[20] = new Microsoft.Reporting.WinForms.ReportParameter("FabricanteM", FabricanteM);
p[21] = new Microsoft.Reporting.WinForms.ReportParameter("NserieM", NserieM);
p[22] = new Microsoft.Reporting.WinForms.ReportParameter("MedidorT", MedidorT);
p[23] = new Microsoft.Reporting.WinForms.ReportParameter("ModeloT", ModeloT);
p[24] = new Microsoft.Reporting.WinForms.ReportParameter("FabricanteT", FabricanteT);
p[25] = new Microsoft.Reporting.WinForms.ReportParameter("NserieT", NserieT);
p[26] = new Microsoft.Reporting.WinForms.ReportParameter("Operador", Operador);
p[27] = new Microsoft.Reporting.WinForms.ReportParameter("FatorKM", FatorKM);
p[28] = new Microsoft.Reporting.WinForms.ReportParameter("tx1", tx1);
p[29] = new Microsoft.Reporting.WinForms.ReportParameter("tx2", tx2);
p[30] = new Microsoft.Reporting.WinForms.ReportParameter("tx3", tx3);
p[31] = new Microsoft.Reporting.WinForms.ReportParameter("tx4", tx4);
p[32] = new Microsoft.Reporting.WinForms.ReportParameter("tx5", tx5);
p[33] = new Microsoft.Reporting.WinForms.ReportParameter("tx6", tx6);
p[34] = new Microsoft.Reporting.WinForms.ReportParameter("tx7", tx7);
p[35] = new Microsoft.Reporting.WinForms.ReportParameter("tx8", tx8);
p[36] = new Microsoft.Reporting.WinForms.ReportParameter("tx9", tx9);
p[37] = new Microsoft.Reporting.WinForms.ReportParameter("tx10", tx10);
p[38] = new Microsoft.Reporting.WinForms.ReportParameter("tx11", tx11);
p[39] = new Microsoft.Reporting.WinForms.ReportParameter("tx12", tx12);
p[40] = new Microsoft.Reporting.WinForms.ReportParameter("tx13", tx13);
p[41] = new Microsoft.Reporting.WinForms.ReportParameter("tx14", tx14);
p[42] = new Microsoft.Reporting.WinForms.ReportParameter("tx15", tx15);
p[43] = new Microsoft.Reporting.WinForms.ReportParameter("tx16", tx16);
p[44] = new Microsoft.Reporting.WinForms.ReportParameter("tx17", tx17);
p[45] = new Microsoft.Reporting.WinForms.ReportParameter("tx18", tx18);
p[46] = new Microsoft.Reporting.WinForms.ReportParameter("tx19", tx19);
p[47] = new Microsoft.Reporting.WinForms.ReportParameter("tx20", tx20);
p[48] = new Microsoft.Reporting.WinForms.ReportParameter("tx21", tx21);
p[49] = new Microsoft.Reporting.WinForms.ReportParameter("tx22", tx22);
p[50] = new Microsoft.Reporting.WinForms.ReportParameter("tx23", tx23);
p[51] = new Microsoft.Reporting.WinForms.ReportParameter("tx24", tx24);
p[52] = new Microsoft.Reporting.WinForms.ReportParameter("tx25", tx25);
p[53] = new Microsoft.Reporting.WinForms.ReportParameter("tx26", tx26);
p[54] = new Microsoft.Reporting.WinForms.ReportParameter("tx27", tx27);
p[55] = new Microsoft.Reporting.WinForms.ReportParameter("tx28", tx28);
p[56] = new Microsoft.Reporting.WinForms.ReportParameter("tx29", tx29);
p[57] = new Microsoft.Reporting.WinForms.ReportParameter("tx30", tx30);
p[58] = new Microsoft.Reporting.WinForms.ReportParameter("tx31", tx31);
p[59] = new Microsoft.Reporting.WinForms.ReportParameter("tx32", tx32);
p[60] = new Microsoft.Reporting.WinForms.ReportParameter("tx33", tx33);
p[61] = new Microsoft.Reporting.WinForms.ReportParameter("tx34", tx34);
p[62] = new Microsoft.Reporting.WinForms.ReportParameter("tx35", tx35);
p[63] = new Microsoft.Reporting.WinForms.ReportParameter("tx36", tx36);/*
* p[63] = new Microsoft.Reporting.WinForms.ReportParameter("tx37", tx37);
* p[64] = new Microsoft.Reporting.WinForms.ReportParameter("tx38", tx38);
* p[65] = new Microsoft.Reporting.WinForms.ReportParameter("tx39", tx39);
* p[66] = new Microsoft.Reporting.WinForms.ReportParameter("tx40", tx40);
*/
// p[1] = new Microsoft.Reporting.WinForms.ReportParameter("Email", Email);
// p[2] = new Microsoft.Reporting.WinForms.ReportParameter("Cpf", Cpf);
reportViewer1.LocalReport.SetParameters(p);
reportViewer1.LocalReport.Refresh();
reportViewer1.RefreshReport();
}
private void FrmBaoCaoDoanhThu_Load(object sender, EventArgs e)
{
double TongNhap = 0;
double TongXuat = 0;
double TongDoanhThu = 0;
LayThongTinBaoCao();
DataTable dsmh = new DataTable();
DataTable ds = new DataTable();
dsmh = bus_baocaodoanhthu.LayDanhSachMatHang(dto_baocaodoanhthu);
ds = bus_baocaodoanhthu.LayDanhSachMatHang(dto_baocaodoanhthu);
ds.Columns.Add("SLBan");
ds.Columns.Add("SLNhap");
ds.Columns.Add("GiaTriBan");
ds.Columns.Add("GiaTriNhap");
ds.Columns.Add("DoanhThu");
ds.Columns.Add("TiLe");
for (int i = 0; i < ds.Rows.Count; i++)
{
ds.Rows[i]["SLBan"] = bus_baocaodoanhthu.LaySLBan(dto_baocaodoanhthu, ds.Rows[i]["MaMH"].ToString()).Rows[0][1].ToString();
ds.Rows[i]["SLNhap"] = bus_baocaodoanhthu.LaySLNhap(dto_baocaodoanhthu, ds.Rows[i]["MaMH"].ToString()).Rows[0][1].ToString();
double GiaTriBan = bus_baocaodoanhthu.TongGiaTriBan(dto_baocaodoanhthu, ds.Rows[i]["MaMH"].ToString());
ds.Rows[i]["GiaTriBan"] = GiaTriBan;
double GiaTriNhap = bus_baocaodoanhthu.TongGiaTriNhap(dto_baocaodoanhthu, ds.Rows[i]["MaMH"].ToString());
ds.Rows[i]["GiaTriNhap"] = GiaTriNhap;
double DoanhThu = GiaTriNhap - GiaTriBan;
ds.Rows[i]["DoanhThu"] = DoanhThu; TongNhap += GiaTriNhap;
TongXuat += GiaTriBan;
TongDoanhThu += DoanhThu;
}
for (int i = 0; i < ds.Rows.Count; i++)
{
ds.Rows[i]["TiLe"] = (Double.Parse(ds.Rows[i]["DoanhThu"].ToString()) * 100 / TongDoanhThu);
}
ds.Columns.Remove("MaMH");
reportViewer1.Reset();
reportViewer1.LocalReport.ReportEmbeddedResource = "GUI_QLVLXD.BaoCaoDoanhThu.rdlc";
reportViewer1.LocalReport.DataSources.Clear();
Microsoft.Reporting.WinForms.ReportDataSource newDataSource = new Microsoft.Reporting.WinForms.ReportDataSource("BaocaoDoanhThu",ds);
newDataSource.Name = "DataSet1";
reportViewer1.LocalReport.DataSources.Add(newDataSource);
List<Microsoft.Reporting.WinForms.ReportParameter> Parameters = new List<Microsoft.Reporting.WinForms.ReportParameter>();
Microsoft.Reporting.WinForms.ReportParameter param = default(Microsoft.Reporting.WinForms.ReportParameter);
param = new Microsoft.Reporting.WinForms.ReportParameter("TuNgay", dto_baocaodoanhthu.Thang +"/"+ dto_baocaodoanhthu.Nam);
Parameters.Add(param);
param = new Microsoft.Reporting.WinForms.ReportParameter("TongNhap", TongNhap+"");
Parameters.Add(param);
param = new Microsoft.Reporting.WinForms.ReportParameter("TongBan", TongXuat+"");
Parameters.Add(param);
param = new Microsoft.Reporting.WinForms.ReportParameter("TongDoanhThu", TongDoanhThu+"");
Parameters.Add(param);
reportViewer1.LocalReport.SetParameters(Parameters);
this.reportViewer1.RefreshReport();
}
private void buttonPay_Click(object sender, EventArgs e)
{
if (Warranties != null)
{
if (this.ValidateForPrint())
{
ConfirmPayment ConfirmPayment = new ConfirmPayment();
var temp = this.Warranties;
DialogResult Result = ConfirmPayment.ShowDialog(this, ref temp);
this.Warranties = temp;
if (Result == DialogResult.OK && ConfirmPayment.IsValid == true)
{
this.IsBusy = true;
this.Warranties.CustomerName = this.textBoxCustomerName.Text;
this.Warranties.Email = this.textBoxEmail.Text;
this.Warranties.Phone = this.textBoxPhoneNumber.Text;
this.Warranties.Country = this.comboBoxCountry.Text;
this.Warranties.Address = this.textBoxAddress.Text;
bool succesCommit = false;
try
{
this.Warranties.Commit();
succesCommit = true;
}
catch (Exception ex)
{
this.Warranties.RollBack();
MessageBox.Show("Error Occurred While Committing Warranty. "
+ Environment.NewLine
+ "Please Check the Error Message." + Environment.NewLine
+ "Please take a screen shot and send to System Administrator" + Environment.NewLine + Environment.NewLine
+ ex.Message, "Error Occurred.");
succesCommit = false;
}
if (succesCommit)
{
const string ReportPath = @"LSExtendedWarrenty.WarrentySlip.rdlc";
const string DataSourceName = @"WarrentyItem";
String PrinterName = SettingsProvider.GetDefaultPrinter();
Microsoft.Reporting.WinForms.ReportParameter[] ReportParameter =
new Microsoft.Reporting.WinForms.ReportParameter[] {
new Microsoft.Reporting.WinForms.ReportParameter(@"PrintDateTime", DateTime.Now.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter(@"IssueDateTime", DateTime.Now.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter(@"CashMemo", Warranties.Reciept.RecieptID),
new Microsoft.Reporting.WinForms.ReportParameter(@"CashMemoDate", Warranties.Reciept.TransactionDate.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerName", Warranties.CustomerName),
new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerPhone", Warranties.Phone),
new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerEmail", Warranties.Email),
new Microsoft.Reporting.WinForms.ReportParameter(@"StaffCode", Warranties.Reciept.Staff),
new Microsoft.Reporting.WinForms.ReportParameter(@"StaffName", Warranties.Reciept.StaffName)
};
Warranty TempWarrenties = (Warranty)Warranties.Clone();
try
{
foreach (var warranty in Warranties)
{
TempWarrenties.Clear();
TempWarrenties.Add(warranty);
Microsoft.Reporting.WinForms.ReportDataSource DataSource = new Microsoft.Reporting.WinForms.ReportDataSource
(DataSourceName, TempWarrenties);
using (ReportPriner Printer = new ReportPriner(ReportPath, DataSource, ReportParameter))
{
Printer.Run(PrinterName);
Printer.Run(PrinterName);
}
}
this.Warranties = null;
this.Reciept = null;
}
catch (Exception ex)
{
MessageBox.Show("Problem Printing Warranty Certificate.\nPlease Try again."
+ Environment.NewLine
+ "Please Check the Error Message." + Environment.NewLine
+ "Please take a screen shot and send to System Administrator" + Environment.NewLine + Environment.NewLine
+ ex.Message
, "Cannot Print.");
this.Warranties.RollBack();
}
}
else
{
MessageBox.Show(this, "Problem saving Warranty.", "Cannot Save.", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
if (ConfirmPayment.IsValid)
{
MessageBox.Show(this, "Invalid Payment", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show(this, "Please Enter All the user Fields.", "Complete the form.", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.IsBusy = false;
}
}
private void GenerateReport()
{
try
{
int SubCompanyId = ddSubCompany.SelectedValue.ToInt();
if (chkAllSubCompany.Checked == false && SubCompanyId == 0)
{
ENUtils.ShowMessage("Required : Sub Company");
return;
}
if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753)
{
dtpFromDate.Value = null;
}
if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753)
{
dtpTillDate.Value = null;
}
DateTime?fromDate = dtpFromDate.Value.ToDateorNull();
DateTime?tillDate = dtpTillDate.Value.ToDateorNull();
if (tillDate != null)
{
tillDate = tillDate + TimeSpan.Parse("23:59:59");
}
bool ShowDetail = chkDetailReport.Checked.ToBool();
using (TaxiDataContext db = new TaxiDataContext())
{
var list = db.stp_GetBookingByCallHistory(fromDate, tillDate, SubCompanyId, ShowDetail).ToList();;
this.stp_GetBookingByCallHistoryResultBindingSource.DataSource = list;
}
if (ShowDetail)
{
this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns.rptCallHistoryBookingDetail.rdlc";
}
else
{
this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns.rptCallHistoryBookingCount.rdlc";
}
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[4];
string address = AppVars.objSubCompany.Address;
string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo;
param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Header", AppVars.objSubCompany.CompanyName.ToStr());
param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address);
param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo);
////Report_Parameter_AverageJobsPerDay
string heading = string.Empty;
if (fromDate != null && tillDate != null)
{
heading = string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate);
}
param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading);
reportViewer1.LocalReport.SetParameters(param);
this.reportViewer1.ZoomPercent = 100;
this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
this.reportViewer1.RefreshReport();
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void configureParameters()
{
String filter = this.bindingSource.Filter;
if(filter!=null)
if(filter.Equals(""))
filter=null;
if (this.reportViewer1.LocalReport.GetParameters().Count != 0)
{
Microsoft.Reporting.WinForms.ReportParameter p = new Microsoft.Reporting.WinForms.ReportParameter("filtro", filter);
this.reportViewer1.LocalReport.SetParameters(p);
find.Visible = true;
}
else
find.Visible = false;
this.reportViewer1.RefreshReport();
}
public void CargarReporte(Nullable <DateTime> Desde, Nullable <DateTime> Hasta, Boolean PorEjecutivo, Entities.Entidad Ejecutivo)
{
try
{
if (Desde.HasValue)
{
if (Hasta.HasValue)
{
System.Data.DataTable DTKPIs = null;
if (PorEjecutivo)
{
if (Ejecutivo != null)
{
DTKPIs = Client.GetGestionVentasKPIContactados(Entorno.ItemEmpresa.EMPR_Codigo, Entorno.ItemSucursal.SUCR_Codigo, Desde.Value, Hasta.Value, PorEjecutivo, Ejecutivo.ENTC_Codigo);
}
else
{
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar un Ejecutivo.");
}
}
else
{
DTKPIs = Client.GetGestionVentasKPIContactados(Entorno.ItemEmpresa.EMPR_Codigo, Entorno.ItemSucursal.SUCR_Codigo, Desde.Value, Hasta.Value, PorEjecutivo, null);
}
if (DTKPIs != null && DTKPIs.Rows.Count > 0)
{
if (!PorEjecutivo)
{
ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptKPI001Contactados.rdlc";
RepDataSource = new Microsoft.Reporting.WinForms.ReportDataSource();
RepDataSource.Name = "DTKPIs";
RepDataSource.Value = DTKPIs;
String MIN = DTKPIs.Rows[0]["KPIMIN"].ToString();
String MAX = DTKPIs.Rows[0]["KPIMAX"].ToString();
this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[2];
Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("parMIN", MIN);
Parameters[1] = new Microsoft.Reporting.WinForms.ReportParameter("parMAX", MAX);
}
else
{
ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptKPI001ContactadosEjecutivo.rdlc";
RepDataSource = new Microsoft.Reporting.WinForms.ReportDataSource();
RepDataSource.Name = "DTKPIs";
RepDataSource.Value = DTKPIs;
String MIN = DTKPIs.Rows[0]["KPIMIN"].ToString();
String MAX = DTKPIs.Rows[0]["KPIMAX"].ToString();
this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[3];
Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("parMIN", MIN);
Parameters[1] = new Microsoft.Reporting.WinForms.ReportParameter("parMAX", MAX);
Parameters[2] = new Microsoft.Reporting.WinForms.ReportParameter("parEJECUTIVO", Ejecutivo.ENTC_NomCompleto);
}
LView.ShowItems();
}
else
{
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No se encontraron resultados.");
}
}
else
{
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar la fecha Hasta.");
}
}
else
{
Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar la fecha Desde.");
}
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); }
}
public void CargarReporteCotizacion()
{
try
{
RView = new COM007RView();
RView.Presenter = this;
((COM007RView)RView).Show();
Item = Client.GetOneCab_Cotizacion_OV(Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo, Delfin.Controls.Entorno.ItemSucursal.SUCR_Codigo, ItemLView.CCOT_Numero, ItemLView.CCOT_Tipo);
System.Data.DataTable DTCotizacionFlete = new System.Data.DataTable("DTCotizacionFlete");
DTCotizacionFlete.Columns.Add("Desc", Type.GetType("System.String"));
DTCotizacionFlete.Columns.Add("Moneda", Type.GetType("System.String"));
DTCotizacionFlete.Columns.Add("Precio", Type.GetType("System.Decimal"));
foreach (Entities.Det_Cotizacion_OV_Flete _flete in Item.ItemsFlete)
{
System.Data.DataRow _newRow = DTCotizacionFlete.NewRow();
_newRow["Desc"] = _flete.PACK_Desc;
_newRow["Moneda"] = Item.TIPO_DescCMND;
_newRow["Precio"] = _flete.DCOT_PrecioUniVenta;
DTCotizacionFlete.Rows.Add(_newRow);
}
System.Data.DataTable DTCotizacionServicio = new System.Data.DataTable("DTCotizacionServicio");
DTCotizacionServicio.Columns.Add("Tipo", Type.GetType("System.String"));
DTCotizacionServicio.Columns.Add("Desc", Type.GetType("System.String"));
DTCotizacionServicio.Columns.Add("Moneda", Type.GetType("System.String"));
DTCotizacionServicio.Columns.Add("Cantidad", Type.GetType("System.Decimal"));
DTCotizacionServicio.Columns.Add("Precio", Type.GetType("System.Decimal"));
DTCotizacionServicio.Columns.Add("Valor", Type.GetType("System.Decimal"));
foreach (Entities.Det_Cotizacion_OV_Servicio _servicio in Item.ItemsServicio)
{
if (!_servicio.SCOT_Exonerado)
{
System.Data.DataRow _newRow = DTCotizacionServicio.NewRow();
_newRow["Tipo"] = _servicio.SCOT_Origen;
_newRow["Desc"] = _servicio.SERV_Nombre;
_newRow["Moneda"] = _servicio.TIPO_DescCMnd;
_newRow["Cantidad"] = _servicio.SCOT_Cantidad;
_newRow["Precio"] = _servicio.SCOT_PrecioUni;
if (_servicio.CCOT_IngresoGasto == "I")
{
_newRow["Valor"] = _servicio.SCOT_Importe_Ingreso;
}
else
{
_newRow["Valor"] = _servicio.SCOT_Importe_Egreso;
}
DTCotizacionServicio.Rows.Add(_newRow);
}
}
ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptCOM007Cotizacion.rdlc";
RepDataSourceFlete = new Microsoft.Reporting.WinForms.ReportDataSource();
RepDataSourceFlete.Name = "DTCotizacionFlete";
RepDataSourceFlete.Value = DTCotizacionFlete;
RepDataSourceService = new Microsoft.Reporting.WinForms.ReportDataSource();
RepDataSourceService.Name = "DTCotizacionServicio";
RepDataSourceService.Value = DTCotizacionServicio;
this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[19];
Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("CONS_DescVIA", Item.CONS_DescVia);
Parameters[1] = new Microsoft.Reporting.WinForms.ReportParameter("CONS_DescRGM", Item.CONS_DescRGM);
Parameters[2] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_NumDoc", Item.CCOT_NumDoc);
Parameters[3] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Version", Item.CCOT_Version.ToString());
Parameters[4] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomCliente", Item.ENTC_NomCliente);
Parameters[5] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomContacto", Item.ENTC_NomContacto);
Parameters[6] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_FecEmi", Item.CCOT_FecEmi.Value.ToString("dd/MM/yyyy"));
Parameters[7] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_FecVcto", Item.CCOT_FecVcto.Value.ToString("dd/MM/yyyy"));
Parameters[8] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_FecOferta", Item.CCOT_FecEmi.Value.AddDays(Item.CCOT_ValidezOferta).ToString("dd/MM/yyyy"));
Parameters[9] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailContacto", Item.ENTC_EmailContacto);
Parameters[10] = new Microsoft.Reporting.WinForms.ReportParameter("PUER_NombreOrigen", Item.PUER_NombreOrigen);
Parameters[11] = new Microsoft.Reporting.WinForms.ReportParameter("PUER_NombreDestino", Item.PUER_NombreDestino);
Parameters[12] = new Microsoft.Reporting.WinForms.ReportParameter("Usuario", Session.UserNombreCompleto);
Parameters[13] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomAgente", Item.ENTC_NomAgente);
Parameters[14] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailAgente", Item.ENTC_EmailAgente);
Parameters[15] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Almacenaje", Item.CCOT_Almacenaje.ToString());
Parameters[16] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Sobreestadia", Item.CCOT_SobreEstadia.ToString());
Parameters[17] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_TiempoViaje", Item.CCOT_TiempoViaje.ToString());
Parameters[18] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Observacion", Item.CCOT_Observaciones);
RView.ShowItems();
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); }
}
public void CargarReporteOrdenVentaImpo()
{
try
{
RView = new COM007RView();
RView.Presenter = this;
((COM007RView)RView).Show();
Item = Client.GetOneCab_Cotizacion_OV(Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo, Delfin.Controls.Entorno.ItemSucursal.SUCR_Codigo, ItemLView.CCOT_Numero, ItemLView.CCOT_Tipo);
ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptCOM007OrdenVentaImpo.rdlc";
//RepDataSourceFlete = new Microsoft.Reporting.WinForms.ReportDataSource();
//RepDataSourceFlete.Name = "DTOrdenVentaImpoFlete";
//RepDataSourceFlete.Value = DTOrdenVentaImpoFlete;
String _TypeQuantity = "";
foreach (var _flete in Item.ItemsFlete)
{
_TypeQuantity += (String.IsNullOrEmpty(_TypeQuantity) ? "" : ", ") + String.Format("{0}X{1}", _flete.DCOT_Cantidad.ToString("#0"), _flete.PACK_DescC);
}
Decimal _Weight = Item.ItemsFlete.Sum(flet => flet.DCOT_Peso.HasValue ? flet.DCOT_Peso.Value : (Decimal)0.00);
Decimal _Volume = Item.ItemsFlete.Sum(flet => flet.DCOT_Volumen.HasValue ? flet.DCOT_Volumen.Value : (Decimal)0.00);
Decimal _Pieces = Item.ItemsFlete.Sum(flet => flet.DCOT_Cantidad);
this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[38];
CultureInfo _culture = new CultureInfo("en-US");
Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_FecEmi", Item.CCOT_FecEmi.Value.ToString("D", _culture));
Parameters[1] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_NumDoc", String.IsNullOrEmpty(Item.CCOT_NumDoc) ? "" : Item.CCOT_NumDoc);
Parameters[2] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomAgente", String.IsNullOrEmpty(Item.ENTC_NomAgente) ? "" : Item.ENTC_NomAgente);
Parameters[3] = new Microsoft.Reporting.WinForms.ReportParameter("DOOV_CodReferencia", String.IsNullOrEmpty(Item.DOOV_CodReferencia) ? "" : Item.DOOV_CodReferencia);
Parameters[4] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomShipper", String.IsNullOrEmpty(Item.ENTC_NomShipper) ? "" : Item.ENTC_NomShipper);
Parameters[5] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_DirShipper", String.IsNullOrEmpty(Item.ENTC_DirShipper) ? "" : Item.ENTC_DirShipper);
Parameters[6] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailShipper", String.IsNullOrEmpty(Item.ENTC_EmailShipper) ? "" : Item.ENTC_EmailShipper);
Parameters[7] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel1Shipper", String.IsNullOrEmpty(Item.ENTC_Tel1Shipper) ? "" : Item.ENTC_Tel1Shipper);
Parameters[8] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel2Shipper", String.IsNullOrEmpty(Item.ENTC_Tel2Shipper) ? "" : Item.ENTC_Tel2Shipper);
Parameters[9] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_ContactShipper", String.IsNullOrEmpty(Item.ENTC_ContactShipper) ? "" : Item.ENTC_ContactShipper);
Parameters[10] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomConsignee", String.IsNullOrEmpty(Item.ENTC_NomConsignee) ? "" : Item.ENTC_NomConsignee);
Parameters[11] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_DirConsignee", String.IsNullOrEmpty(Item.ENTC_DirConsignee) ? "" : Item.ENTC_DirConsignee);
Parameters[12] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailConsignee", String.IsNullOrEmpty(Item.ENTC_EmailConsignee) ? "" : Item.ENTC_EmailConsignee);
Parameters[13] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel1Consignee", String.IsNullOrEmpty(Item.ENTC_Tel1Consignee) ? "" : Item.ENTC_Tel1Consignee);
Parameters[14] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel2Consignee", String.IsNullOrEmpty(Item.ENTC_Tel2Consignee) ? "" : Item.ENTC_Tel2Consignee);
Parameters[15] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_ContactConsignee", String.IsNullOrEmpty(Item.ENTC_ContactConsignee) ? "" : Item.ENTC_ContactConsignee);
Parameters[16] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomAgente2", String.IsNullOrEmpty(Item.ENTC_NomAgente) ? "" : Item.ENTC_NomAgente);
Parameters[17] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_DirAgente", String.IsNullOrEmpty(Item.ENTC_DirAgente) ? "" : Item.ENTC_DirAgente);
Parameters[18] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_EmailAgente", String.IsNullOrEmpty(Item.ENTC_EmailAgente) ? "" : Item.ENTC_EmailAgente);
Parameters[19] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel1Agente", String.IsNullOrEmpty(Item.ENTC_Tel1Agente) ? "" : Item.ENTC_Tel1Agente);
Parameters[20] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_Tel2Agente", String.IsNullOrEmpty(Item.ENTC_Tel2Agente) ? "" : Item.ENTC_Tel2Agente);
Parameters[21] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_ContactAgente", String.IsNullOrEmpty(Item.ENTC_ContactAgente) ? "" : Item.ENTC_ContactAgente);
Parameters[22] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomTransportista", String.IsNullOrEmpty(Item.ENTC_NomTransportista) ? "" : Item.ENTC_NomTransportista);
Parameters[23] = new Microsoft.Reporting.WinForms.ReportParameter("CONT_Numero", String.IsNullOrEmpty(Item.CONT_Numero) ? "" : Item.CONT_Numero);
Parameters[24] = new Microsoft.Reporting.WinForms.ReportParameter("TIPO_DescMND", String.IsNullOrEmpty(Item.TIPO_DescCMND) ? "" : Item.TIPO_DescCMND);
Parameters[25] = new Microsoft.Reporting.WinForms.ReportParameter("PACK_DescC", String.IsNullOrEmpty(Item.PACK_DescC) ? "" : Item.PACK_DescC);
Parameters[26] = new Microsoft.Reporting.WinForms.ReportParameter("DCOT_Cantidad", Item.DCOT_Cantidad.HasValue ? Convert.ToInt32(Item.DCOT_Cantidad.Value).ToString() : "");
Parameters[27] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_PagoMBL", String.IsNullOrEmpty(Item.CCOT_PagoMBL) ? "" : Item.CCOT_PagoMBL == "C" ? "COLLECT" : "PREPAID");
Parameters[28] = new Microsoft.Reporting.WinForms.ReportParameter("PUER_NombreOrigen", String.IsNullOrEmpty(Item.PUER_NombreOrigen) ? "" : Item.PUER_NombreOrigen);
Parameters[29] = new Microsoft.Reporting.WinForms.ReportParameter("PUER_NombreDestino", String.IsNullOrEmpty(Item.PUER_NombreDestino) ? "" : Item.PUER_NombreDestino);
Parameters[30] = new Microsoft.Reporting.WinForms.ReportParameter("TIPO_DescCDT", String.IsNullOrEmpty(Item.TIPO_DescCDT) ? "" : Item.TIPO_DescCDT);
Parameters[31] = new Microsoft.Reporting.WinForms.ReportParameter("DCOT_Peso", _Weight.ToString("0,0.00") + " TN");
Parameters[32] = new Microsoft.Reporting.WinForms.ReportParameter("DCOT_Volumen", _Volume.ToString("0,0.00") + " M3");
Parameters[33] = new Microsoft.Reporting.WinForms.ReportParameter("DCOT_Bultos", _Pieces.ToString("0,0.00"));
Parameters[34] = new Microsoft.Reporting.WinForms.ReportParameter("CCOT_Observaciones", String.IsNullOrEmpty(Item.CCOT_Observaciones) ? "" : Item.CCOT_Observaciones);
Parameters[35] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomEjecutivo", String.IsNullOrEmpty(Item.ENTC_NomEjecutivo) ? "" : Item.ENTC_NomEjecutivo);
Parameters[36] = new Microsoft.Reporting.WinForms.ReportParameter("ENTC_NomCustomer", String.IsNullOrEmpty(Item.ENTC_NomCustomer) ? "" : Item.ENTC_NomCustomer);
Parameters[37] = new Microsoft.Reporting.WinForms.ReportParameter("DOCT_TypeQuantity", _TypeQuantity);
RView.ShowItems();
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); }
}
void btnExportExcel_Click(object sender, EventArgs e)
{
if (grdLister.Rows.Count == 0)
{
return;
}
try
{
saveFileDialog1.Filter = "Excel File (*.xls)|*.xls|AdvExcel File (*.xlsx)|*.xlsx";
saveFileDialog1.Title = "Save File";
saveFileDialog1.FileName = "Driver Collection History";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
grdLister.Columns["IsPaid"].IsVisible = false;
grdLister.Columns["Paid"].IsVisible = true;
//grdLister.Columns["btnUpdate"].IsVisible = false;
grdLister.Columns[COLS.Active].HeaderText = "Active";
grdLister.Columns[COLS.Active].Width = 30;
grdLister.Columns[COLS.Rent].Width = 60;
grdLister.Columns[COLS.DriverNo].Width = 35;
grdLister.Columns[COLS.PreviousBalance].Width = 85;
grdLister.Columns[COLS.Adjustment].Width = 60;
grdLister.Columns[COLS.Collection].Width = 50;
grdLister.Columns[COLS.OldCollection].Width = 70;
grdLister.Columns[COLS.AgentCommission].Width = 60;
grdLister.Columns[COLS.OldAgentBalance].Width = 90;
grdLister.Columns[COLS.Total].Width = 45;
grdLister.Columns[COLS.Paid].Width = 35;
var row = grdLister.Rows.OrderByDescending(c => c.Cells["ToDate"].Value.ToDate()).FirstOrDefault();
DateTime?dtCurrent = row.Cells["FromDate"].Value.ToDate();
DateTime dtEnd = row.Cells["ToDate"].Value.ToDate();
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[1];
string heading = string.Empty;
heading = "Driver Collection History - " + string.Format("from {0:dd/MM/yyyy}", dtCurrent) + " until " + string.Format("{0:dd/MM/yyyy}", dtEnd);
ClsExportGridView obj = new ClsExportGridView(grdLister, saveFileDialog1.FileName);
obj.ApplyCellFormatting = true;
obj.ConditionalFormattingObject = new StyleDataRowConditionalFormattingObject();
obj.ConditionalFormattingObject.ConditionFormattingColumnName = "Paid";
obj.ConditionalFormattingObject.RowBackColor = Color.LightGreen;
obj.ConditionalFormattingObject.RowForeColor = Color.Black;
obj.ConditionalFormattingObject.TValue = "Paid";
obj.Heading = heading;
if (obj.ExportExcel())
{
RadDesktopAlert alert = new RadDesktopAlert();
alert.CaptionText = "Export";
alert.ContentText = "<html> <b><span style=font-size:medium><color=Blue>Export Successfully</span></b></html>";
alert.Show();
}
//grdLister.Columns["IsPaid"].IsVisible = true;
//grdLister.Columns["Paid"].IsVisible = false;
grdLister.Columns["IsPaid"].IsVisible = false;
grdLister.Columns["Paid"].IsVisible = true;
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
finally
{
SetDefaultColumnSettings();
}
//rptfrmDriverPaymentCollection frm = new rptfrmDriverPaymentCollection();
//frm.LoadReport();
//frm.ExportReportToExcel("excel");
}
void loadParam()
{
string text = "";
Sales_BM sale = new Sales_BM();
sale.sales_id = sales_id;
sale = sale.getSalesByID(connString2);
if (sale.credit > 0)
{
text = "Credit";
}
else
{
text = "Balance";
}
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("ReportParamSales", sales_id.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("paramCustName", name.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("paramAddress", addrs.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("paramTotal", sale.total.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("paramPayment", sale.paid.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("ReportParamBalance", sale.credit.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("paramBC", text),
new Microsoft.Reporting.WinForms.ReportParameter("paramDate", sale.date_time.ToString("dd-MMM-yyyy"))
};
reportViewer1.LocalReport.SetParameters(param);
BusinessObjects.Print print = new Print();
// string connString2 = @"Data Source=SURESH\SQLEXPRESS;Initial Catalog=FutureSoft;Integrated Security=True";
print = print.GetP(connString2);
PrintDialog printDialog = new PrintDialog();
PrintDocument printDocument = new PrintDocument();
printDialog.Document = printDocument;
//printDocument.PrintPage +=new PrintPageEventHandler(printDocument_PrintPage);
printDocument.PrinterSettings.PrinterName = print.PrinterName;
printDocument.DefaultPageSettings.PaperSize = printDocument.PrinterSettings.PaperSizes[print.PaperSize];
printDocument.DefaultPageSettings.PaperSource = printDocument.PrinterSettings.PaperSources[print.Source];
printDocument.DefaultPageSettings.PrinterResolution = printDocument.PrinterSettings.PrinterResolutions[print.Resolution];
printDocument.DefaultPageSettings.Margins.Left = 4;
printDocument.DefaultPageSettings.Margins.Right = 4;
printDocument.DefaultPageSettings.Margins.Top = 5;
printDocument.DefaultPageSettings.Margins.Bottom = 8;
printDocument.DocumentName = "Vista_Receipt";
printDocument.DefaultPageSettings.PrinterSettings.MaximumPage = 1;
printDocument.DefaultPageSettings.PrinterSettings.Duplex = Duplex.Vertical;
reportViewer1.SetPageSettings(printDocument.DefaultPageSettings);
// printDocument.PrintPage += printDocument_PrintPage2;
//printDocument.Print();
}
private void Form9_Load(object sender, EventArgs e)
{
try
{
string serv = "localhost", database = "namefield", uid = "root", pasw = "121417181";
string constring;
constring = "SERVER=" + serv + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";";
MySqlConnection connection = new MySqlConnection(constring);
connection.Open();
string query = "select usrid from vehdet where vhno='" + vhno + "';";
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute a SQL command to read ,which uses class "MySqlDataReader" as a command for ExecuteReader using cmd
MySqlDataReader read = cmd.ExecuteReader();
if (!read.HasRows)
{
MessageBox.Show("vehicle not found");
}
else
{
while (read.Read())
{//while the data doesnt become empty
usid = read.GetInt32("usrid");
}
read.Close();
cmd.CommandText = "select count(usrid) as cnt from bill where usrid=" + usid + ";";
read = cmd.ExecuteReader();
while (read.Read())//while the data doesnt become empty
{
if (read.GetInt32("cnt") == 1)
{
fbil = 0;
}
else
{
fbil = 1;
}
}
read.Close();
cmd.CommandText = "select * from owndet,fines,bill where owndet.usrid=" + usid + " order by billno desc limit 1;";
read = cmd.ExecuteReader();
if (!read.HasRows)
{
MessageBox.Show("details not found");
}
while (read.Read()) //while the data doesnt become empty
{ //Bill date,no,name etc inga label la setting pandrom
name = read.GetString("name");
billno = read.GetInt32("billno").ToString();
date = read.GetDateTime("date").ToString();
total = read.GetInt32("total").ToString();
paid = read.GetInt32("paid").ToString();
balance = (read.GetInt32("total") - read.GetInt32("paid")).ToString();
Microsoft.Reporting.WinForms.ReportParameter[] para = new Microsoft.Reporting.WinForms.ReportParameter[] {
new Microsoft.Reporting.WinForms.ReportParameter("Name", name),
new Microsoft.Reporting.WinForms.ReportParameter("Date", date),
new Microsoft.Reporting.WinForms.ReportParameter("Billno", billno),
new Microsoft.Reporting.WinForms.ReportParameter("vehino", vhno),
new Microsoft.Reporting.WinForms.ReportParameter("Total", total),
new Microsoft.Reporting.WinForms.ReportParameter("Paid", paid),
new Microsoft.Reporting.WinForms.ReportParameter("Balance", balance),
};
reportViewer1.LocalReport.SetParameters(para);
if (fbil == 1)
{
if ((read.GetInt32("total") - read.GetInt32("paid")) != 0)
{
list.Add(new Fine()
{
Slno = slno, Offense = "Arrears", TotalAmt = (read.GetInt32("total") - read.GetInt32("paid")).ToString()
});
slno++;
}
}
else
{
if (read.GetInt32("ot") > 0)//Overtake paniruntha,ithu run aagum
{
list.Add(new Fine()
{
Slno = slno, Offense = "OverTake", Times = read.GetInt32("ot"), FineAmt = 300, TotalAmt = (read.GetInt32("ot") * 300).ToString()
});
slno++;
}
if (read.GetInt32("dd") > 0)//Drink and drive paniruntha
{
list.Add(new Fine()
{
Slno = slno, Offense = "Drink and Drive", Times = read.GetInt32("dd"), FineAmt = 500, TotalAmt = (read.GetInt32("dd") * 500).ToString()
});
slno++;
}
if (read.GetInt32("ht") > 0)
{
list.Add(new Fine()
{
Slno = slno, Offense = "Helmet", Times = read.GetInt32("ht"), FineAmt = 100, TotalAmt = (read.GetInt32("ht") * 100).ToString()
});
slno++;
}
if (read.GetInt32("ow") > 0)
{
list.Add(new Fine()
{
Slno = slno, Offense = "One Way", Times = read.GetInt32("ow"), FineAmt = 200, TotalAmt = (read.GetInt32("ow") * 200).ToString()
});
slno++;
}
}
}
}
FineBindingSource.DataSource = list;
this.reportViewer1.RefreshReport();
}
catch (MySqlException ex)
{
MessageBox.Show("The error occured is" + ex);
this.Close();
}
}
private void SwitchIndex()
{
switch (index)
{
case 1:
this.reportViewer1.LocalReport.ReportPath = "C:\\Users\\Hadenos_EZ\\source\\repos\\ProjetHameau\\ProjetHameau\\Vue\\LISTE_EMARGEMENT1.rdlc";
Microsoft.Reporting.WinForms.ReportParameter[] p1 = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("Nom0", LP[0].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom1", LP[1].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom2", LP[2].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom3", LP[3].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom4", LP[4].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom5", LP[5].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom6", LP[6].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom7", LP[7].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom8", LP[8].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom9", LP[9].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom10", LP[10].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom11", LP[11].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom12", LP[12].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom13", LP[13].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom14", LP[14].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom15", LP[15].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom16", LP[16].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom17", LP[17].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom18", LP[18].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom19", LP[19].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom20", LP[20].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom21", LP[21].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom22", LP[22].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom23", LP[23].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom24", LP[24].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom25", LP[25].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom26", LP[26].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom27", LP[27].NOM_PRO),
};
this.reportViewer1.LocalReport.SetParameters(p1);
this.reportViewer1.RefreshReport();
break;
case 2:
this.reportViewer1.LocalReport.ReportPath = "C:\\Users\\Hadenos_EZ\\source\\repos\\ProjetHameau\\ProjetHameau\\Vue\\LISTE_EMARGEMENT2.rdlc";
Microsoft.Reporting.WinForms.ReportParameter[] p2 = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("Nom28", LP[28].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom29", LP[29].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom30", LP[30].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom31", LP[31].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom32", LP[32].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom33", LP[33].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom34", LP[34].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom35", LP[35].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom36", LP[36].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom37", LP[37].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom38", LP[38].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom39", LP[39].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom40", LP[40].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom41", LP[41].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom42", LP[42].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom43", LP[43].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom44", LP[44].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom45", LP[45].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom46", LP[46].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom47", LP[47].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom48", LP[48].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom49", LP[49].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom50", LP[50].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom51", LP[51].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom52", LP[52].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom53", LP[53].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom54", LP[54].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom55", LP[55].NOM_PRO),
};
this.reportViewer1.LocalReport.SetParameters(p2);
this.reportViewer1.RefreshReport();
break;
case 3:
this.reportViewer1.LocalReport.ReportPath = "C:\\Users\\Hadenos_EZ\\source\\repos\\ProjetHameau\\ProjetHameau\\Vue\\LISTE_EMARGEMENT3.rdlc";
Microsoft.Reporting.WinForms.ReportParameter[] p3 = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("Nom56", LP[56].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom57", LP[57].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom58", LP[58].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom59", LP[59].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom60", LP[60].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom61", LP[61].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom62", LP[62].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom63", LP[63].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom64", LP[64].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom65", LP[65].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom66", LP[66].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom67", LP[67].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom68", LP[68].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom69", LP[69].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom70", LP[70].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom71", LP[71].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom72", LP[72].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom73", LP[73].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom74", LP[74].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom75", LP[75].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom76", LP[76].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom77", LP[77].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom78", LP[78].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom79", LP[79].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom80", LP[80].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom81", LP[81].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom82", LP[82].NOM_PRO),
new Microsoft.Reporting.WinForms.ReportParameter("Nom83", LP[83].NOM_PRO),
};
this.reportViewer1.LocalReport.SetParameters(p3);
this.reportViewer1.RefreshReport();
break;
}
}
private void GenerateReportLoad()
{
try
{
var today = DateTime.Today;
var month = new DateTime(today.Year, today.Month, 1);
var first = month.AddMonths(-2);
var last = month.AddDays(-2);
if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753)
{
dtpFromDate.Value = null;
}
if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753)
{
dtpTillDate.Value = null;
}
DateTime?fromDate = dtpFromDate.Value.ToDateorNull();
DateTime?tillDate = dtpTillDate.Value.ToDateorNull();
var list = General.GetQueryable <Fleet_Driver>(c => c.Id == DriverId).ToList();
string Driver = list.FirstOrDefault().DriverNo + " - " + list.FirstOrDefault().DriverName;
using (TaxiDataContext db = new TaxiDataContext())
{
this.stp_DriverRatingResultBindingSource.DataSource = db.stp_DriverRating(first.ToDateTime(), DateTime.Today, DriverId).ToList().OrderByDescending(c => c.UpdatedOn);
}
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[5];
string address = AppVars.objSubCompany.Address;
string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo;
param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Header", AppVars.objSubCompany.CompanyName.ToStr());
param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address);
param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo);
string heading = string.Empty;
if (fromDate != null && tillDate != null)
{
heading = string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate);
}
param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading);
param[4] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Driver", Driver);
reportViewer1.LocalReport.SetParameters(param);
this.reportViewer1.ZoomPercent = 100;
this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
this.reportViewer1.RefreshReport();
}
catch (Exception ex)
{
}
}
private void GenerateReport()
{
try
{
bool isMissed = optMissedCalls.Checked;
if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753)
{
dtpFromDate.Value = null;
}
if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753)
{
dtpTillDate.Value = null;
}
DateTime?fromDate = dtpFromDate.Value.ToDateorNull();
DateTime?tillDate = dtpTillDate.Value.ToDateorNull();
string phone = txtPhone.Text.Trim();
string name = txtName.Text.Trim().ToLower();
string Line = txtLine.Text.ToStr();
string Stn = txtStn.Text.ToStr();
var list = (from a in GeneralBLL.GetQueryable <CallHistory>(null)
where (fromDate == null || a.CallDateTime.Value.Date >= fromDate) &&
(tillDate == null || a.CallDateTime.Value.Date <= tillDate) &&
(name == string.Empty || a.Name.Trim().ToLower().StartsWith(name)) &&
(phone == string.Empty || a.PhoneNumber.Trim() == phone) &&
(Line == string.Empty || a.Line == Line) &&
(Stn == string.Empty || a.STN == Stn) &&
(isMissed == false || (a.IsAccepted != null && a.IsAccepted == true))
orderby a.CallDateTime descending
select new
{
Name = a.Name,
PhoneNumber = a.PhoneNumber,
CallDateTime = a.CallDateTime,
Line = a.Line,
STN = a.STN
}).ToList();
CallHistoryBindingSource.DataSource = list;
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[6];
string address = AppVars.objSubCompany.Address;
string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo;
param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Header", AppVars.objSubCompany.CompanyName.ToStr());
param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address);
param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo);
string heading = string.Empty;
if (fromDate != null && tillDate != null)
{
heading = string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate);
}
param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading);
param[4] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_TotalCalls", list.Count.ToStr());
CallerIdType_Configuration obj = General.GetObject <CallerIdType_Configuration>(c => c.Id != null);
string DigitalCLIType = obj.DigitalCLIType.ToStr();
param[5] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_DigitalCLIType", DigitalCLIType == "" ? "0" : DigitalCLIType);
reportViewer1.LocalReport.SetParameters(param);
this.reportViewer1.ZoomPercent = 100;
this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
this.reportViewer1.RefreshReport();
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
public void LoadReport()
{
try
{
this.reportViewer1.LocalReport.EnableExternalImages = true;
TimeSpan tillTime = TimeSpan.Zero;
TimeSpan.TryParse("23:59:59", out tillTime);
DateTime?dtFromDate = dtpFromDate.Value.ToDate();
DateTime?dtTillDate = dtpTillDate.Value.ToDate() + tillTime;
if (dtFromDate > dtTillDate)
{
ENUtils.ShowMessage("From Date can't greater then Till Date");
return;
}
this.stp_OperatorPerformanceResultBindingSource.DataSource = GetData(dtFromDate, dtTillDate).ToList();
//select new stp_OperatorPerformanceResult
//{
// Id = a.Id,
// CLICalls = a.CLICalls,
// CLICleared = a.CLICleared,
// JobsBooked = a.JobsBooked,
// JobsCancelled = a.JobsCancelled,
// JobsCompletetd = a.JobsCompletetd,
// LateDespatch = a.LateDespatch,
// LoggedIn = a.LoggedIn,
// MailSent = a.MailSent,
// UserName = a.UserName
//}).ToList();
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[2];
// string address = AppVars.objSubCompany.Address;
// string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo;
string heading = string.Empty;
//if (dtFrom != null && dtTill != null)
//{
heading = "Operator Performance for period " + string.Format("{0:dd/MM/yy}", dtpFromDate.Value) + " to " + string.Format("{0:dd/MM/yy}", dtpTillDate.Value);
// }
string PrintedOn = string.Empty;
PrintedOn = "Printed on " + string.Format("{0:dd/MM/yy}", DateTime.Now) + " at " + string.Format("{0:HH:mm}", DateTime.Now);
//Printed on 22/04/2016 at 16:40
param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Period", heading);
param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_PrintedOn", PrintedOn);
//List<ClsLogo> objLogo = new List<ClsLogo>();
//objLogo.Add(new ClsLogo { ImageInBytes = AppVars.objSubCompany.CompanyLogo != null ? AppVars.objSubCompany.CompanyLogo.ToArray() : null });
//ReportDataSource imageDataSource = new ReportDataSource("Taxi_AppMain_Classes_ClsLogo", objLogo);
//this.reportViewer1.LocalReport.DataSources.Add(imageDataSource);
reportViewer1.LocalReport.SetParameters(param);
this.reportViewer1.ZoomPercent = 100;
this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
this.reportViewer1.RefreshReport();
IsReportLoaded = true;
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void buttonPrint_Click(object sender, EventArgs e)
{
int Selection = this.dataGridViewJournel.CurrentCell.RowIndex;
Warranties = DataProvider.GetWarrenties(0, 10, null,
this.dataGridViewJournel.CurrentRow.Cells["WarrentyNumber"].Value.ToString(),
null, null, null);
Warranty TempWarrenties = (Warranty)Warranties.Clone();
var errorMessage = this.dataGridViewJournel.CurrentRow.Cells["ErrorMessage"].Value.ToString();
if (errorMessage.Length > 0)
{
DialogResult result =
MessageBox.Show(this, "Warranty Slip Has Errors."
+ Environment.NewLine + errorMessage +
Environment.NewLine +
"Still Need the Warranty Slip.", "Cannot Generate",
MessageBoxButtons.YesNoCancel);
if (result == DialogResult.Yes)
{
result = new Authorize().ShowDialog(this);
}
if (result != DialogResult.Yes)
{
return;
}
}
#region PrintExtended
TempWarrenties.Clear();
TempWarrenties.Add(Warranties[0]);
TempWarrenties.Reciept = Warranties[0].Reciept;
const string ReportPath = @"LSExtendedWarrenty.WarrentySlip.rdlc";
const string DataSourceName = @"WarrentyItem";
String PrinterName = SettingsProvider.GetDefaultPrinter();
try
{
Microsoft.Reporting.WinForms.ReportParameter[] ReportParameter =
new Microsoft.Reporting.WinForms.ReportParameter[] {
new Microsoft.Reporting.WinForms.ReportParameter(@"PrintDateTime", DateTime.Now.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter(@"IssueDateTime", TempWarrenties[0].IssuedDate.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter(@"CashMemo", TempWarrenties[0].Reciept.RecieptID),
new Microsoft.Reporting.WinForms.ReportParameter(@"CashMemoDate", TempWarrenties[0].Reciept.TransactionDate.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerName", TempWarrenties[0].CustomerName),
new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerPhone", TempWarrenties[0].Phone),
new Microsoft.Reporting.WinForms.ReportParameter(@"CustomerEmail", TempWarrenties[0].Email),
new Microsoft.Reporting.WinForms.ReportParameter(@"StaffCode", TempWarrenties[0].Reciept.Staff),
new Microsoft.Reporting.WinForms.ReportParameter(@"StaffName", TempWarrenties[0].Reciept.StaffName)
};
Microsoft.Reporting.WinForms.ReportDataSource DataSource = new Microsoft.Reporting.WinForms.ReportDataSource
(DataSourceName, TempWarrenties);
using (ReportPriner Printer = new ReportPriner(ReportPath, DataSource, ReportParameter))
{
this.Hide();
this.Cursor = Cursors.WaitCursor;
FormReciept window = new FormReciept();
window.Report = Printer.LocalReport;
window.ReportParameter = ReportParameter;
window.DataSource = DataSource;
this.Cursor = Cursors.Default;
window.ShowDialog(this);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Error Processing the Warranty Slip. "
+ Environment.NewLine
+ "Please Check the Error Message." + Environment.NewLine
+ "Please take a screen shot and send to System Administrator" + Environment.NewLine + Environment.NewLine
+ ex.Message, "Error Occurred");
}
#endregion
}
private void InitReportByUrl(string strRpUrl)
{
if (strRpUrl == string.Empty)
{
return;
}
int intS = strRpUrl.IndexOf("?/") + 2;
int intE = strRpUrl.IndexOf("&");
if (intS == 1)
{
intS = strRpUrl.ToUpper().IndexOf("ReportServer".ToUpper()) + 12;
}
if (intS == 11)
{
intS = 0;
}
if (intE == -1)
{
intE = strRpUrl.Length;
}
string strRpPath = strRpUrl.Substring(intS, intE - intS);
_strReportPath = strRpPath.StartsWith("/") ? strRpPath : "/" + strRpPath;
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
this.reportViewer1.ServerReport.DisplayName = _strWinTitle;
this.reportViewer1.ServerReport.ReportServerUrl = new Uri(this.frmReportServicesPath); // (System.Configuration.ConfigurationManager.AppSettings["ReportServices"]);//"http://172.20.28.17/ReportServer"
this.reportViewer1.ServerReport.ReportPath = _strReportPath; // "/fdcf/fVslApTruckChargeSheet";
//string strUser = ConfigurationManager.AppSettings["MyReportViewerUser"];
//string strPsw = ConfigurationManager.AppSettings["MyReportViewerPassword"];
//string domain = ConfigurationManager.AppSettings["MyReportViewerDomain"];
//reportViewer1.ServerReport.ReportServerCredentials.SetFormsCredentials(null, strUser, strPsw, domain);
Microsoft.Reporting.WinForms.ReportParameterInfoCollection RParameter = this.reportViewer1.ServerReport.GetParameters();
for (int r = 0; r < RParameter.Count; r++)
{
try
{
if (RParameter[r].Name == "strUser")
{
this.AddRpParameterItem(RParameter[r].Name, CApplication.App.CurrentSession.UserId.ToString());
}
else if (RParameter[r].Name == "strDept")
{
this.AddRpParameterItem(RParameter[r].Name, CApplication.App.CurrentSession.DeptId.ToString());
}
else if (RParameter[r].Name == "strFy")
{
this.AddRpParameterItem(RParameter[r].Name, CApplication.App.CurrentSession.FyId.ToString());
}
else
{
string PRtemValue = StaticFunctions.GetFrmParamValue(strRpUrl, RParameter[r].Name, new char[] { '&' });
if (PRtemValue != string.Empty)
{
this.AddRpParameterItem(RParameter[r].Name, PRtemValue);
}
}
}
catch
{
}
}
if (dtRpara != null && dtRpara.Rows.Count > 0)
{
RParameters = new Microsoft.Reporting.WinForms.ReportParameter[dtRpara.Rows.Count];
for (int i = 0; i < dtRpara.Rows.Count; i++)
{
RParameters[i] = new Microsoft.Reporting.WinForms.ReportParameter();
Microsoft.Reporting.WinForms.ReportParameter RParameterItem = new Microsoft.Reporting.WinForms.ReportParameter();
RParameterItem.Name = dtRpara.Rows[i]["RP_KEY"].ToString();
RParameterItem.Values.Add(dtRpara.Rows[i]["RP_VAL"].ToString());
RParameters[i] = RParameterItem;
}
this.reportViewer1.ServerReport.SetParameters(RParameters);
}
this.reportViewer1.ShowParameterPrompts = true;
this.reportViewer1.RefreshReport();
}
private void frmPrint_Load(object sender, EventArgs e)
{
if (_bit == 1)
{
// ManageReceipt MR = new ManageReceipt();
DataTable ManageReceipt = new DataTable();
ReceiptBindingSource.DataSource = _list;
foreach (var ReceiptRecord in _list)
{
var Quantity = ReceiptRecord.QTY;
var ProductID = ReceiptRecord.BARCODE_ID;
int Quantities = Quantity;
string id = ProductID;
string TOTAL = Convert.ToString(ReceiptRecord.TOTAL);
string UNIT_TOTAL = Convert.ToString(ReceiptRecord.UNIT_PRICE);
SaveInvoiceData(id, Quantities, TOTAL, _billNo, _date, _time, UNIT_TOTAL, ReceiptRecord.PRODUCT_NAME, _cash, _change, _operator);
UpdateStockQuantityProducts(id, Quantities);
}
Microsoft.Reporting.WinForms.ReportParameter[] para = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("pTotal", _total),
new Microsoft.Reporting.WinForms.ReportParameter("pCash", _cash),
new Microsoft.Reporting.WinForms.ReportParameter("pChange", _change),
new Microsoft.Reporting.WinForms.ReportParameter("pDate", _date),
new Microsoft.Reporting.WinForms.ReportParameter("pBill", Convert.ToString(_billNo)),
new Microsoft.Reporting.WinForms.ReportParameter("pOperator", _operator),
new Microsoft.Reporting.WinForms.ReportParameter("pTime", _time),
};
this.reportViewer1.LocalReport.SetParameters(para);
this.reportViewer1.RefreshReport();
string savePath = @"D:\Invoice Generate\" + _billNo + ".PDF";
byte[] Bytes = reportViewer1.LocalReport.Render(format: "PDF", deviceInfo: "");
using (FileStream stream = new FileStream(savePath, FileMode.Create))
{
stream.Write(Bytes, 0, Bytes.Length);
}
}
else
{
DataTable ManageReceipt = new DataTable();
ReceiptBindingSource.DataSource = _list;
foreach (var ReceiptRecord in _list)
{
var Quantity = ReceiptRecord.QTY;
var ProductID = ReceiptRecord.BARCODE_ID;
int Quantities = Quantity;
string id = ProductID;
string TOTAL = Convert.ToString(ReceiptRecord.TOTAL);
string UNIT_TOTAL = Convert.ToString(ReceiptRecord.UNIT_PRICE);
Microsoft.Reporting.WinForms.ReportParameter[] para = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("pTotal", _total),
new Microsoft.Reporting.WinForms.ReportParameter("pCash", _cash),
new Microsoft.Reporting.WinForms.ReportParameter("pChange", _change),
new Microsoft.Reporting.WinForms.ReportParameter("pDate", _date),
new Microsoft.Reporting.WinForms.ReportParameter("pBill", Convert.ToString(_billNo)),
new Microsoft.Reporting.WinForms.ReportParameter("pOperator", _operator),
new Microsoft.Reporting.WinForms.ReportParameter("pTime", _time),
};
this.reportViewer1.LocalReport.SetParameters(para);
this.reportViewer1.RefreshReport();
string savePath = @"D:\Invoice Returns\" + _billNo + ".PDF";
byte[] Bytes = reportViewer1.LocalReport.Render(format: "PDF", deviceInfo: "");
//string savePath = @"D:\Invoice Returns\" + _billNo + ".Image";
//byte[] Bytes = reportViewer1.LocalReport.Render(format: "Image", deviceInfo: "");
using (FileStream stream = new FileStream(savePath, FileMode.Create))
{
stream.Write(Bytes, 0, Bytes.Length);
}
}
}
}
//ReportGeneralPrint_Load
private void ReportGeneralPrint_Load(object sender, EventArgs e)
{
try
{
//set location for form
this.Location = new Point(point_x, point_y);
DataTable dt_tb_order = new DataTable();
dt_tb_order = bus_tb_order.GetOrderPrint(StaticClass.GeneralClass.condition_report_order);
DataTable dt_tb_cloned = dt_tb_order.Clone();
dt_tb_cloned.Columns["DiscountType"].DataType = typeof(string);
dt_tb_cloned.Columns["Discount"].DataType = typeof(string);
dt_tb_cloned.Columns["TotalDiscount"].DataType = typeof(string);
dt_tb_cloned.Columns["TotalTax"].DataType = typeof(string);
dt_tb_cloned.Columns["TotalAmount"].DataType = typeof(string);
foreach (DataRow row in dt_tb_order.Rows)
{
dt_tb_cloned.ImportRow(row);
}
foreach (DataRow row in dt_tb_cloned.Rows)
{
_orderDate = string.Format(@"{0:" + StaticClass.GeneralClass.dateFromatSettings[StaticClass.GeneralClass.app_settings["dateFormat"]].ToString() + _orderTime + "}", Convert.ToDateTime(row["OrderDate"].ToString()));
if (row["DiscountType"].ToString() == "1")
{
row["DiscountType"] = "%";
}
else
{
row["DiscountType"] = StaticClass.GeneralClass.currency_setting_general;
}
row["Discount"] = StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Discount"].ToString()));
row["TotalDiscount"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(string.IsNullOrEmpty(row["TotalDiscount"].ToString()) ? "0" : row["TotalDiscount"].ToString()));
row["TotalTax"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["TotalTax"].ToString()));
row["TotalAmount"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["TotalAmount"].ToString()));
row["OrderDate"] = _orderDate;
}
this.rptOrders.RefreshReport();
this.rptOrders.LocalReport.ReportEmbeddedResource = "CashierRegister.Pages.Report.rpt_Orders.rdlc";
this.rptOrders.LocalReport.DataSources.Clear();
Microsoft.Reporting.WinForms.ReportDataSource report_datasource = new Microsoft.Reporting.WinForms.ReportDataSource("DS_rpt_Order", dt_tb_cloned);
this.rptOrders.LocalReport.DataSources.Add(report_datasource);
Microsoft.Reporting.WinForms.ReportParameter[] rpt_parameter = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("titleParameter", titleParameter),
new Microsoft.Reporting.WinForms.ReportParameter("idParameter", idParameter),
new Microsoft.Reporting.WinForms.ReportParameter("customerNameParameter", customerNameParameter),
new Microsoft.Reporting.WinForms.ReportParameter("quantityParameter", quantityParameter),
new Microsoft.Reporting.WinForms.ReportParameter("orderDateParameter", orderDateParameter),
new Microsoft.Reporting.WinForms.ReportParameter("salespersonNameParameter", salespersonNameParameter),
new Microsoft.Reporting.WinForms.ReportParameter("paymentParameter", paymentParameter),
new Microsoft.Reporting.WinForms.ReportParameter("discountTypeParameter", discountTypeParameter),
new Microsoft.Reporting.WinForms.ReportParameter("discountParameter", discountParameter),
new Microsoft.Reporting.WinForms.ReportParameter("totalDiscountParameter", totalDiscountParameter),
new Microsoft.Reporting.WinForms.ReportParameter("totalTaxParameter", totalTaxParameter),
new Microsoft.Reporting.WinForms.ReportParameter("totalAmountParameter", totalAmountParameter),
};
this.rptOrders.LocalReport.SetParameters(rpt_parameter);
this.rptOrders.RefreshReport();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void LoadReport()
{
try
{
DateTime?dtFrom = dtpFromDate.Value.ToDateorNull();
DateTime?dtTill = dtpToDate.Value.ToDateorNull();
if (dtFrom != null && dtpFromTime.Value != null && dtpFromTime.Value.Value != null)
{
dtFrom = (dtFrom.Value.ToDate() + dtpFromTime.Value.Value.TimeOfDay).ToDateTime();
}
int driverId = ddlAllDriver.SelectedValue.ToInt();
int SubCompanyId = ddlSubCompany.SelectedValue.ToInt();
int Rating;
if (ddlRating.Text == "")
{
Rating = 0;
}
else
{
Rating = ddlRating.Text.ToInt();
}
if (dtTill != null && dtptilltime.Value != null && dtptilltime.Value.Value != null)
{
dtTill = (dtTill.Value.ToDate() + dtptilltime.Value.Value.TimeOfDay).ToDateTime();
}
string Error = string.Empty;
if (dtFrom == null)
{
Error = "Required: From Date";
}
if (dtTill == null)
{
if (string.IsNullOrEmpty(Error))
{
Error = "Required: To Date";
}
else
{
Error += Environment.NewLine + "Required: To Date";
}
}
if (!string.IsNullOrEmpty(Error))
{
ENUtils.ShowMessage(Error);
return;
}
this.reportViewer1.LocalReport.EnableExternalImages = true;
using (TaxiDataContext db = new TaxiDataContext())
{
var list2 = db.stp_CustomerFeedback(dtFrom, dtTill, SubCompanyId, driverId, Rating).ToList();;
this.stp_CustomerFeedbackResultBindingSource.DataSource = list2;
}
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[3];
string heading = string.Empty;
heading = "Date Range: " + string.Format("{0:yyyy-MM-dd HH:mm}", dtFrom) + " to " + string.Format("{0:yyyy-MM-dd HH:mm}", dtTill);
//heading = "From: "+string.Format("{0:dd/MM/yyyy}", dtFrom) + " To: " + string.Format("{0:dd/MM/yyyy}", dtTill);
// string EndDate = string.Format("{0:dd/MM/yyyy}", DateTime.Now);
//string To = string.Format("{0:dd/MM/yyyy}", dtTill);
// string Earning = "Driver Earnings - "+list.Count().ToStr()+" found";
param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_CompanyHeading", AppVars.objSubCompany.CompanyName);
param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", AppVars.objSubCompany.Address);
param[2] = new Microsoft.Reporting.WinForms.ReportParameter("ReportParameterPeriod", heading);
//List<ClsLogo> objLogo = new List<ClsLogo>();
//objLogo.Add(new ClsLogo { ImageInBytes = AppVars.objSubCompany.CompanyLogo != null ? AppVars.objSubCompany.CompanyLogo.ToArray() : null });
//ReportDataSource imageDataSource = new ReportDataSource("Taxi_AppMain_Classes_ClsLogo", objLogo);
//this.reportViewer1.LocalReport.DataSources.Add(imageDataSource);
reportViewer1.LocalReport.SetParameters(param);
this.reportViewer1.ZoomPercent = 100;
this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
this.reportViewer1.RefreshReport();
IsReportLoaded = true;
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void LaskuPohja_Load(object sender, EventArgs e)
{
using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;" + @"AttachDbFilename=|DataDirectory|\mokkivaraus.mdf; Integrated Security=True"))
{
try
{
// Määritellään SQL-tietokannasta tehtävä haku.
string query = "SELECT Lasku.lasku_id, Lasku.nimi, Lasku.lahiosoite, Lasku.postitoimipaikka, Lasku.email, Lasku.summa, Lasku.alv, Lasku.paivays, Varaus.varaus_id " +
"FROM Lasku " +
"INNER JOIN Varaus ON Varaus.varaus_id = Lasku.varaus_id " +
"WHERE Varaus.varaus_id = @varaus_id";
SqlCommand command = new SqlCommand(query, connection);
// Suorita haku tietokannasta ja vie hakutulokset
//DataGridView-näkymään tarkasteltavaksi.
command.Parameters.Add("@varaus_id", SqlDbType.Int).Value = Convert.ToInt32(Laskutus.Varaus_id);
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
nimi = ds.Tables[0].Rows[0]["nimi"].ToString();
lahiosoite = ds.Tables[0].Rows[0]["lahiosoite"].ToString();
postitoimipaikka = ds.Tables[0].Rows[0]["postitoimipaikka"].ToString();
email = ds.Tables[0].Rows[0]["email"].ToString();
lasku_id = ds.Tables[0].Rows[0]["lasku_id"].ToString();
paivays = DateTime.Parse(ds.Tables[0].Rows[0]["paivays"].ToString());
erapaiva = DateTime.Parse(ds.Tables[0].Rows[0]["paivays"].ToString()).AddDays(14);
varaus_id = ds.Tables[0].Rows[0]["varaus_id"].ToString();
summa = ds.Tables[0].Rows[0]["summa"].ToString();
viite = DateTime.Parse(ds.Tables[0].Rows[0]["paivays"].ToString()).Year + ds.Tables[0].Rows[0]["varaus_id"].ToString();
}
catch (Exception ex)
{
// Tulosta virheilmoitus.
MessageBox.Show("Tapahtui virhe: " + ex.Message, "Virhe", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
// Määritellään raportin parametrit.
Microsoft.Reporting.WinForms.ReportParameter[] parameters = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("LaskuNimi", LaskuPohja.Nimi),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuLahiosoite", LaskuPohja.Lahiosoite),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuPostitoimipaikka", LaskuPohja.Postitoimipaikka),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuEmail", LaskuPohja.Email),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuId", LaskuPohja.Lasku_id),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuViite", LaskuPohja.Viite.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuPaivays", LaskuPohja.Paivays.ToShortDateString()),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuErapaiva", LaskuPohja.Erapaiva.ToShortDateString()),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuVarausId", LaskuPohja.Varaus_Id),
new Microsoft.Reporting.WinForms.ReportParameter("LaskuSumma", LaskuPohja.Summa),
};
// Vie edellä määritellyt parametrit ReportViewer-ikkunaan.
this.reportViewer_LaskuPohja.LocalReport.SetParameters(parameters);
this.reportViewer_LaskuPohja.RefreshReport();
}
catch (Exception ex)
{
// Tulosta virheilmoitus.
MessageBox.Show("Tapahtui virhe: " + ex.Message, "Virhe", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
//ReportDetailPrint_Load
private void ReportDetailPrint_Load(object sender, EventArgs e)
{
try
{
//set location for form
this.Location = new Point(point_x, point_y);
DataTable dt_tb_orderdetail = new DataTable();
dt_tb_orderdetail = bus_tb_orderdetail.GetOrderDetail("Where [OrderID]=" + StaticClass.GeneralClass.orderdetailid_general);
DataTable dt_tb_cloned = dt_tb_orderdetail.Clone();
dt_tb_cloned.Columns["Price"].DataType = typeof(string);
dt_tb_cloned.Columns["Tax"].DataType = typeof(string);
dt_tb_cloned.Columns["DiscountType"].DataType = typeof(string);
dt_tb_cloned.Columns["Discount"].DataType = typeof(string);
dt_tb_cloned.Columns["Total"].DataType = typeof(string);
foreach (DataRow row in dt_tb_orderdetail.Rows)
{
dt_tb_cloned.ImportRow(row);
}
foreach (DataRow row in dt_tb_cloned.Rows)
{
row["Price"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Price"].ToString()));
row["Tax"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Tax"].ToString()));
if (row["DiscountType"].ToString() == "1")
{
row["DiscountType"] = "%";
}
else
{
row["DiscountType"] = StaticClass.GeneralClass.currency_setting_general;
}
row["Discount"] = StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Discount"].ToString()));
row["Total"] = StaticClass.GeneralClass.currency_setting_general + StaticClass.GeneralClass.GetNumFormatDisplay(Convert.ToDecimal(row["Total"].ToString()));
}
this.rpvOrderDetail.RefreshReport();
rpvOrderDetail.LocalReport.ReportEmbeddedResource = "CashierRegister.Pages.Report.rpt_OrderDetails.rdlc";
rpvOrderDetail.LocalReport.DataSources.Clear();
Microsoft.Reporting.WinForms.ReportDataSource reportdatasource = new Microsoft.Reporting.WinForms.ReportDataSource("DS_rpt_OrderDetail", dt_tb_cloned);
rpvOrderDetail.LocalReport.DataSources.Add(reportdatasource);
Microsoft.Reporting.WinForms.ReportParameter[] rpt_parameter = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("titleParameter", titleParameter),
new Microsoft.Reporting.WinForms.ReportParameter("idParameter", idParameter),
new Microsoft.Reporting.WinForms.ReportParameter("categoryNameParameter", categoryNameParameter),
new Microsoft.Reporting.WinForms.ReportParameter("productIDParameter", productIDParameter),
new Microsoft.Reporting.WinForms.ReportParameter("productNameParameter", productNameParameter),
new Microsoft.Reporting.WinForms.ReportParameter("priceParameter", priceParameter),
new Microsoft.Reporting.WinForms.ReportParameter("qtyParameter", qtyParameter),
new Microsoft.Reporting.WinForms.ReportParameter("taxParameter", taxParameter),
new Microsoft.Reporting.WinForms.ReportParameter("discountTypeParameter", discountTypeParameter),
new Microsoft.Reporting.WinForms.ReportParameter("discountParameter", discountParameter),
new Microsoft.Reporting.WinForms.ReportParameter("totalParameter", totalParameter),
};
this.rpvOrderDetail.LocalReport.SetParameters(rpt_parameter);
rpvOrderDetail.RefreshReport();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void LoadReport()
{
try
{
DateTime?dtFrom = dtpFromDate.Value.ToDateorNull();
DateTime?dtTill = dtpToDate.Value.ToDateorNull();
if (dtFrom != null && dtpFromTime.Value != null && dtpFromTime.Value.Value != null)
{
dtFrom = (dtFrom.Value.ToDate() + dtpFromTime.Value.Value.TimeOfDay).ToDateTime();
}
if (dtTill != null && dtptilltime.Value != null && dtptilltime.Value.Value != null)
{
dtTill = (dtTill.Value.ToDate() + dtptilltime.Value.Value.TimeOfDay).ToDateTime();
}
string Error = string.Empty;
if (dtFrom == null)
{
Error = "Required: From Date";
}
if (dtTill == null)
{
if (string.IsNullOrEmpty(Error))
{
Error = "Required: To Date";
}
else
{
Error += Environment.NewLine + "Required: To Date";
}
}
if (!string.IsNullOrEmpty(Error))
{
ENUtils.ShowMessage(Error);
return;
}
this.reportViewer1.LocalReport.EnableExternalImages = true;
if (templateName == null)
{
templateName = General.GetObject <UM_Form_Template>(c => c.UM_Form.FormName == this.Name && c.IsDefault == true).DefaultIfEmpty().TemplateName.ToStr();
}
int cnt = 0;
if (templateName.ToStr().ToLower().Trim() == "template2")
{
this.reportViewer1.LocalReport.ReportEmbeddedResource = "Taxi_AppMain.ReportDesigns.template2_rptDriverEarning.rdlc";
var list = (from a in new Taxi_Model.TaxiDataContext().stp_GetDriverEarning(dtFrom, dtTill, ddlAllDriver.SelectedValue.ToInt(), Enums.BOOKINGSTATUS.DISPATCHED, 0)
select new
{
DriverId = a.DriverId,
DriverNo = a.DriverNo,
Name = a.Name,
LoginHour = a.LoginHour,
TotalDays = a.TotalDays,
TotalHrs = a.TotalHrs,
BreakTime = a.Break,
Total = a.Total,
Noshow = a.Noshow,
JobsDone = a.JobsDone,
Decline = a.Decline,
//Earning = (a.TotalDays==2?(a.Total-a.Commission):a.Total).ToDecimal(),
Earning = (a.Account - a.Commission).ToDecimal(),
Account = a.Account,
Cash = a.Cash,
Commission = a.Commission,
AvgJob = a.PDARent,
Avghour = a.Parking + a.ExtraDropCharges,
Avgday = ((a.Account - a.Commission).ToDecimal() + (a.Parking + a.ExtraDropCharges)) - a.PDARent,
LoginDateTime = a.LoginDateTime,
a.PDARent,
a.Parking,
a.Waiting,
a.ExtraDropCharges,
a.DriverCommissionPerBooking
}).ToList();
var list2 = (list.AsEnumerable().OrderBy(item => item.DriverNo, new NaturalSortComparer <string>())).ToList();
this.stp_GetDriverCommissionEarningResultBindingSource.DataSource = list2;
cnt = list.Count;
}
else
{
var list = (from a in new Taxi_Model.TaxiDataContext().stp_GetDriverEarning(dtFrom, dtTill, ddlAllDriver.SelectedValue.ToInt(), Enums.BOOKINGSTATUS.DISPATCHED, 0)
select new
{
//DriverId = a.DriverId,
//DriverNo = a.DriverNo,
//Name = a.Name,
//LoginHour = a.LoginHour,
//TotalDays = a.TotalDays,
//TotalHrs = a.TotalHrs,
//Total = a.Total,
//Noshow = a.Noshow,
//JobsDone = a.JobsDone,
//Decline = a.Decline,
//Earning = (a.Total-a.Commission),
//Account = a.Account,
//Cash = a.Cash,
//Commission = a.Commission,
//AvgJob = AvgJob(a.Total.ToDecimal(),a.Commission.ToDecimal(),a.JobsDone.ToInt()),//(((a.Total - a.Commission) / (a.JobsDone))).ToDecimal(),
//Avghour = ((a.Total/(a.LoginHour.ToInt()==0?1:a.LoginHour))).ToDecimal(),
//Avgday = ((a.Total /( a.LoginDateTime.ToInt()==0?1:a.LoginDateTime))).ToDecimal(),
//LoginDateTime = a.LoginDateTime,
DriverId = a.DriverId,
DriverNo = a.DriverNo,
Name = a.Name,
LoginHour = a.LoginHour,
TotalDays = a.TotalDays,
TotalHrs = a.TotalHrs,
BreakTime = a.Break,
Total = a.Total,
Noshow = a.Noshow,
JobsDone = a.JobsDone,
Decline = a.Decline,
//Earning = (a.TotalDays==2?(a.Total-a.Commission):a.Total).ToDecimal(),
Earning = (a.TotalDays == 2 ? (a.Total - a.Commission) : a.Total).ToDecimal(),
Account = a.Account,
Cash = a.Cash,
Commission = a.Commission,
AvgJob = AvgJob(a.Total.ToDecimal(), a.TotalDays == 2 ? a.Commission.ToDecimal() : 0, a.JobsDone.ToInt()), //(((a.Total - a.Commission) / (a.JobsDone))).ToDecimal(),
Avghour = ((a.Total / (a.LoginHour.ToInt() == 0 ? 1 : a.LoginHour))).ToDecimal(),
Avgday = ((a.Total / (a.LoginDateTime.ToInt() == 0 ? 1 : a.LoginDateTime))).ToDecimal(),
LoginDateTime = a.LoginDateTime,
a.PDARent,
a.Parking,
a.Waiting,
a.ExtraDropCharges,
a.DriverCommissionPerBooking
}).ToList();
var list2 = (list.AsEnumerable().OrderBy(item => item.DriverNo, new NaturalSortComparer <string>())).ToList();
this.stp_GetDriverCommissionEarningResultBindingSource.DataSource = list2;
cnt = list.Count;
}
Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[2];
string heading = string.Empty;
heading = "Date Range: " + string.Format("{0:yyyy-MM-dd HH:mm}", dtFrom) + " to " + string.Format("{0:yyyy-MM-dd HH:mm}", dtTill);
string Earning = "Driver Earnings - " + cnt.ToStr() + " found";
param[0] = new Microsoft.Reporting.WinForms.ReportParameter("ReportParameterPeriod", heading);
param[1] = new Microsoft.Reporting.WinForms.ReportParameter("ReportParameterTotalDrivers", Earning);
reportViewer1.LocalReport.SetParameters(param);
this.reportViewer1.ZoomPercent = 100;
this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
this.reportViewer1.RefreshReport();
IsReportLoaded = true;
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void FormRelatorio_Load(object sender, EventArgs e)
{
if (connectBanco())
{
try
{
reportDataSource1.Name = "DataSet1";
switch (Op)
{
case 1:
reportDataSource1.Value = this.getdataprazoBindingSource;
this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report.Relatorio.NBaixa.rdlc";
var dataprazo = new Microsoft.Reporting.WinForms.ReportParameter("Data", Aux);
this.reportViewer1.LocalReport.SetParameters(dataprazo);
this.getdataprazoTableAdapter.Fill(this.dBars.Getdataprazo, Aux);
break;
case 2:
reportDataSource1.Value = this.getnomebaixaBindingSource;
reportDataSource2.Value = this.quantidadeBaixaBindingSource;
this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report.Relatorio.BaixaHoje.rdlc";
var baixa = new Microsoft.Reporting.WinForms.ReportParameter("Data", Aux);
var nome = new Microsoft.Reporting.WinForms.ReportParameter(nameof(Nome), Nome);
this.reportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] { baixa, nome });
this.getnomebaixaTableAdapter.Fill(this.dBars.Getnomebaixa, Aux, Nome);
this.quantidadeBaixaTableAdapter.Fill(this.dBars.QuantidadeBaixa, Aux);
break;
case 3:
reportDataSource1.Value = this.getDataBindingSource;
reportDataSource2.Value = this.quantidadeBaixaBindingSource;
this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report.Relatorio.BaixasPar.rdlc";
var qnt = new Microsoft.Reporting.WinForms.ReportParameter("Quantidade", Aux);
var get = new Microsoft.Reporting.WinForms.ReportParameter("Data", Aux);
this.reportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] { qnt, get });
this.getDataTableAdapter.Fill(this.dBars.GetData, Aux);
this.quantidadeBaixaTableAdapter.Fill(this.dBars.QuantidadeBaixa, Aux);
break;
case 4:
reportDataSource1.Value = this.getImportaBindingSource;
this.reportViewer1.LocalReport.ReportEmbeddedResource = "Report.Relatorio.TitBaixaHoje.rdlc";
var Data = new Microsoft.Reporting.WinForms.ReportParameter("Data", data.ToShortDateString());
this.reportViewer1.LocalReport.SetParameters(Data);
this.getImportaTableAdapter.Fill(this.dBars.GetImporta, data);
break;
default:
this.Dispose();
this.Close();
break;
}
this.reportViewer1.LocalReport.DataSources.Add(reportDataSource1);
this.reportViewer1.LocalReport.DataSources.Add(reportDataSource2);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Relatório", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
var pg = new System.Drawing.Printing.PageSettings
{
Margins = new System.Drawing.Printing.Margins(36, 2, 10, 2),
Landscape = true
};
this.reportViewer1.SetPageSettings(pg);
this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
this.reportViewer1.RefreshReport();
}
}
