/// <summary>
/// Function to check the voucher type and fill the corresponding vouchertype in VoucherType combobox
/// </summary>
/// <param name="strVoucherType"></param>
public void CallFromVoucherMenu(string strVoucherType)
{
try
{
if (formMDI.strVouchertype == "POS")
{
VoucherType = "POS";
}
else
{
VoucherType = strVoucherType;
}
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
List <DataTable> listObjVouchetType = new List <DataTable>();
listObjVouchetType = BllVoucherType.VoucherTypeSelectionComboFill(strVoucherType);
int inCount = listObjVouchetType[0].Rows.Count;
cmbVoucherType.DataSource = listObjVouchetType[0];
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.SelectedIndex = -1;
if (inCount == 1)
{
cmbVoucherType.SelectedValue = listObjVouchetType[0].Rows[0].ItemArray[0].ToString();
btnGo_Click(btnGo, EventArgs.Empty);
}
else
{
base.Show();
}
}
catch (Exception ex)
{
MessageBox.Show("VTS1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeNameComboFill()
{
try
{
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
List <DataTable> listObjVoucherTyeName = new List <DataTable>();
listObjVoucherTyeName = BllVoucherType.VoucherTypeNameComboFill();
DataRow dr = listObjVoucherTyeName[0].NewRow();
dr[1] = "All";
listObjVoucherTyeName[0].Rows.InsertAt(dr, 0);
cmbVoucherTypeName.DataSource = listObjVoucherTyeName[0];
cmbVoucherTypeName.ValueMember = "voucherTypeId";
cmbVoucherTypeName.DisplayMember = "voucherTypeName";
}
catch (Exception ex)
{
MessageBox.Show("MSR1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void VoucherTypeComboFill(string strVoucherName)
{
try
{
List <DataTable> listObj = new List <DataTable>();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
listObj = BllVoucherType.VoucherTypeCombofillForTaxAndVat(strVoucherName);
DataRow dr = listObj[0].NewRow();
dr["voucherTypeName"] = " ";
dr["voucherTypeId"] = 0;
listObj[0].Rows.InsertAt(dr, 0);
cmbVouchertype.DataSource = listObj[0];
cmbVouchertype.DisplayMember = "voucherTypeName";
cmbVouchertype.ValueMember = "voucherTypeId";
}
catch (Exception ex)
{
MessageBox.Show("TR:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
///// <summary>
///// Function to fill the vouchertypes
///// </summary>
//public void VoucherFill()
//{
// try
// {
// VoucherTypeSP spVoucher = new VoucherTypeSP();
// DataTable dt = new DataTable();
// dt = spVoucher.VatComboFill();
// DataRow dr = dt.NewRow();
// dr[1] = "All";
// dt.Rows.InsertAt(dr, 0);
// cmbVouchertype.ValueMember = "voucherTypeId";
// cmbVouchertype.DisplayMember = "voucherTypeName";
// cmbVouchertype.DataSource = dt;
// }
// catch (Exception ex)
// {
// MessageBox.Show("VRR:04" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
// }
//}
public void TypeOfVoucherCombofill()
{
try
{
List <DataTable> listObj = new List <DataTable>();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
listObj = BllVoucherType.TypeOfVoucherCombofillForVatAndTaxReport();
DataRow dr = listObj[0].NewRow();
dr["typeOfVoucher"] = "All";
dr["voucherTypeId"] = 0;
listObj[0].Rows.InsertAt(dr, 0);
cmbTypeofVoucher.DataSource = listObj[0];
cmbTypeofVoucher.DisplayMember = "typeOfVoucher";
cmbTypeofVoucher.ValueMember = "voucherTypeId";
}
catch (Exception ex)
{
MessageBox.Show("TR:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeComboFill()
{
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
List <DataTable> listObj = new List <DataTable>();
try
{
listObj = BllVoucherType.VoucherTypeSelectionComboFill("Purchase Invoice");
DataRow drow = listObj[0].NewRow();
drow["voucherTypeId"] = 0;
drow["voucherTypeName"] = "All";
listObj[0].Rows.InsertAt(drow, 0);
cmbVoucherType.DataSource = listObj[0];
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
}
catch (Exception ex)
{
MessageBox.Show("PIREG2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill vouchertype combobox
/// </summary>
public void VoucherComboFill()
{
try
{
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
List <DataTable> listObj = new List <DataTable>();
listObj = BllVoucherType.VoucherTypeViewAllForAgainstBillDetails();
DataRow dr = listObj[0].NewRow();
dr[0] = 0;
dr[1] = "All";
listObj[0].Rows.InsertAt(dr, 0);
cmbVoucherType.DisplayMember = "typeOfVoucher";
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DataSource = listObj[0];
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("AB1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeComboLoad()
{
try
{
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
List <DataTable> listObjVouchetType = new List <DataTable>();
listObjVouchetType = BllVoucherType.VoucherTypeSelectionComboFill("Journal Voucher");
DataRow dr = listObjVouchetType[0].NewRow();
dr[0] = 0;
dr[1] = "ALL";
listObjVouchetType[0].Rows.InsertAt(dr, 0);
cmbVoucherType.DataSource = listObjVouchetType[0];
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("JVREP2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill VoucherType combobox
/// </summary>
public void VoucherTypeComboFill()
{
try
{
List <DataTable> listObjVoucherTypes = new List <DataTable>();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
listObjVoucherTypes = BllVoucherType.VoucherTypeSelectionComboFill("Service Voucher");
DataRow dr = listObjVoucherTypes[0].NewRow();
dr["voucherTypeId"] = 0;
dr["voucherTypeName"] = "All";
listObjVoucherTypes[0].Rows.InsertAt(dr, 0);
cmbVoucherType.DataSource = listObjVoucherTypes[0];
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("SVRT 6 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill VoucherType name combobox
/// </summary>
public void VoucherTypeNameComboFill()
{
try
{
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
List <DataTable> listObj = new List <DataTable>();
decimal decVoucherTypeId = 0;
decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
listObj = BllVoucherType.VoucherTypeNameViewAllForComboFill(decVoucherTypeId);
DataRow dr = listObj[0].NewRow();
dr[0] = 0;
dr[1] = "All";
listObj[0].Rows.InsertAt(dr, 0);
cmbVoucherTypeName.DisplayMember = "voucherTypeName";
cmbVoucherTypeName.ValueMember = "voucherTypeId";
cmbVoucherTypeName.DataSource = listObj[0];
cmbVoucherTypeName.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("AB2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On print button click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
frmReport crptReport = new frmReport();
DataSet ds = new DataSet();
List <DataTable> listObjFormat2 = new List <DataTable>();
DataTable dtblTotal = new DataTable();
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
List <DataTable> listObjCompany = new List <DataTable>();
listObjCompany = bllCompanyCreation.CompanyViewAll();
if (dgvVatreturn.Rows.Count > 0)
{
if (dtblFill.Rows.Count > 0)
{
DataTable dtblReportFill = new DataTable();
dtblReportFill.Columns.Add("SlNO");
dtblReportFill.Columns.Add("Invoice No");
dtblReportFill.Columns.Add("Date");
dtblReportFill.Columns.Add("Party Name");
dtblReportFill.Columns.Add("Mailing Name");
dtblReportFill.Columns.Add("Tin No");
dtblReportFill.Columns.Add("qt");
dtblReportFill.Columns.Add("Sales Amound");
dtblReportFill.Columns.Add("Tax Amount");
dtblReportFill.Columns.Add("Cess");
dtblReportFill.Columns.Add("Net Amount");
dtblReportFill.Columns.Add("billDiscount");
dtblReportFill.Columns.Add("grandtotal");
for (int i = 0; i < dgvVatreturn.Rows.Count; i++)
{
DataRow drow = dtblReportFill.NewRow();
if (dgvVatreturn.Rows[i].Cells["dgvtxtSlno"].Value != null)
{
drow["SlNO"] = dgvVatreturn.Rows[i].Cells["dgvtxtSlno"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtInvoiceNo"].Value != null)
{
drow["Invoice No"] = dgvVatreturn.Rows[i].Cells["dgvtxtInvoiceNo"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtDate"].Value != null)
{
drow["Date"] = dgvVatreturn.Rows[i].Cells["dgvtxtDate"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtPartyName"].Value != null)
{
drow["Party Name"] = dgvVatreturn.Rows[i].Cells["dgvtxtPartyName"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtMailingName"].Value.ToString() != string.Empty)
{
drow["Mailing Name"] = dgvVatreturn.Rows[i].Cells["dgvtxtMailingName"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtTinNo"].Value != null)
{
drow["Tin No"] = dgvVatreturn.Rows[i].Cells["dgvtxtTinNo"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtQty"].Value != null)
{
drow["qt"] = dgvVatreturn.Rows[i].Cells["dgvtxtQty"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtSalesAmount"].Value != null)
{
drow["Sales Amound"] = dgvVatreturn.Rows[i].Cells["dgvtxtSalesAmount"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtTaxAmount"].Value != null)
{
drow["Tax Amount"] = dgvVatreturn.Rows[i].Cells["dgvtxtTaxAmount"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtCess"].Value != null)
{
drow["Cess"] = dgvVatreturn.Rows[i].Cells["dgvtxtCess"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtNetAmount"].Value != null)
{
drow["Net Amount"] = dgvVatreturn.Rows[i].Cells["dgvtxtNetAmount"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtbillDiscount"].Value != null)
{
drow["billDiscount"] = dgvVatreturn.Rows[i].Cells["dgvtxtbillDiscount"].Value.ToString();
}
if (dgvVatreturn.Rows[i].Cells["dgvtxtGrandTotal"].Value != null)
{
drow["grandtotal"] = dgvVatreturn.Rows[i].Cells["dgvtxtGrandTotal"].Value.ToString();
}
dtblReportFill.Rows.Add(drow);
}
ds.Tables.Add(dtblReportFill);
ds.Tables.Add(listObjCompany[0]);
crptReport.vatreturnReport(ds);
}
else
{
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
listObjFormat2 = BllVoucherType.VatGridFill(DateTime.Parse(dtpFrmDate.Text), DateTime.Parse(dtpToDate.Text), cmbTypeofVoucher.Text, Convert.ToDecimal(cmbVouchertype.SelectedValue.ToString()), strformat, cmbTax.Text);
if (dgvVatreturn.Rows.Count > 1)
{
dtblTotal.Columns.Add("taxableamt");
dtblTotal.Columns.Add("taxAmount");
DataRow dr1 = dtblTotal.NewRow();
dr1["taxableamt"] = dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 2].Cells["dgvtxtTaxableAmount"].Value.ToString();
dr1["taxAmount"] = dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 2].Cells["dgvtxttax"].Value.ToString();
dtblTotal.Rows.Add(dr1);
ds.Tables.Add(listObjCompany[0]);
ds.Tables.Add(listObjFormat2[0]);
ds.Tables.Add(dtblTotal);
crptReport.vatreturnReportFormat(ds);
}
}
}
else
{
MessageBox.Show("No data found", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("VRR:14" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the grid
/// </summary>
public void GridFill()
{
try
{
dgvVatreturn.Rows.Clear();
List <DataTable> list = new List <DataTable>();
string strVoucherTypeName = string.Empty;
decimal decVoucherTypeId;
if (rbtnFormat1.Checked)
{
strformat = "type1";
}
else
{
strformat = "type2";
}
if (cmbVouchertype.Enabled)
{
decVoucherTypeId = Convert.ToDecimal(cmbVouchertype.SelectedValue.ToString());
}
else
{
decVoucherTypeId = 0;
}
strVoucherTypeName = Convert.ToString(cmbTypeofVoucher.Text);
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
list = BllVoucherType.VatGridFill(Convert.ToDateTime(dtpFrmDate.Text), Convert.ToDateTime(dtpToDate.Text), strVoucherTypeName, decVoucherTypeId, strformat, cmbTax.Text);
dtblFill = list[0];
List <DataTable> listObjTaxName = new List <DataTable>();
listObjTaxName = BllVoucherType.VatViewTaxNames();
if (rbtnFormat1.Checked)
{
dgvVatreturn.Columns["dgvtxtTaxName"].Visible = false;
dgvVatreturn.Columns["dgvtxtTaxableAmount"].Visible = false;
dgvVatreturn.Columns["dgvtxttax"].Visible = false;
dgvVatreturn.Columns["dgvtxtQty"].Visible = true;
dgvVatreturn.Columns["dgvtxtSalesAmount"].Visible = true;
dgvVatreturn.Columns["dgvtxtTaxAmount"].Visible = true;
dgvVatreturn.Columns["dgvtxtNetAmount"].Visible = true;
dgvVatreturn.Columns["dgvtxtbillDiscount"].Visible = true;
foreach (DataRow drowDetails in list[0].Rows)
{
dgvVatreturn.Rows.Add();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtInvoiceNo"].Value = drowDetails["Invoice No"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtDate"].Value = drowDetails["Date"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtPartyName"].Value = drowDetails["Party Name"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtMailingName"].Value = drowDetails["Mailing Name"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtsalesmasterid"].Value = drowDetails["SalesMasterId"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtvoucherName"].Value = drowDetails["voucherName"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtVoucherType"].Value = drowDetails["voucherType"].ToString();
decimal dSaleId = Convert.ToDecimal(dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtsalesmasterid"].Value.ToString());
string strVoucherType = Convert.ToString(dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtVoucherType"].Value);
string qt = BllVoucherType.VoucherreportsumQty(dSaleId, strVoucherType);
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTinNo"].Value = drowDetails["Tin No"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtQty"].Value = qt;
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtSalesAmount"].Value = drowDetails["Sales Amound"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTaxAmount"].Value = Math.Round(Convert.ToDecimal(drowDetails["Tax Amount"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtCess"].Value = drowDetails["Cess"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtNetAmount"].Value = Math.Round(Convert.ToDecimal(drowDetails["Net Amount"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtbillDiscount"].Value = Math.Round(Convert.ToDecimal(drowDetails["billDiscount"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtGrandTotal"].Value = Math.Round(Convert.ToDecimal(drowDetails["grandtotal"].ToString()), PublicVariables._inNoOfDecimalPlaces).ToString();;
}
if (dgvVatreturn.Rows.Count > 0)
{
SerialNo();
}
}
else
{
dgvVatreturn.Rows.Clear();
dgvVatreturn.Columns["dgvtxtTaxName"].Visible = true;
dgvVatreturn.Columns["dgvtxtTaxableAmount"].Visible = true;
dgvVatreturn.Columns["dgvtxttax"].Visible = true;
dgvVatreturn.Columns["dgvtxtQty"].Visible = false;
dgvVatreturn.Columns["dgvtxtSalesAmount"].Visible = false;
dgvVatreturn.Columns["dgvtxtTaxAmount"].Visible = false;
dgvVatreturn.Columns["dgvtxtNetAmount"].Visible = false;
dgvVatreturn.Columns["dgvtxtbillDiscount"].Visible = false;
foreach (DataRow drowDetails in list[0].Rows)
{
dgvVatreturn.Rows.Add();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtInvoiceNo"].Value = drowDetails["Invoice No"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtDate"].Value = drowDetails["Date"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtPartyName"].Value = drowDetails["Party Name"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtMailingName"].Value = drowDetails["Mailing Name"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtsalesmasterid"].Value = drowDetails["SalesMasterId"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTinNo"].Value = drowDetails["Tin No"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtGrandTotal"].Value = drowDetails["grandtotal"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTaxName"].Value = drowDetails["taxName"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtTaxableAmount"].Value = drowDetails["rate"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxttax"].Value = drowDetails["taxamount"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtvoucherName"].Value = drowDetails["voucherName"].ToString();
dgvVatreturn.Rows[dgvVatreturn.Rows.Count - 1].Cells["dgvtxtVoucherType"].Value = drowDetails["voucherType"].ToString();
}
if (dgvVatreturn.Rows.Count > 0)
{
SerialNo();
dgvVatreturn.Rows.Add();
CalculateTotal();
}
dtblFill.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("VRR:06" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
