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 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.PurchaseLedger);
_obj(dtsupplierBill, dtsupplierpay, txt_Bill.Text, txt_payment.Text, txt_balance.Text);
_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 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 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_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
{
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 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_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(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_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 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();
}
}
private void KhatawaniIndex()
{
DataTable dtKhatawani = _objCommon.DataGridView2DataTableSelected(dgv_KhatawaniDetail, "table");
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendDataKhatawani _obj = new SendDataKhatawani(_objfrm_ReportViewer.ReceiveKhatawaniList);
if (rbt_OtherTrue.Checked == true)
{
_obj(dtKhatawani, true);
}
else
{
_obj(dtKhatawani, false);
}
_objfrm_ReportViewer.Show();
//DataTable dtKhatawani = _objCommon.DataGridView2DataTable(dgv_KhatawaniDetail, "table");
//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)
// {
// if (_objGirviAdd.getGirviDetailsByKhatawani(dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString()).Rows.Count > 0)
// {
// CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
// SendDataKhatawani _obj = new SendDataKhatawani (_objfrm_ReportViewer.ReceiveKhatawaniList);
// _obj(dtKhatawani, true);
// }
// }
// }
//}
}
private void bttn_login_Click(object sender, EventArgs e)
{
if (rbt_OtherTrue.Checked == true)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].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.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
}
if (rbt_English.Checked == true)
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].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.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "Other", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
}
else
{
if (oPrintersetting.ShowDialog() == DialogResult.OK)
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
else
{
CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer();
SendData _obj = new SendData(_objfrm_ReportViewer.ReceiveDataNotice);
_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["gn"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
//_obj(dgv_GirviDetail.Rows[dgv_GirviDetail.CurrentCell.RowIndex].Cells["AmountDeposit"].Value.ToString(), txt_KhatawaniNo.Text, "", oPrintersetting.PrinterName);
_objfrm_ReportViewer.Show();
}
}
}