private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSearch.Text))
{
MessageBox.Show("Please Enter Company id");
}
else
{
PurLedger objrpt = new PurLedger();
rptViewer objview = new rptViewer();
objrpt.SetParameterValue("@CompanyID", txtSearch.Text);
PurchaseLedgerBL objLedger = new PurchaseLedgerBL()
{
CompanyID = Convert.ToInt32(txtSearch.Text)
};
DataTable dt = objLedger.Search();
if (dt != null)
{
objrpt.SetDataSource(dt);
objview.crptViewer.ReportSource = objrpt;
objview.WindowState = FormWindowState.Normal;
objview.ShowDialog();
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtRemainID.Text))
{
PurRemainIDReport objrpt = new PurRemainIDReport();
rptViewer objView = new rptViewer();
objrpt.SetParameterValue("@RemainID", txtRemainID.Text);
PurRemainBL objBl = new PurRemainBL()
{
PRemainID = Convert.ToInt32(txtRemainID.Text)
};
var dt = objBl.SearchByRemainID();
if (dt != null)
{
objrpt.SetDataSource(dt);
objView.crptViewer.ReportSource = objrpt;
objView.WindowState = FormWindowState.Maximized;
objView.ShowDialog();
}
else
{
MessageBox.Show("No Record Found");
}
//crptViewerRemain.ReportSource = objrpt;
}
else if (!string.IsNullOrEmpty(txtComID.Text))
{
PurLedger objrpt = new PurLedger();
rptViewer objview = new rptViewer();
objrpt.SetParameterValue("@CompanyID", txtComID.Text);
PurchaseLedgerBL objLedger = new PurchaseLedgerBL()
{
CompanyID = Convert.ToInt32(txtComID.Text)
};
DataTable dt = objLedger.Search();
if (dt != null)
{
objrpt.SetDataSource(dt);
objview.crptViewer.ReportSource = objrpt;
objview.WindowState = FormWindowState.Maximized;
objview.ShowDialog();
}
else
{
MessageBox.Show("No Record Found");
}
//crptViewerRemain.ReportSource = objCom;
}
else
{
MessageBox.Show("Please Enter Company ID Or Remaining ID");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
PurRemainBL objPur = new PurRemainBL()
{
CompanyID = Convert.ToInt32(txtComID.Text),
Date = Convert.ToDateTime(txtDate.Text),
ReturnCash = Convert.ToDecimal(txtReturnCash.Text)
};
objPur.Save();
PurchaseLedgerBL objLedger = new PurchaseLedgerBL();
if (string.IsNullOrEmpty(txtDescription.Text))
{
objLedger.PRemainID = Convert.ToInt32(txtRemainID.Text);
objLedger.CompanyID = Convert.ToInt32(txtComID.Text);
objLedger.Credit = 0;
objLedger.Debit = Convert.ToDecimal(txtReturnCash.Text);
objLedger.Date = Convert.ToDateTime(txtDate.Text);
objLedger.Balance = Convert.ToDecimal(txtNewBalance.Text);
objLedger.Description = "Credit";
}
else
{
objLedger.PRemainID = Convert.ToInt32(txtRemainID.Text);
objLedger.CompanyID = Convert.ToInt32(txtComID.Text);
objLedger.Credit = 0;
objLedger.Debit = Convert.ToDecimal(txtReturnCash.Text);
objLedger.Date = Convert.ToDateTime(txtDate.Text);
objLedger.Balance = Convert.ToDecimal(txtNewBalance.Text);
objLedger.Description = txtDescription.Text;
}
objLedger.save();
(new PurchaseLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CompanyID);
MessageBox.Show("Payment Paid " + txtReturnCash.Text);
PurRemainIDReport objrpt = new PurRemainIDReport();
objrpt.SetParameterValue("@RemainID", txtRemainID.Text);
rptViewer objView = new rptViewer();
objView.crptViewer.ReportSource = objrpt;
objView.WindowState = FormWindowState.Normal;
objView.ShowDialog();
ClearGroup();
}
private void btnSearch_Click(object sender, EventArgs e)
{
PurchaseLedgerBL objLedger = new PurchaseLedgerBL()
{
CompanyID = Convert.ToInt32(txtSearch.Text)
};
var dt = objLedger.search();
if (dt != null)
{
dgvCompany.DataSource = dt;
this.dgvCompany.Columns["PTid"].Visible = false;
}
else
{
MessageBox.Show("No Record Found " + txtSearch.Text);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
decimal preBal = Convert.ToDecimal(txtPreBal.Text);
if (FormValidate() == true)
{
CompanyBL objCom = new CompanyBL()
{
CompanyName = txtComName.Text,
Email = txtEmail.Text,
Contact = txtContact.Text,
Address = txtAddress.Text,
DuePayment = Convert.ToDecimal(txtPreBal.Text)
};
if (preBal > 0)
{
PurchaseLedgerBL objBl = new PurchaseLedgerBL()
{
CompanyID = Convert.ToInt32(txtComID.Text),
Debit = Convert.ToDecimal(txtPreBal.Text),
Credit = 0,
Date = Convert.ToDateTime(DateTime.Now.ToShortDateString()),
Balance = Convert.ToDecimal(txtPreBal.Text),
Description = "Opening Balance"
};
objBl.save();
}
objCom.Save();
MessageBox.Show("Record Saved Successfull");
LoadData();
btnAddnew.Enabled = true;
ClearGroup();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
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)
{
PurchaseReturnBL objUpdate = new PurchaseReturnBL();
{
for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
{
objUpdate.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString());
objUpdate.Quantity = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[5].Value.ToString());
objUpdate.ProdUpdate();
}
}
PurchaseReturnBL objCtn = new PurchaseReturnBL();
{
for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
{
objCtn.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString());
objCtn.Ctn = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[4].Value.ToString());
objCtn.CtnUpdate();
}
}
PurchaseReturnBL objDetail = new PurchaseReturnBL();
{
for (int i = 0; i < dgvReturnItem.Rows.Count; i++)
{
objDetail.PReturnID = Convert.ToInt32(txtReturnID.Text);
objDetail.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString());
objDetail.TP = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[3].Value.ToString());
objDetail.Ctn = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[4].Value.ToString());
objDetail.Quantity = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[5].Value.ToString());
objDetail.Amount = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[6].Value.ToString());
objDetail.SaveDetail();
}
}
if (txtBalance.Text != "0.00")
{
PurRemainBL objPurc = new PurRemainBL()
{
CompanyID = Convert.ToInt32(txtComID.Text),
ReturnCash = Convert.ToDecimal(txtBalance.Text),
Date = Convert.ToDateTime(txtReturnDate.Text),
PReturnID = Convert.ToInt32(txtReturnID.Text)
};
objPurc.Save();
}
PurchaseReturnBL objMas = new PurchaseReturnBL()
{
PInvoice = Convert.ToInt32(txtInvoiceID.Text),
CompanyID = Convert.ToInt32(txtComID.Text),
Discount = Convert.ToDecimal(txtBillDiscount.Text),
ReturnDate = DateTime.Parse(txtReturnDate.Text),
TotalAmount = Convert.ToDecimal(txtGrandTotal.Text),
ReturnCash = Convert.ToDecimal(txtReturnCash.Text),
DuePayment = Convert.ToDecimal(txtBalance.Text),
furDiscount = Convert.ToDecimal(txtfurDiscount.Text),
GrandTotal = Convert.ToDecimal(txtGrandTotal.Text)
};
objMas.SaveMaster();
PurchaseLedgerBL objLedger = new PurchaseLedgerBL();
objLedger.PReturnID = Convert.ToInt32(txtReturnID.Text);
objLedger.CompanyID = Convert.ToInt32(txtComID.Text);
objLedger.Credit = 0;
objLedger.Debit = Convert.ToDecimal(txtBalance.Text);
objLedger.Date = Convert.ToDateTime(txtReturnDate.Text);
objLedger.Balance = Convert.ToDecimal(txtNewBalance.Text);
objLedger.Description = "Credit";
objLedger.save();
(new PurchaseLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CompanyID);
ClearForm();
btnNew.Enabled = true;
// DesignClear(this);
}
