private void btnSearch_Click(object sender, EventArgs e)
{
PurchaseGeneralReport objPur = new PurchaseGeneralReport();
rptViewer objView = new rptViewer();
objPur.SetParameterValue("@mindate", txtMinDate.Value);
objPur.SetParameterValue("@maxdate", txtmaxdate.Value);
PurchaseInvoiceBL obj = new PurchaseInvoiceBL()
{
mindate = Convert.ToDateTime(txtMinDate.Value),
maxdate = Convert.ToDateTime(txtmaxdate.Value)
};
DataTable dt = obj.SelectByDate();
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;
}
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 btnNew_Click(object sender, EventArgs e)
{
PurchaseInvoiceBL objPur = new PurchaseInvoiceBL();
DataTable dt = objPur.Addnew();
if (dt.Rows.Count > 0)
{
txtInvoiceID.Text = Convert.ToString(dt.Rows[0]["PInvoice"]);
FormEnable();
LoadComp();
LoadProd();
LoadGridProd();
txtCompanyName.Focus();
btnNew.Enabled = false;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
PurchaseInvoiceBL objPur = new PurchaseInvoiceBL()
{
PInvoice = Convert.ToInt32(txtInvoiceID.Text)
};
var dt = objPur.Search();
dgvProduct.Columns.Clear();
if (dt != null && dt.Rows.Count > 0)
{
DataGridViewImageColumn edit = new DataGridViewImageColumn();
edit.Image = Properties.Resources.edit;
edit.ImageLayout = DataGridViewImageCellLayout.Zoom;
edit.HeaderText = "Edit";
edit.Width = 40;
dgvProduct.Columns.Add(edit);
dgvProduct.DataSource = dt;
this.dgvProduct.Columns["Sr#"].Visible = false;
this.dgvProduct.Columns["InvoiceNo"].Visible = false;
this.dgvProduct.Columns["Date"].Visible = false;
this.dgvProduct.Columns["CompanyID"].Visible = false;
this.dgvProduct.Columns["ProductID"].Visible = false;
this.dgvProduct.Columns["New Balance"].Visible = false;
this.dgvProduct.Columns["Contact"].Visible = false;
this.dgvProduct.Columns["GrandTotal"].Visible = false;
this.dgvProduct.Columns["Balance"].Visible = false;
this.dgvProduct.Columns["Payment"].Visible = false;
this.dgvProduct.Columns["Distribution Margin"].Visible = false;
this.dgvProduct.Columns["FurDiscount"].Visible = false;
this.dgvProduct.Columns["TotalAmount"].Visible = false;
dgvProduct.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
else
{
MessageBox.Show("No Record Against Invoice No '" + txtInvoiceID.Text + "' ");
}
}
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;
}
private void btnSave_Click(object sender, EventArgs e)
{
ReturnSaleBL objMas = new ReturnSaleBL()
{
Invoiceno = Convert.ToInt32(txtInvoiceID.Text),
ReturnAmount = Convert.ToDecimal(txtBalance.Text),
ReturnDate = DateTime.Parse(txtReturnDate.Text),
TotalBill = Convert.ToDecimal(txtTotalBill.Text),
ReturnCash = Convert.ToDecimal(txtReturnCash.Text),
CustomerID = Convert.ToInt32(txtCusID.Text)
};
ReturnSaleBL objDetail = new ReturnSaleBL();
for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
{
objDetail.RInvoice = Convert.ToInt32(txtReturnID.Text);
objDetail.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[2].Value.ToString());
objDetail.RP = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[4].Value.ToString());
objDetail.Ctn = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[5].Value.ToString());
objDetail.Quantity = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[6].Value.ToString());
objDetail.Discount = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[7].Value.ToString());
objDetail.Amount = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[8].Value.ToString());
objDetail.SaveDetail();
}
PurchaseInvoiceBL objPur = new PurchaseInvoiceBL();
for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
{
objPur.ProductID = Convert.ToInt32(dgvReturnItem.Rows[0].Cells[2].Value.ToString());
objPur.Quantity = Convert.ToInt32(dgvReturnItem.Rows[0].Cells[6].Value.ToString());
objPur.ProdUpdate();
}
PurchaseInvoiceBL objCtn = new PurchaseInvoiceBL();
for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
{
objCtn.ProductID = Convert.ToInt32(dgvReturnItem.Rows[0].Cells[2].Value.ToString());
objCtn.Ctn = Convert.ToInt32(dgvReturnItem.Rows[0].Cells[5].Value.ToString());
objCtn.CtnUpdate();
}
SaleLedgerBL objLedger = new SaleLedgerBL();
objLedger.RInvoice = Convert.ToInt32(txtReturnID.Text);
objLedger.CustomerID = Convert.ToInt32(txtCusID.Text);
objLedger.Debit = Convert.ToDecimal(txtBalance.Text);
objLedger.Credit = 0;
objLedger.Date = Convert.ToDateTime(txtReturnDate.Text);
objLedger.Balance = Convert.ToDecimal(txtnewBalance.Text);
objLedger.Description = "Debit";
objLedger.Save();
(new SaleLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CustomerID);
//ReturnSaleBL objDue = new ReturnSaleBL()
//{
// CustomerID = Convert.ToInt32(txtCusID.Text),
// DuePayment = Convert.ToDecimal(txtBalance.Text)
//};
//objDue.UpdateDueSub();
if (txtBalance.Text != "0.00")
{
SaleRecoveryBL objRec = new SaleRecoveryBL()
{
CustomerID = Convert.ToInt32(txtCusID.Text),
RecoveryDate = Convert.ToDateTime(txtReturnDate.Text),
RInvoice = Convert.ToInt32(txtReturnID.Text),
ReturnCash = Convert.ToDecimal(txtBalance.Text)
};
objRec.Save();
}
objMas.SaveMaster();
SaleReturnReport objRep = new SaleReturnReport();
rptViewer objView = new rptViewer();
objRep.SetParameterValue("@RinvoiceNo", txtReturnID.Text);
ReturnSaleBL obj = new ReturnSaleBL()
{
RInvoice = Convert.ToInt32(txtReturnID.Text)
};
DataTable dt = obj.Select();
if (dt.Rows.Count > 0)
{
objRep.SetDataSource(dt);
}
objView.crptViewer.ReportSource = objRep;
objView.WindowState = FormWindowState.Normal;
objView.ShowDialog();
ClearForm();
btnNew.Enabled = true;
}
