void ManageSalesOrderItem()
{
objSalesOrderItem = new Store.SalesOrderItem.BusinessObject.SalesOrderItem();
oblSalesOrderItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objSalesOrderItem.SaleOrderItemID = Convert.ToInt32(txtSalesOrderId.Text);
}
else
{
objSalesOrderItem.SaleOrderItemID = 0;
}
objSalesOrderItem.SalesOrderID = Convert.ToInt32(ddlSalesOrderId.SelectedItem.Value);
objSalesOrderItem.ItemId = Convert.ToInt32(ddlItemId.SelectedItem.Value);
objSalesOrderItem.ItemUnit = Convert.ToString(txtItemUnit.Text);
objSalesOrderItem.Description = Convert.ToString(txtDescription.Text);
objSalesOrderItem.ItemCostPrice = Convert.ToDecimal(txtItemCostPrice.Text);
objSalesOrderItem.ItemSalePrice = Convert.ToDecimal(txtItemSalePrice.Text);
objSalesOrderItem.ItemDiscountPercentage = Convert.ToDecimal(txtItemDiscountPercentage.Text);
objSalesOrderItem.ItemDiscount = Convert.ToDecimal(txtItemDiscount.Text);
if (cbIsActive.Checked)
{
objSalesOrderItem.IsActive = 1;
}
else
{
objSalesOrderItem.IsActive = 0;
}
objSalesOrderItem.CreatedBy = 1;
objMessageInfo = oblSalesOrderItem.ManageItemMaster(objSalesOrderItem, cmdMode);
}
catch (Exception ex)
{
}
finally
{
objSalesOrderItem = null;
//objMessageInfo = null;
oblSalesOrderItem = null;
}
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
try
{
string transid = "";
transid = insertSalesOrder(txtCPSubTotal.Text, txtSPSubTotal.Text, txtDicPre.Text, txtDic.Text, txtTax.Text, txtSHC.Text, txtMiscCost.Text, txttotal.Text);
objSalesOrderItemList = new Store.SalesOrderItem.BusinessObject.SalesOrderItemList();
for (int i = 0; i < Gridview1.Rows.Count - 1; i++)
{
objsalesOrderItem = new Store.SalesOrderItem.BusinessObject.SalesOrderItem();
TextBox txtItemNames = (TextBox)Gridview1.Rows[i].FindControl("txtItemName");
if (txtItemNames.Text == "")
{
break;
}
TextBox txtDecs = (TextBox)Gridview1.Rows[i].FindControl("txtDec");
TextBox txtCPrices = (TextBox)Gridview1.Rows[i].FindControl("txtCPrice");
TextBox txtSPrices = (TextBox)Gridview1.Rows[i].FindControl("txtSPrice");
TextBox txtDisPres = (TextBox)Gridview1.Rows[i].FindControl("txtDisPre");
TextBox txtDiss = (TextBox)Gridview1.Rows[i].FindControl("txtDis");
TextBox txtQuts = (TextBox)Gridview1.Rows[i].FindControl("txtQut");
TextBox txtTotals = (TextBox)Gridview1.Rows[i].FindControl("txtTotal");
objsalesOrderItem.ItemPrefix = txtItemNames.Text;
objsalesOrderItem.Description = txtDecs.Text;
objsalesOrderItem.ItemCostPrice = Convert.ToDecimal(txtCPrices.Text);
objsalesOrderItem.ItemSalePrice = Convert.ToDecimal(txtSPrices.Text);
objsalesOrderItem.ItemDiscountPercentage = Convert.ToDecimal(txtDisPres.Text);
objsalesOrderItem.ItemDiscount = Convert.ToDecimal(txtDiss.Text);
objsalesOrderItem.ItemUnit = txtQuts.Text;
objsalesOrderItem.TotalPrice = Convert.ToDecimal(txtTotals.Text);
objsalesOrderItem.SalesOrderID = Convert.ToInt32(transid);
//objPurchaseOrderItemList.Add(objPurchaseOrderItem);
objSalesOrderItemList.Add(objsalesOrderItem);
}
oblSalesOrderItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
objMessageInfo = oblSalesOrderItem.ManageItemMaster(objSalesOrderItemList, cmdMode);
reset();
}
catch (Exception ex)
{ Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SaleOrder).FullName, 1); }
}
public string insertItem(string name, string description, string pricec, string prices, string discountper, string discount, string quantity, string transId)
{
Store.SalesOrderItem.BusinessLogic.SalesOrderItem oblSalesOrderItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
Store.SalesOrderItem.BusinessObject.SalesOrderItem objSalesOrderItem = new Store.SalesOrderItem.BusinessObject.SalesOrderItem();
Store.SalesOrder.BusinessLogic.SalesOrder oblSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder();
Store.Common.MessageInfo objMessageInfo = new MessageInfo();
objSalesOrderItem.SaleOrderItemID = 0;
objSalesOrderItem.SalesOrderID = Convert.ToInt32(transId);
objSalesOrderItem.ItemPrefix = name;
objSalesOrderItem.Description = description;
objSalesOrderItem.ItemCostPrice = Convert.ToDecimal(pricec);
objSalesOrderItem.ItemSalePrice = Convert.ToDecimal(prices);
objSalesOrderItem.ItemDiscountPercentage = Convert.ToDecimal(discountper);
objSalesOrderItem.ItemDiscount = Convert.ToDecimal(discount);
objSalesOrderItem.ItemUnit = quantity;
//objMessageInfo = oblSalesOrder.ManageSaleOrderItem(objSalesOrderItem, cmdMode);
return("");
}
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objSalesOrderItem = new Store.SalesOrderItem.BusinessObject.SalesOrderItem();
oblSalesOrderItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objSalesOrderItem.SaleOrderItemID = Convert.ToInt32(dgvSaleOrderItem.DataKeys[gvrow.RowIndex].Value.ToString());
objSalesOrderItem.SalesOrderID = 0;
objSalesOrderItem.ItemId = 0;
objSalesOrderItem.ItemUnit = "";
objSalesOrderItem.Description = "";
objSalesOrderItem.ItemCostPrice = 0;
objSalesOrderItem.ItemSalePrice = 0;
objSalesOrderItem.ItemDiscountPercentage = 0;
objSalesOrderItem.ItemDiscount = 0;
objSalesOrderItem.CreatedBy = 1;
objMessageInfo = oblSalesOrderItem.ManageItemMaster(objSalesOrderItem, cmdMode);
BindSalesOrderItem();
updateSaleOrderItemBdInfo.Update();
}
catch (Exception ex)
{
throw;
}
finally
{
objSalesOrderItem = null;
objMessageInfo = null;
oblSalesOrderItem = null;
}
}
public Store.SalesOrderItem.BusinessObject.SalesOrderItem GetAllSalesOrderItem(int SalesOrderItemID, int Flag, string FlagValue)
{
Store.SalesOrderItem.BusinessObject.SalesOrderItem objSalesOrderItem = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_SalesOrderItem";
paramList.Add(new SQLParameter("@SalesOrderItemID", SalesOrderItemID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objSalesOrderItem = new BusinessObject.SalesOrderItem();
if (dr.IsDBNull(dr.GetOrdinal("SaleOrderItemID")) == false)
{
objSalesOrderItem.SaleOrderItemID = dr.GetInt32(dr.GetOrdinal("SaleOrderItemID"));
}
if (dr.IsDBNull(dr.GetOrdinal("SalesOrderID")) == false)
{
objSalesOrderItem.SalesOrderID = dr.GetInt32(dr.GetOrdinal("SalesOrderID"));
}
if (dr.IsDBNull(dr.GetOrdinal("SalesOrderID")) == false)
{
objSalesOrderItem.SalesOrderID = dr.GetInt32(dr.GetOrdinal("SalesOrderID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemId")) == false)
{
objSalesOrderItem.ItemId = dr.GetInt32(dr.GetOrdinal("ItemId"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrefix")) == false)
{
objSalesOrderItem.ItemPrefix = dr.GetString(dr.GetOrdinal("ItemPrefix"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemUnit")) == false)
{
objSalesOrderItem.ItemUnit = dr.GetString(dr.GetOrdinal("ItemUnit"));
}
if (dr.IsDBNull(dr.GetOrdinal("Description")) == false)
{
objSalesOrderItem.Description = dr.GetString(dr.GetOrdinal("Description"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemCostPrice")) == false)
{
objSalesOrderItem.ItemCostPrice = dr.GetDecimal(dr.GetOrdinal("ItemCostPrice"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemSalePrice")) == false)
{
objSalesOrderItem.ItemSalePrice = dr.GetDecimal(dr.GetOrdinal("ItemSalePrice"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemDiscountPercentage")) == false)
{
objSalesOrderItem.ItemDiscountPercentage = dr.GetDecimal(dr.GetOrdinal("ItemDiscountPercentage"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objSalesOrderItem.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objSalesOrderItem.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objSalesOrderItem.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objSalesOrderItem.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objSalesOrderItem.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objSalesOrderItem.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objSalesOrderItem.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objSalesOrderItem.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
dr.Close();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesOrderItem).FullName, 1);
}
return(objSalesOrderItem);
}
