public void Delete(SqlTransaction objSqlTransaction, PurchasesOrderDetailEL objPurchasesOrderDetailEL) { SQLHelper objSQLHelper = new SQLHelper(); int cpmpanyId = objSQLHelper.ExecuteDeleteProcedure("DeletePurchasesOrderDetail_ById", objSqlTransaction , objSQLHelper.SqlParam("@Purchase_Order_Detail_Id", objPurchasesOrderDetailEL.Purchase_Order_Detail_Id, SqlDbType.Int) ); }
public List <PurchasesOrderDetailEL> GetPurchasesOrderDetail() { PurchasesOrderDetailEL objPurchasesOrderDetailEL; List <PurchasesOrderDetailEL> lstPurchasesOrderDetailEL = new List <PurchasesOrderDetailEL>(); SQLHelper objSQLHelper = new SQLHelper(); DataTable dt = objSQLHelper.ExecuteSelectProcedure("SelectPurchasesOrderDetailAll"); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { objPurchasesOrderDetailEL = new PurchasesOrderDetailEL(); objPurchasesOrderDetailEL.Item_Name = dt.Rows[i]["Item_Name"].ToString(); objPurchasesOrderDetailEL.Item_id = (int)dt.Rows[i]["Item_id"]; objPurchasesOrderDetailEL.Item_Quantity = Convert.ToDouble(dt.Rows[i]["Item_Quantity"]); objPurchasesOrderDetailEL.Item_Rate = Convert.ToDouble(dt.Rows[i]["Item_Rate"]); objPurchasesOrderDetailEL.Purchase_Order_Detail_Id = (int)dt.Rows[i]["Purchase_Order_Detail_Id"]; objPurchasesOrderDetailEL.Purchases_Order_Id = (int)dt.Rows[i]["Purchases_Order_Id"]; objPurchasesOrderDetailEL.Total_Amount = Convert.ToDecimal(dt.Rows[i]["Total_Amount"]); lstPurchasesOrderDetailEL.Add(objPurchasesOrderDetailEL); } } return(lstPurchasesOrderDetailEL); }
private void dataGridView1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { PurchasesOrderDetailEL objPurchasesOrderDetailEL = new PurchasesOrderDetailEL(); objPurchasesOrderDetailEL.Purchase_Order_Detail_Id = Convert.ToInt32(e.Row.Cells["Purchase_Order_Detail_Id"].Value); lstDeletingPurchasesOrderDetailEL.Add(objPurchasesOrderDetailEL); e.Row.Visible = false; }
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"); } }
public void Update(SqlTransaction objSqlTransaction, PurchasesOrderDetailEL objPurchasesOrderDetailEL) { SQLHelper objSQLHelper = new SQLHelper(); int Id = objSQLHelper.ExecuteUpdateProcedure("UpdatePurchasesOrderDetail", objSqlTransaction , objSQLHelper.SqlParam("@Item_Name", objPurchasesOrderDetailEL.Item_Name, SqlDbType.NVarChar) , objSQLHelper.SqlParam("@Item_Id", objPurchasesOrderDetailEL.Item_id, SqlDbType.Int) , objSQLHelper.SqlParam("@Item_Quantity", objPurchasesOrderDetailEL.Item_Quantity, SqlDbType.Float) , objSQLHelper.SqlParam("@Item_Rate", objPurchasesOrderDetailEL.Item_Rate, SqlDbType.Float) , objSQLHelper.SqlParam("@Purchase_Order_Detail_Id", objPurchasesOrderDetailEL.Purchase_Order_Detail_Id, SqlDbType.Int) ); }
public int Insert(SqlTransaction objSqlTransaction, PurchasesOrderDetailEL objPurchasesOrderDetailEL) { SQLHelper objSQLHelper = new SQLHelper(); int Id = objSQLHelper.ExecuteInsertProcedure("InsertPurchasesOrderDetail", objSqlTransaction , objSQLHelper.SqlParam("@Item_Name", objPurchasesOrderDetailEL.Item_Name, SqlDbType.NVarChar) , objSQLHelper.SqlParam("@Item_Id", objPurchasesOrderDetailEL.Item_id, SqlDbType.Int) , objSQLHelper.SqlParam("@Item_Quantity", objPurchasesOrderDetailEL.Item_Quantity, SqlDbType.Float) , objSQLHelper.SqlParam("@Item_Rate", objPurchasesOrderDetailEL.Item_Rate, SqlDbType.Float) , objSQLHelper.SqlParam("@Purchases_Order_Id", objPurchasesOrderDetailEL.Purchases_Order_Id, SqlDbType.Int) ); return(Id); }
public void Delete(PurchasesOrderDetailEL objPurchasesOrderDetailEL) { SQLHelper objSQLHelper = new SQLHelper(); SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans(); try { Delete(objSqlTransaction, objPurchasesOrderDetailEL); objSqlTransaction.Commit(); } catch { objSqlTransaction.Rollback(); } }
public int Insert(PurchasesOrderDetailEL objPurchasesOrderDetailEL) { SQLHelper objSQLHelper = new SQLHelper(); SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans(); try { int Id = Insert(objSqlTransaction, objPurchasesOrderDetailEL); objSqlTransaction.Commit(); return(Id); } catch (Exception) { objSqlTransaction.Rollback(); throw; } }
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"); } }