private void bttn_AllPrintKhatawani_Click(object sender, EventArgs e)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
DataTable dtKhatawani = _objGirviAdd.getAllKhatawaniDetails();
for (int i = 0; i < dtKhatawani.Rows.Count; i++)
{
txt_KhatawaniNo.Text = dtKhatawani.Rows[i]["khatawani_No"].ToString();
FillGrids();
DataTable dtGirviDetails = _objCommon.DataGridView2DataTable(dgv_GirviDetail, "dtCustomerBill");
DataTable dtPaydetails = _objCommon.DataGridView2DataTable(dgv_PaymentDetail, "table");
DataTable dtMerge = _objCommon.mergeTwoDataGrid(dtGirviDetails, dtPaydetails);
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendDataMulti _obj = new SendDataMulti(_objfrm_ReportViewer.ReceiveDataInterestRecordMultiPrint);
if (rbt_OtherTrue.Checked == true)
{
_obj(dtMerge, txt_KhatawaniNo.Text, totalloanamountsum.ToString(), totalpaidsum.ToString(), oPrintersetting.PrinterName, true);
}
else
{
_obj(dtMerge, txt_KhatawaniNo.Text, totalloanamountsum.ToString(), totalpaidsum.ToString(), oPrintersetting.PrinterName, false);
}
MasterClear();
}
}
}
private void bttn_PrintReport_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
int j = 0;
for (int v = 0; v <= (Convert.ToDateTime(dtp_EndDate.Text) - Convert.ToDateTime(dtp_StartDate.Text)).TotalDays; v++)
{
DataTable dt = _objRokad.getAllGirvi((Convert.ToDateTime(dtp_StartDate.Text).AddDays(j)).ToString("dd/MM/yyyy"));
for (int k = 0; k < dt.Rows.Count; k++)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveBabhulgaonOfficeCopyMulti);
_obj(dt.Rows[k]["GirviRecordNo"].ToString(), dt.Rows[k]["khatawani_No"].ToString(), "", oPrintersetting.PrinterName);
// _objfrm_ReportViewer.Show();
}
j++;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void bttn_login_Click(object sender, EventArgs e)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
if (rbt_OtherTrue.Checked == true)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveBabhulgaonOfficeCopy);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
else
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveBabhulgaonOfficeCopy);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
}
//}
//else
//{
//}
//if (rbt_Marathi.Checked == true)
//{
// CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
// SendDataSingle _obj = new SendDataSingle(_objfrm_ReportViewer.ReceiveDataAddGirvi);
// _obj(txt_InvoiceNo.Text, txt_KhatawaniNo.Text, "All");
// _objfrm_ReportViewer.Show();
//}
}
private void button1_Click(object sender, EventArgs e)
{
DataTable DT = _common.DataGridView2DataTable(dgv_Balance, "Balance", 0);
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.Balance);
_obj(DT, "Supplier", dtp_date.Value.ToString("dd/MM/yyyy"));
}
private void bttn_view_Click(object sender, EventArgs e)
{
if (txt_type.Text == "GST")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.CustomerBill);
_obj(bill.Text, "View");
_objfrm_ReportViewer.Show();
}
else if (txt_type.Text == "Qoutation")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.Qoutation);
_obj(bill.Text, "View");
_objfrm_ReportViewer.Show();
}
else if (txt_type.Text == "Estimate")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.CustomerBillEst);
_obj(bill.Text, "View");
_objfrm_ReportViewer.Show();
}
else if (txt_type.Text == "Service Invoice")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ServiceInvoice);
_obj(bill.Text, "View");
_objfrm_ReportViewer.Show();
}
}
private void bttn_monthwiseReport_Click(object sender, EventArgs e)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendDataMonthwise _obj = new SendDataMonthwise(_objfrm_ReportViewer.ReceiveMonthWiseReport);
_obj();
_objfrm_ReportViewer.Show();
}
private void print()
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.SaleLedger);
_obj(dtCustBill, dtpay, txt_Bill.Text, txt_payment.Text, txt_balance.Text, txt_Extra.Text);
_objfrm_ReportViewer.Show();
}
private void print()
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.PurchaseLedger);
_obj(dtsupplierBill, dtsupplierpay, txt_Bill.Text, txt_payment.Text, txt_balance.Text);
_objfrm_ReportViewer.Show();
}
private void bttn_login_Click(object sender, EventArgs e)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataForm14);
_obj(txt_KhatawaniNo.Text, false);
_objfrm_ReportViewer.Show();
}
private void bttn_view_Click(object sender, EventArgs e)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.PaymentReceipt);
_obj(bill.Text, "Customer");
_objfrm_ReportViewer.Show();
}
private void bttn_PrintReport_Click(object sender, EventArgs e)
{
DataTable data = val.DataGridView2DataTable(dgv_CashDetail, "table");
int start = 0, end = 0;
for (int i = 0; i < dgv_CashDetail.Rows.Count; i++)
{
if (data.Rows[i]["Date"].ToString() == dtp_StartDate.Text)
{
start = i;
}
if (data.Rows[i]["Date"].ToString() == dtp_EndDate.Text)
{
end = i;
}
}
DataTable dataNew = val.DataGridView2DataTable(dgv_CashDetail, "table");
dataNew.Rows.Clear();
int j = 0;
for (int i = start - 1; i <= end; i++)
{
dataNew.Rows.Add();
dataNew.Rows[j]["Date"] = data.Rows[i]["Date"].ToString();
//dataNew.Rows[j]["RokadPan"] = data.Rows[i]["RokadPan"].ToString();
dataNew.Rows[j]["GirviAdded"] = data.Rows[i]["GirviAdded"].ToString();
dataNew.Rows[j]["GirviRelease"] = data.Rows[i]["GirviRelease"].ToString();
dataNew.Rows[j]["Interest"] = data.Rows[i]["Interest"].ToString();
dataNew.Rows[j]["OtherExpence"] = data.Rows[i]["OtherExpence"].ToString();
dataNew.Rows[j]["OtherAmountAdded"] = data.Rows[i]["OtherAmountAdded"].ToString();
dataNew.Rows[j]["OpeningValue"] = data.Rows[i]["OpeningValue"].ToString();
dataNew.Rows[j]["Diffrence"] = data.Rows[i]["Diffrence"].ToString();
j++;
}
dataNew.Rows[0]["Date"] = "";
dataNew.Rows[0]["Interest"] = "";
dataNew.Rows[0]["GirviAdded"] = "";
dataNew.Rows[0]["GirviRelease"] = "";
dataNew.Rows[0]["OtherExpence"] = "";
dataNew.Rows[0]["OtherAmountAdded"] = "";
dataNew.Rows[0]["Diffrence"] = "";
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveCashInHand);
if (rbt_OtherTrue.Checked == true)
{
_obj(dataNew, dtp_EndDate.Text, true);
}
else
{
_obj(dataNew, dtp_EndDate.Text, false);
}
_objfrm_ReportViewer.Show();
}
private void bttn_Print_Click(object sender, EventArgs e)
{
DataTable DT = _common.DataGridView2DataTable(dgv_Balance, "Balance", 0);
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.Balance);
_obj(DT, "Customer", DateTime.Now.ToString("dd/MM/yyyy"));
}
private void bttn_Print_Click(object sender, EventArgs e)
{
DataTable data = val.DataGridView2DataTable(dgv_SixMonthReport, "table");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveSixMonth);
_obj(data, false);
_objfrm_ReportViewer.ShowDialog();
}
private void btn_print_Click(object sender, EventArgs e)
{
DataTable dataNew = val.DataGridView2DataTable(dgv_Girvicutomershift, "dt_CashInHand");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReciveDataCustprint);
_obj(dataNew, true);
_objfrm_ReportViewer.Show();
}
private void bttn_Print_Click(object sender, EventArgs e)
{
DataTable data = val.DataGridView2DataTable(dgv_InterestDetail, "table");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveTotalInterest);
_obj(data, lbl_MonthYear.Text, false);
_objfrm_ReportViewer.ShowDialog();
}
private void bttn_Print_Click(object sender, EventArgs e)
{
for (int i = 0; i < dgv_CustomerItem.Rows.Count; i++)
{
if (Convert.ToBoolean(dgv_CustomerItem.Rows[i].Cells["Chk"].Value) == true)
{
try
{
string BillNo = dgv_CustomerItem.Rows[i].Cells["BillNo"].Value.ToString();
string Type = dgv_CustomerItem.Rows[i].Cells["Type"].Value.ToString();
try
{
if (Type == "GST")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.CustomerBill);
_obj(BillNo, "Print");
}
if (Type == "Qoutation")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.Qoutation);
_obj(BillNo, "Print");
}
else if (Type == "Estimate")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.CustomerBillEst);
_obj(BillNo, "Print");
}
if (Type == "Service Invoice")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ServiceInvoice);
_obj(BillNo, "Print");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//_s.PrintBillThermal(cmb_BillNo.Text);
}
catch (Exception ex)
{
}
}
}
MessageBox.Show("Printed Succesfully");
}
private void bttn_PrintReport_Click(object sender, EventArgs e)
{
DataTable data = val.DataGridView2DataTable(dgv_CashDetail, "table");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataBalanceSheetMonthwise);
_obj(data, false);
_objfrm_ReportViewer.Show();
}
private void bttn_print_Click(object sender, EventArgs e)
{
try
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.PaymentReceipt);
_obj(bill.Text, "Customer");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//_s.PrintBillThermal(cmb_BillNo.Text);
}
private void Form14()
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
for (int j = 0; j < dgv_KhatawaniDetail.Rows.Count; j++)
{
if (Convert.ToBoolean(dgv_KhatawaniDetail.Rows[j].Cells["chk"].Value) == true)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataForm14Multi);
_obj(dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString(), false, oPrintersetting.PrinterName);
}
}
}
}
private void bttn_Print_Click(object sender, EventArgs e)
{
try
{
DataTable dt = val.DataGridView2DataTable(dgv_DebitData, "table1");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveCreditDetailsReport);
_obj(dt);
_objfrm_ReportViewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void bttn_login_Click(object sender, EventArgs e)
{
if (rbt_OtherTrue.Checked == true)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataReleaseGirvi);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
}
else
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataReleaseGirvi);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
}
private void bttn_Print_Click(object sender, EventArgs e)
{
DataTable dataNew = val.DataGridView2DataTable(dgv_Vinatarakdetails, "table");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReciveDataVinaTaranReport);
if (rbt_OtherTrue.Checked == true)
{
_obj(dataNew, true);
}
else
{
_obj(dataNew, false);
}
_objfrm_ReportViewer.Show();
}
private void bttn_Print_Click(object sender, EventArgs e)
{
DataTable data = val.DataGridView2DataTable(dgv_girvidetails, "table");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataAllKhatawaniGirviAddedDetails);
if (rbt_OtherTrue.Checked == true)
{
_obj(data, dtp_EndDate.Text, true);
}
else
{
_obj(data, dtp_EndDate.Text, false);
}
_objfrm_ReportViewer.Show();
}
private void bttn_view_Click(object sender, EventArgs e)
{
if (txt_type.Text == "GST")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.SupplierBill);
_obj(txt_ref.Text, "View");
_objfrm_ReportViewer.Show();
}
else if (txt_type.Text == "Estimate")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.SupplierBillEst);
_obj(txt_ref.Text, "View");
_objfrm_ReportViewer.Show();
}
}
private void bttn_print_Click(object sender, EventArgs e)
{
DataTable data = val.DataGridView2DataTable(dataGridView_GirviDetails, "table");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataGirviByAddress);
if (rbt_OtherTrue.Checked == true)
{
_obj(data, true);
}
else
{
_obj(data, false);
}
_objfrm_ReportViewer.Show();
}
private void bttn_print_Click(object sender, EventArgs e)
{
try
{
if (dtSett.BillType == "Laser")
{
if (txt_type.Text == "GST")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.CustomerBill);
_obj(bill.Text, "Print");
}
if (txt_type.Text == "Qoutation")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.Qoutation);
_obj(bill.Text, "Print");
}
else if (txt_type.Text == "Estimate")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.CustomerBillEst);
_obj(bill.Text, "Print");
}
if (txt_type.Text == "Service Invoice")
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ServiceInvoice);
_obj(bill.Text, "Print");
}
}
else
{
_Bill = new bin.Debug.cls_ThermalBill(bill.Text);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//_s.PrintBillThermal(cmb_BillNo.Text);
}
private void bttn_Print_Click(object sender, EventArgs e)
{
DataTable dtGirviDetails = _objCommon.DataGridView2DataTable(dgv_GirviAdded, "dtCustomerBill");
DataTable dtPaydetails = _objCommon.DataGridView2DataTable(dgv_GirviRelease, "table");
DataTable dtMerge = _objCommon.mergeTwoDataGrid(dtGirviDetails, dtPaydetails);
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveCashbookRecord);
if (rbt_OtherTrue.Checked == true)
{
_obj(dtMerge, dtp_StartDate.Text, dtp_EndDate.Text, true);
}
else
{
_obj(dtMerge, dtp_StartDate.Text, dtp_EndDate.Text, false);
}
_objfrm_ReportViewer.Show();
}
private void bttn_Print_Click(object sender, EventArgs e)
{
DataTable dtGirviDetails = _objCommon.DataGridView2DataTable(dgv_GirviDetail, "dtCustomerBill");
DataTable dtPaydetails = _objCommon.DataGridView2DataTable(dgv_PaymentDetail, "table");
DataTable dtMerge = _objCommon.mergeTwoDataGrid(dtGirviDetails, dtPaydetails);
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataInterestRecord);
if (rbt_OtherTrue.Checked == true)
{
_obj(dtMerge, txt_KhatawaniNo.Text, totalloanamountsum.ToString(), totalpaidsum.ToString(), txt_AccountBalance.Text, true);
}
else
{
_obj(dtMerge, txt_KhatawaniNo.Text, totalloanamountsum.ToString(), totalpaidsum.ToString(), txt_AccountBalance.Text, false);
}
_objfrm_ReportViewer.Show();
}
private void dgv_Bill_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
string BillNo = dgv_Bill.Rows[e.RowIndex].Cells["BillNo"].Value.ToString();
if (BillNo[0] == 'S')
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
ViewData _obj = new ViewData(_objfrm_ReportViewer.CustomerBill);
_obj(BillNo, "View");
_objfrm_ReportViewer.Show();
}
if (BillNo[0] == 'T')
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
ViewData _obj = new ViewData(_objfrm_ReportViewer.CustomerBillEst);
_obj(BillNo, "View");
_objfrm_ReportViewer.Show();
}
}
private void dgv_Bill_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string BillNo = dgv_Bill.Rows[e.RowIndex].Cells["RefrenceNo"].Value.ToString();
{
}
if (BillNo[1] == 'R')
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
ViewData _obj = new ViewData(_objfrm_ReportViewer.SupplierBill);
_obj(BillNo, "View");
_objfrm_ReportViewer.Show();
}
else if (BillNo[1] == 'E')
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
ViewData _obj = new ViewData(_objfrm_ReportViewer.SupplierBillEst);
_obj(BillNo, "View");
_objfrm_ReportViewer.Show();
}
}