public BillItemNarration(BillItemEL objBillItemEL) : this() { _BillItemEL = objBillItemEL; lbItemName.Text = _BillItemEL.Item_Name; GridBind(); }
public List <BillItemEL> GetBillItemBy_ParentId(int Parent_Id) { BillItemEL objBillItemEL; List <BillItemEL> lstBillItemEL = new List <BillItemEL>(); SQLHelper objSQLHelper = new SQLHelper(); DataTable dt = objSQLHelper.ExecuteSelectProcedure("GetBillItemBy_ParentId" , objSQLHelper.SqlParam("@Parent_Id", Parent_Id, SqlDbType.Int) ); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { objBillItemEL = new BillItemEL(); objBillItemEL.Bill_Id = (int)dt.Rows[i]["Bill_Id"]; objBillItemEL.Item_Name = dt.Rows[i]["ItemName"].ToString(); objBillItemEL.Item_Id = Convert.ToInt32(dt.Rows[i]["Item_Id"]); objBillItemEL.Bill_Item_Id = (int)dt.Rows[i]["Bill_Item_Id"]; objBillItemEL.Purchase_Order_Detail_Id = dt.Rows[i]["Purchase_Order_Detail_Id"].GetType() == typeof(DBNull) ? (int?)null : Convert.ToInt32(dt.Rows[i]["Purchase_Order_Detail_Id"]); objBillItemEL.Color = (int)dt.Rows[i]["Color"]; objBillItemEL.Form = Convert.ToDecimal(dt.Rows[i]["Form"]); objBillItemEL.Quantity = Convert.ToDouble(dt.Rows[i]["Quantity"].ToString()); objBillItemEL.Rate = Convert.ToDecimal(dt.Rows[i]["Rate"]); objBillItemEL.Parent_Id = dt.Rows[i]["Parent_Id"].GetType() == typeof(DBNull) ? (int?)null : Convert.ToInt32(dt.Rows[i]["Parent_Id"]); lstBillItemEL.Add(objBillItemEL); } } return(lstBillItemEL); }
public void Delete(SqlTransaction objSqlTransaction, BillItemEL objBillItemEL) { SQLHelper objSQLHelper = new SQLHelper(); int cpmpanyId = objSQLHelper.ExecuteDeleteProcedure("DeleteBilllItem", objSqlTransaction , objSQLHelper.SqlParam("@Bill_Item_Id", objBillItemEL.Bill_Item_Id, SqlDbType.Decimal) ); }
public Bill_SubItem(BillItemEL _BillItemEL, CompanyEL _CompanyEL) : this() { this._BillParentItem = _BillItemEL; this.CompanyEL = _CompanyEL; GridBind(); bindGridComboBox(); }
public void Update(SqlTransaction objSqlTransaction, BillItemEL objBillItemEL) { SQLHelper objSQLHelper = new SQLHelper(); objSQLHelper.ExecuteUpdateProcedure("UpdateBilllItem", objSqlTransaction , objSQLHelper.SqlParam("@Item_Name", objBillItemEL.Item_Name, SqlDbType.NVarChar) , objSQLHelper.SqlParam("@Item_Id", objBillItemEL.Item_Id, SqlDbType.Int) , objSQLHelper.SqlParam("@Color", objBillItemEL.Color, SqlDbType.Int) , objSQLHelper.SqlParam("@Form", objBillItemEL.Form, SqlDbType.Decimal) , objSQLHelper.SqlParam("@Quantity", objBillItemEL.Quantity, SqlDbType.Float) , objSQLHelper.SqlParam("@Rate", objBillItemEL.Rate, SqlDbType.Decimal) , objSQLHelper.SqlParam("@Bill_Item_Id", objBillItemEL.Bill_Item_Id, SqlDbType.Decimal) ); }
private void dataGridView1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { if (e.Row.Cells["Bill_Item_Id"].Value != null) { int BillItemId; if (int.TryParse(e.Row.Cells["Bill_Item_Id"].Value.ToString(), out BillItemId)) { BillItemEL _BillItemEL = new BillItemEL(); _BillItemEL.Bill_Item_Id = BillItemId; DeletedlstBillItem.Add(_BillItemEL); } } e.Row.Visible = false; }
public bool Delete(BillItemEL objBillItemEL) { SQLHelper objSQLHelper = new SQLHelper(); SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans(); try { Delete(objSqlTransaction, objBillItemEL); objSqlTransaction.Commit(); return(true); } catch { objSqlTransaction.Rollback(); return(false); } }
public int Insert(BillItemEL objBillItemEL) { SQLHelper objSQLHelper = new SQLHelper(); SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans(); try { int id = Insert(objSqlTransaction, objBillItemEL); objSqlTransaction.Commit(); return(id); } catch (Exception) { objSqlTransaction.Rollback(); throw; } }
public int Insert(SqlTransaction objSqlTransaction, BillItemEL objBillItemEL) { SQLHelper objSQLHelper = new SQLHelper(); int Id = objSQLHelper.ExecuteInsertProcedure("InsertBillItem", objSqlTransaction , objSQLHelper.SqlParam("@Bill_Id", objBillItemEL.Bill_Id, SqlDbType.Int) , objSQLHelper.SqlParam("@Item_Name", objBillItemEL.Item_Name, SqlDbType.NVarChar) , objSQLHelper.SqlParam("@Item_Id", objBillItemEL.Item_Id, SqlDbType.Int) , objSQLHelper.SqlParam("@Color", objBillItemEL.Color, SqlDbType.Int) , objSQLHelper.SqlParam("@Form", objBillItemEL.Form, SqlDbType.Decimal) , objSQLHelper.SqlParam("@Purchase_Order_Detail_Id", objBillItemEL.Purchase_Order_Detail_Id, SqlDbType.Float) , objSQLHelper.SqlParam("@Quantity", objBillItemEL.Quantity, SqlDbType.Float) , objSQLHelper.SqlParam("@Rate", objBillItemEL.Rate, SqlDbType.Decimal) , objSQLHelper.SqlParam("@Parent_Id", objBillItemEL.Parent_Id, SqlDbType.Int) ); return(Id); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == 7) { if (dataGridView1.SelectedCells[0].OwningRow.Cells["Bill_Item_Id"].Value == null) { Common.MessageAlert("First Save This Item "); return; } BillItemEL _BillItemEL = new BillItemEL(); _BillItemEL.Bill_Item_Id = Convert.ToInt32(dataGridView1.SelectedCells[0].OwningRow.Cells["Bill_Item_Id"].Value); _BillItemEL.Item_Name = dataGridView1.SelectedCells[0].OwningRow.Cells["ItemName"].FormattedValue.ToString(); BillItemNarration objBillItemNarration = new BillItemNarration(_BillItemEL); objBillItemNarration.ShowDialog(); } } catch (Exception ex) { } }
private void btnSave_Click(object sender, EventArgs e) { { BillItemEL _BillItemEL; BillItemDL _BillItemDL = new BillItemDL(); List <BillItemEL> lstBillItem = new List <BillItemEL>(); try { for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { _BillItemEL = new BillItemEL(); _BillItemEL.Bill_Id = _BillParentItem.Bill_Id; _BillItemEL.Purchase_Order_Detail_Id = null; _BillItemEL.Form = Convert.ToDecimal(dataGridView1.Rows[i].Cells["Form"].Value); _BillItemEL.Color = Convert.ToInt32(dataGridView1.Rows[i].Cells["Color"].Value); _BillItemEL.Rate = Convert.ToDecimal(dataGridView1.Rows[i].Cells["Rate"].Value); _BillItemEL.Quantity = Convert.ToDouble(dataGridView1.Rows[i].Cells["Quantity"].Value); //_BillItemEL.Item_Name = dataGridView1.Rows[i].Cells["Bill_Item_Name"].Value.ToString(); _BillItemEL.Item_Id = Convert.ToInt32(dataGridView1.Rows[i].Cells["ItemName"].Value); _BillItemEL.Parent_Id = _BillParentItem.Bill_Item_Id; if ((dataGridView1.Rows[i].Cells["Bill_Item_Id"].Value != null)) { _BillItemEL.Bill_Item_Id = Convert.ToInt32(dataGridView1.Rows[i].Cells["Bill_Item_Id"].Value);; } else { _BillItemEL.Bill_Item_Id = 0; } lstBillItem.Add(_BillItemEL); } } catch (Exception) { } SQLHelper _SQLHelper = new SQLHelper(); SqlTransaction transaction = _SQLHelper.BeginTrans(); try { for (int i = 0; i < lstBillItem.Count; i++) { if (lstBillItem[i].Bill_Item_Id == 0) { _BillItemDL.Insert(transaction, lstBillItem[i]); } else { _BillItemDL.Update(transaction, lstBillItem[i]); } } BillItemNarrationDL _BillItemNarrationDL = new BillItemNarrationDL(); List <BillItemNarrationEL> lstBillItemNarrationEL = new List <BillItemNarrationEL>(); DeletedlstBillItem.ForEach(r => lstBillItemNarrationEL.AddRange(_BillItemNarrationDL.GetBillItemNarrationBy_BillItemId(r.Bill_Item_Id))); lstBillItemNarrationEL.ForEach(n => _BillItemNarrationDL.Delete(transaction, n)); DeletedlstBillItem.ForEach(r => _BillItemDL.Delete(transaction, r)); transaction.Commit(); Common.MessageSave(); GridBind(); } catch (Exception) { transaction.Rollback(); } } }