void GridBind()
{
//dtDeletingPurchassOrderDetail.Rows.Clear();
dataGridView1.Rows.Clear();
BindControl();
try
{
int PurchasesOrderId = SelectedPurchasesOrder.Purchases_Order_Id; //Convert.ToInt32(ListPurchaseOrder.SelectedValue);
textPuchasesOrderNo.Text = SelectedPurchasesOrder.Purchases_Order_No;
dateTimePickerPurchasesOrderDate.Value = SelectedPurchasesOrder.Date;
PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL();
List <PurchasesOrderDetailEL> lstPurchasesOrderDetail = objPurchasesOrderDetailDL.GetPurchasesOrderDetailByOrderId(PurchasesOrderId);
//dataGridView1.DataSource = dt;
for (int i = 0; i < lstPurchasesOrderDetail.Count; i++)
{
dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells["Purchase_Order_Detail_Id"].Value = lstPurchasesOrderDetail[i].Purchase_Order_Detail_Id;
//dataGridView1.Rows[i].Cells["Item_Name"].Value = lstPurchasesOrderDetail[i].Item_Name;
dataGridView1.Rows[i].Cells["ItemName"].Value = lstPurchasesOrderDetail[i].Item_id;
dataGridView1.Rows[i].Cells["Item_Quantity"].Value = lstPurchasesOrderDetail[i].Item_Quantity;
dataGridView1.Rows[i].Cells["Item_Rate"].Value = lstPurchasesOrderDetail[i].Item_Rate;
dataGridView1.Rows[i].Cells["Total_Amount"].Value = lstPurchasesOrderDetail[i].Total_Amount;
}
}
catch
{
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
string str = MessageBox.Show("Are you want to delete this Company", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning).ToString();
if (str.Equals("Yes"))
{
SQLHelper objSQLHelper = new SQLHelper();
SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans();
try
{
PurchaseOrderDL objPurchasesOrderDL = new PurchaseOrderDL();
List <PurchasesOrderDetailEL> lstPurchasesOrderDetailEL = new List <PurchasesOrderDetailEL>();
PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL();
int PurchasesOrderId = SelectedPurchasesOrder.Purchases_Order_Id;
lstPurchasesOrderDetailEL = objPurchasesOrderDetailDL.GetPurchasesOrderDetailByOrderId(PurchasesOrderId);
lstPurchasesOrderDetailEL.ForEach(r => objPurchasesOrderDetailDL.Delete(objSqlTransaction, r));
objPurchasesOrderDL.Delete(objSqlTransaction, SelectedPurchasesOrder);
objSqlTransaction.Commit();
Common.MessageDelete();
FillListBox();
ControlClear();
}
catch
{
objSqlTransaction.Rollback();
}
}
}
private void GetGlobalVariableData()
{
BillingDelivertDetailDL objBillingDelivertDetailDL = new BillingDelivertDetailDL();
lstBillingDelivertDetail = objBillingDelivertDetailDL.GetBillingDelivertDetail(companyEL);
PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL();
lstPurchasesOrderDetail = objPurchasesOrderDetailDL.GetPurchasesOrderDetail();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (textPuchasesOrderNo.Text.Trim() == "")
{
Common.MessageAlert("First enter Purchases Order No");
return;
}
if (dataGridView1.Rows.Count - 1 <= 0)
{
Common.MessageAlert("First Enter Item Detail");
return;
}
SQLHelper objSQLHelper = new SQLHelper();
SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans();
try
{
PurchaseOrderEL objPurchaseOrderEL = new PurchaseOrderEL();
PurchaseOrderDL objPurchasesOrderDL = new PurchaseOrderDL();
PurchasesOrderDetailEL objPurchasesOrderDetailEL;
List <PurchasesOrderDetailEL> lstPurchasesOrderDetailEL = new List <PurchasesOrderDetailEL>();
PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL();
objPurchaseOrderEL.Company_id = companyEL.Company_id;
objPurchaseOrderEL.Date = dateTimePickerPurchasesOrderDate.Value;
objPurchaseOrderEL.Purchases_Order_No = textPuchasesOrderNo.Text.Trim();
int PurchaseOrderId = objPurchasesOrderDL.Insert(objSqlTransaction, objPurchaseOrderEL);
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
objPurchasesOrderDetailEL = new PurchasesOrderDetailEL();
//objPurchasesOrderDetailEL.Item_Name = dataGridView1.Rows[i].Cells["Item_Name"].Value.ToString().Trim();
objPurchasesOrderDetailEL.Item_id = Convert.ToInt32(dataGridView1.Rows[i].Cells["ItemName"].Value);
objPurchasesOrderDetailEL.Item_Quantity = Convert.ToDouble(dataGridView1.Rows[i].Cells["Item_Quantity"].Value);
objPurchasesOrderDetailEL.Item_Rate = Convert.ToDouble(dataGridView1.Rows[i].Cells["Item_Rate"].Value);
objPurchasesOrderDetailEL.Purchases_Order_Id = PurchaseOrderId;
lstPurchasesOrderDetailEL.Add(objPurchasesOrderDetailEL);
}
lstPurchasesOrderDetailEL.ForEach(r => objPurchasesOrderDetailDL.Insert(objSqlTransaction, r));
objSqlTransaction.Commit();
Common.MessageSave();
FillListBox();
ControlClear();
}
catch
{
objSqlTransaction.Rollback();
Common.MessageAlert("First enter data in correct format");
}
}
void CreateReport()
{
//DisposeReport();
try
{
PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL();
DataSet ds = objPurchasesOrderDetailDL.GetPurchasesBillReportData(CompanyId, PurchasesOrderId);
objRpt = new PurchasesBill();
objRpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = objRpt;
}
catch
{
}
}
void GridBind()
{
//dtDeletingPurchassOrderDetail.Rows.Clear();
dataGridView1.Rows.Clear();
BindControl();
try
{
int PurchasesOrderId = SelectedPurchasesOrder.Purchases_Order_Id; //Convert.ToInt32(ListPurchaseOrder.SelectedValue);
textPuchasesOrderNo.Text = SelectedPurchasesOrder.Purchases_Order_No;
dateTimePickerPurchasesOrderDate.Value = SelectedPurchasesOrder.Date;
textTax.Text = SelectedPurchasesOrder.Tax_Percentage.ToString();
txtOtherAmount.Text = SelectedPurchasesOrder.Other_Amount.ToString();
txtRequisitioner.Text = SelectedPurchasesOrder.Requisitioner.ToString();
txtCreditTerm.Text = SelectedPurchasesOrder.Credit_Term.ToString();
txtShippingTerm.Text = SelectedPurchasesOrder.Shipping_Term.ToString();
txtComments.Text = SelectedPurchasesOrder.Comments.ToString();
PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL();
List <PurchasesOrderDetailEL> lstPurchasesOrderDetail = objPurchasesOrderDetailDL.GetPurchasesOrderDetailByOrderId(PurchasesOrderId);
//dataGridView1.DataSource = dt;
for (int i = 0; i < lstPurchasesOrderDetail.Count; i++)
{
dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells["Purchase_Order_Detail_Id"].Value = lstPurchasesOrderDetail[i].Purchase_Order_Detail_Id;
//dataGridView1.Rows[i].Cells["Item_Name"].Value = lstPurchasesOrderDetail[i].Item_Name;
dataGridView1.Rows[i].Cells["ItemName"].Value = lstPurchasesOrderDetail[i].Item_id;
dataGridView1.Rows[i].Cells["Item_Quantity"].Value = lstPurchasesOrderDetail[i].Item_Quantity;
dataGridView1.Rows[i].Cells["Item_Rate"].Value = lstPurchasesOrderDetail[i].Item_Rate;
dataGridView1.Rows[i].Cells["Item_Unit"].Value = lstPurchasesOrderDetail[i].Item_Unit;
dataGridView1.Rows[i].Cells["Total_Amount"].Value = lstPurchasesOrderDetail[i].Total_Amount;
}
}
catch
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//if ((string.IsNullOrEmpty( textPuchasesOrderNo.Text.Trim())))
//{
// Common.MessageAlert("First enter Purchases Order No");
// return;
//}
decimal result;
if (string.IsNullOrEmpty(textTax.Text.Trim()) || !decimal.TryParse(textTax.Text, out result))
{
Common.MessageAlert("First enter Tax Percentage");
return;
}
if (dataGridView1.Rows.Count - 1 <= 0)
{
Common.MessageAlert("First Enter Item Detail");
return;
}
SQLHelper objSQLHelper = new SQLHelper();
SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans();
try
{
PurchaseOrderEL objPurchaseOrderEL = new PurchaseOrderEL();
PurchaseOrderDL objPurchasesOrderDL = new PurchaseOrderDL();
PurchasesOrderDetailEL objPurchasesOrderDetailEL;
List <PurchasesOrderDetailEL> lstPurchasesOrderDetailEL = new List <PurchasesOrderDetailEL>();
PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL();
objPurchaseOrderEL.Company_id = SelectedCompany.Company_id;
objPurchaseOrderEL.Date = dateTimePickerPurchasesOrderDate.Value;
objPurchaseOrderEL.Tax_Percentage = Convert.ToDecimal(textTax.Text);
if (string.IsNullOrEmpty(txtOtherAmount.Text.Trim()))
{
objPurchaseOrderEL.Other_Amount = 0;
}
else
{
objPurchaseOrderEL.Other_Amount = Convert.ToDecimal(txtOtherAmount.Text);
}
objPurchaseOrderEL.Requisitioner = txtRequisitioner.Text;
objPurchaseOrderEL.Credit_Term = txtCreditTerm.Text;
objPurchaseOrderEL.Shipping_Term = txtShippingTerm.Text;
objPurchaseOrderEL.Comments = txtComments.Text;
objPurchaseOrderEL.Purchases_Order_No = textPuchasesOrderNo.Text.Trim();
int PurchaseOrderId = objPurchasesOrderDL.Insert(objSqlTransaction, objPurchaseOrderEL);
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
objPurchasesOrderDetailEL = new PurchasesOrderDetailEL();
//objPurchasesOrderDetailEL.Item_Name = dataGridView1.Rows[i].Cells["Item_Name"].Value.ToString().Trim();
objPurchasesOrderDetailEL.Item_id = Convert.ToInt32(dataGridView1.Rows[i].Cells["ItemName"].Value);
objPurchasesOrderDetailEL.Item_Quantity = Convert.ToDouble(dataGridView1.Rows[i].Cells["Item_Quantity"].Value);
objPurchasesOrderDetailEL.Item_Rate = Convert.ToDouble(dataGridView1.Rows[i].Cells["Item_Rate"].Value);
objPurchasesOrderDetailEL.Item_Unit = dataGridView1.Rows[i].Cells["Item_Unit"].Value.ToString();
objPurchasesOrderDetailEL.Purchases_Order_Id = PurchaseOrderId;
lstPurchasesOrderDetailEL.Add(objPurchasesOrderDetailEL);
}
lstPurchasesOrderDetailEL.ForEach(r => objPurchasesOrderDetailDL.Insert(objSqlTransaction, r));
objSqlTransaction.Commit();
Common.MessageSave();
FillListBox();
ControlClear();
}
catch
{
objSqlTransaction.Rollback();
Common.MessageAlert("First enter data in correct format");
}
}
