private void btnCusName_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtComname.Text))
{
PurchaseReportCom objPur = new PurchaseReportCom();
rptViewer objView = new rptViewer();
objPur.SetParameterValue("@CompanyID", txtComname.Text);
PurchaseInvoiceBL obj = new PurchaseInvoiceBL()
{
companyID = Convert.ToInt32(txtComname.Text)
};
DataTable dt = obj.SelectByCompany();
if (dt.Rows.Count > 0)
{
objPur.SetDataSource(dt);
objView.crptViewer.ReportSource = objPur;
objView.WindowState = FormWindowState.Maximized;
objView.ShowDialog();
}
else
{
MessageBox.Show("No Record Found");
}
// crptViewerPurchase.ReportSource = objPur;
}
else if (!string.IsNullOrEmpty(txtInvoice.Text))
{
PurchaseInvoiceReport objPurchase = new PurchaseInvoiceReport();
rptViewer objView = new rptViewer();
objPurchase.SetParameterValue("@PInvoice", txtInvoice.Text);
PurchaseInvoiceBL obj = new PurchaseInvoiceBL()
{
PInvoice = Convert.ToInt32(txtInvoice.Text)
};
DataTable dt = obj.Search();
if (dt.Rows.Count > 0)
{
objPurchase.SetDataSource(dt);
objView.crptViewer.ReportSource = objPurchase;
objView.WindowState = FormWindowState.Maximized;
objView.ShowDialog();
}
else
{
MessageBox.Show("No Record Found");
}
//crptViewerPurchase.ReportSource = objPurchase;
txtInvoice.Clear();
}
else
{
MessageBox.Show("Please Enter Company ID");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
PurchaseInvoiceBL objpur = new PurchaseInvoiceBL();
for (int i = 0; i < dgvProduct.Rows.Count; i++)
{
objpur.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString());
objpur.Quantity = Convert.ToInt32(dgvProduct.Rows[i].Cells[4].Value.ToString());
objpur.ProdUpdate();
}
PurchaseInvoiceBL objCtn = new PurchaseInvoiceBL();
for (int i = 0; i < dgvProduct.Rows.Count; i++)
{
objCtn.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString());
objCtn.Ctn = Convert.ToInt32(dgvProduct.Rows[i].Cells[7].Value.ToString());
objCtn.CtnUpdate();
}
PurchaseInvoiceBL objmas = new PurchaseInvoiceBL()
{
PInvoice = Convert.ToInt32(txtInvoiceID.Text),
companyID = Convert.ToInt32(txtComID.Text),
Discount = Convert.ToDecimal(txtBillDiscount.Text),
PurchaseDate = DateTime.Parse(txtPurInvoiceDate.Text),
TotalAmount = Convert.ToDecimal(txttotalAmount.Text),
Payment = Convert.ToDecimal(txtTotalPay.Text),
DuePayment = Convert.ToDecimal(txtPayDue.Text),
furDiscount = Convert.ToDecimal(txtfurDiscount.Text),
GrandTotal = Convert.ToDecimal(txtGrandTotal.Text)
};
PurchaseInvoiceBL objDet = new PurchaseInvoiceBL();
for (int i = 0; i < dgvProduct.Rows.Count; i++)
{
objDet.PInvoice = Convert.ToInt32(txtInvoiceID.Text);
objDet.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString());
objDet.TP = Convert.ToDecimal(dgvProduct.Rows[i].Cells[3].Value.ToString());
objDet.Quantity = Convert.ToInt32(dgvProduct.Rows[i].Cells[4].Value.ToString());
objDet.frieght = Convert.ToDecimal(dgvProduct.Rows[i].Cells[6].Value.ToString());
objDet.Ctn = Convert.ToDecimal(dgvProduct.Rows[i].Cells[7].Value.ToString());
objDet.Amount = Convert.ToDecimal(dgvProduct.Rows[i].Cells[8].Value.ToString());
objDet.SaveDetail();
}
objmas.SaveMaster();
PurchaseLedgerBL objLedger = new PurchaseLedgerBL();
objLedger.PInvoice = Convert.ToInt32(txtInvoiceID.Text);
objLedger.CompanyID = Convert.ToInt32(txtComID.Text);
objLedger.Credit = Convert.ToDecimal(txtPayDue.Text);
objLedger.Debit = 0;
objLedger.Date = Convert.ToDateTime(txtPurInvoiceDate.Text);
objLedger.Balance = Convert.ToDecimal(txtnewBalance.Text);
objLedger.Description = "Debit";
objLedger.save();
(new PurchaseLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CompanyID);
PurchaseInvoiceReport objretp = new PurchaseInvoiceReport();
rptViewer objView = new rptViewer();
objretp.SetParameterValue("@PInvoice", txtInvoiceID.Text);
PurchaseInvoiceBL objBl = new PurchaseInvoiceBL()
{
PInvoice = Convert.ToInt32(txtInvoiceID.Text)
};
var dt = objBl.Search();
if (dt != null)
{
objretp.SetDataSource(dt);
objView.crptViewer.ReportSource = objretp;
objView.WindowState = FormWindowState.Maximized;
objView.ShowDialog();
}
ClearForm();
ChkFrieghtOrder.Checked = false;
btnNew.Enabled = true;
}