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