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();
}
}
}
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
{
}
}
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
{
}
}
