public Store.Common.MessageInfo ManageItemPrice(Store.ItemPrice.BusinessObject.ItemPrice objItemPrice, CommandMode cmdMode) { string SQL = ""; ParameterList param = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageItemPrice"; param.Add(new SQLParameter("@ItemPriceID", objItemPrice.ItemPriceID)); param.Add(new SQLParameter("@ItemSalePricePerUnit", objItemPrice.ItemSalePricePerUnit)); param.Add(new SQLParameter("@ItemDiscountPercentagePerUnit", objItemPrice.ItemDiscountPercentagePerUnit)); param.Add(new SQLParameter("@ApplicableFrom", objItemPrice.ApplicableFrom)); param.Add(new SQLParameter("@ApplicableTo", objItemPrice.ApplicableTo)); param.Add(new SQLParameter("@CMDMode", cmdMode)); dr = ExecuteQuery.ExecuteReader(SQL, param); if (dr.Read()) { objMessageInfo = new Store.Common.MessageInfo(); objMessageInfo.ErrorCode = Convert.ToInt32(dr["ErrorCode"]); objMessageInfo.ErrorMessage = Convert.ToString(dr["ErrorMessage"]); objMessageInfo.TranID = Convert.ToInt32(dr["TranID"]); objMessageInfo.TranCode = Convert.ToString(dr["TranCode"]); objMessageInfo.TranMessage = Convert.ToString(dr["TranMessage"]); } } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(ItemPrice).FullName, 1); } return(objMessageInfo); }
protected void txtItemName_TextChanged(object sender, EventArgs e) { int rows = Convert.ToInt32(((TextBox)sender).Attributes["Rowid"].ToString()); TextBox name = (TextBox)Gridview1.Rows[rows].FindControl("txtItemName"); TextBox dec = (TextBox)Gridview1.Rows[rows].FindControl("txtDis"); TextBox priceS = (TextBox)Gridview1.Rows[rows].FindControl("txtSaleAmount"); TextBox dicPre = (TextBox)Gridview1.Rows[rows].FindControl("txtDisPer"); TextBox disAmt = (TextBox)Gridview1.Rows[rows].FindControl("txtDisAmt"); TextBox priceC = (TextBox)Gridview1.Rows[rows].FindControl("txtCostAmount"); TextBox qut = (TextBox)Gridview1.Rows[rows].FindControl("txtQut"); string item = name.Text; Store.Item.BusinessObject.Item objItem = new Store.Item.BusinessObject.Item(); Store.Item.BusinessLogic.Item oblItem = new Store.Item.BusinessLogic.Item(); objItem = oblItem.GetAllItem(item, 0, ""); dec.Text = objItem.ItemDescription; Store.ItemPrice.BusinessObject.ItemPrice objItemPrice = new Store.ItemPrice.BusinessObject.ItemPrice(); Store.ItemPrice.BusinessLogic.ItemPrice oblItemPrice = new Store.ItemPrice.BusinessLogic.ItemPrice(); objItemPrice = oblItemPrice.GetAllItemPrice(0, 0, ""); //Cost price and sale price will come from itemPrice table priceC.Text = Convert.ToString(objItemPrice.ItemCostPricePerUnit); priceS.Text = Convert.ToString(objItemPrice.ItemSalePricePerUnit); dicPre.Text = Convert.ToString(objItemPrice.ItemDiscountPercentagePerUnit); disAmt.Text = Convert.ToString((Convert.ToDouble(priceS.Text) * Convert.ToDouble(dicPre.Text)) / 100); qut.Focus(); }
void UpdateItemPrice() { objItemPrice = new Store.ItemPrice.BusinessObject.ItemPrice(); oblItemPrice = new Store.ItemPrice.BusinessLogic.ItemPrice(); try { objItemPrice.ItemPriceID = Convert.ToInt32(hfItemPriceId.Value); objItemPrice.ItemSalePricePerUnit = Convert.ToDecimal(txtSP.Text); objItemPrice.ItemDiscountPercentagePerUnit = Convert.ToDecimal(txtDisPerUnit.Text); objItemPrice.ApplicableFrom = Convert.ToDateTime(txtApplicableFrom.Text); objItemPrice.ApplicableTo = Convert.ToDateTime(txtApplicableTo.Text); objMessageInfo = oblItemPrice.ManageItemMaster(objItemPrice, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(ItemPrice).FullName, 1); } finally { objItemPrice = null; oblItemPrice = null; } }
public Store.Common.MessageInfo ManageItemMaster(Store.ItemPrice.BusinessObject.ItemPrice objItemPrice, CommandMode cmdMode) { try { return(odlItemPrice.ManageItemPrice(objItemPrice, cmdMode)); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(ItemPrice).FullName, 1); return(null); } }
protected void ddlItemId_SelectedIndexChanged(object sender, EventArgs e) { int id = Convert.ToInt32(ddlItemId.SelectedValue); Store.Item.BusinessObject.Item objItem = new Store.Item.BusinessObject.Item(); oblItem = new Store.Item.BusinessLogic.Item(); Store.ItemPrice.BusinessObject.ItemPrice objItemPrice = new Store.ItemPrice.BusinessObject.ItemPrice(); Store.ItemPrice.BusinessLogic.ItemPrice oblItemPrice = new Store.ItemPrice.BusinessLogic.ItemPrice(); objItemPrice = oblItemPrice.GetAllItemPrice(id, 0, ""); //objItem = oblItem.GetAllItem(id, 0, ""); txtItemUnit.Text = objItem.UnitName; txtDescription.Text = objItem.ItemDescription; txtItemPrice.Text = Convert.ToString(objItemPrice.ItemSalePricePerUnit); }
protected void ddlItemId_SelectedIndexChanged(object sender, EventArgs e) { int id = Convert.ToInt32(ddlItemId.SelectedValue); Store.Item.BusinessObject.Item objItem = new Store.Item.BusinessObject.Item(); oblItem = new Store.Item.BusinessLogic.Item(); Store.ItemPrice.BusinessObject.ItemPrice objItemPrice = new Store.ItemPrice.BusinessObject.ItemPrice(); Store.ItemPrice.BusinessLogic.ItemPrice oblItemPrice = new Store.ItemPrice.BusinessLogic.ItemPrice(); objItemPrice = oblItemPrice.GetAllItemPrice(id, 0, ""); //objItem = oblItem.GetAllItem(id, 0, ""); txtItemUnit.Text = objItem.UnitName; txtDescription.Text = objItem.ItemDescription; txtItemCostPrice.Text = Convert.ToString(objItemPrice.ItemCostPricePerUnit); txtItemSalePrice.Text = Convert.ToString(objItemPrice.ItemSalePricePerUnit); txtItemDiscountPercentage.Text = Convert.ToString(objItemPrice.ItemDiscountPercentagePerUnit); decimal sale = Convert.ToDecimal(objItemPrice.ItemSalePricePerUnit); decimal discp = Convert.ToDecimal(objItemPrice.ItemDiscountPercentagePerUnit); decimal discount = (sale * discp) / 100; txtItemDiscount.Text = Convert.ToString(discount); }
public Store.ItemPrice.BusinessObject.ItemPrice GetAllItemPrice(int ItemPriceID, int Flag, string FlagValue) { Store.ItemPrice.BusinessObject.ItemPrice objItemPrice = null; string SQL = string.Empty; ParameterList paramList = new ParameterList(); DataTableReader dr; try { SQL = "proc_ItemPrice"; paramList.Add(new SQLParameter("@ItemPriceID", ItemPriceID)); paramList.Add(new SQLParameter("@Flag", Flag)); paramList.Add(new SQLParameter("@FlagValue", FlagValue)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); while (dr.Read()) { objItemPrice = new BusinessObject.ItemPrice(); if (dr.IsDBNull(dr.GetOrdinal("ItemPriceID")) == false) { objItemPrice.ItemPriceID = dr.GetInt32(dr.GetOrdinal("ItemPriceID")); } if (dr.IsDBNull(dr.GetOrdinal("ItemID")) == false) { objItemPrice.ItemID = dr.GetInt32(dr.GetOrdinal("ItemID")); } if (dr.IsDBNull(dr.GetOrdinal("ItemCostPricePerUnit")) == false) { objItemPrice.ItemCostPricePerUnit = dr.GetDecimal(dr.GetOrdinal("ItemCostPricePerUnit")); } if (dr.IsDBNull(dr.GetOrdinal("ItemSalePricePerUnit")) == false) { objItemPrice.ItemSalePricePerUnit = dr.GetDecimal(dr.GetOrdinal("ItemSalePricePerUnit")); } if (dr.IsDBNull(dr.GetOrdinal("ItemDiscountPercentagePerUnit")) == false) { objItemPrice.ItemDiscountPercentagePerUnit = dr.GetDecimal(dr.GetOrdinal("ItemDiscountPercentagePerUnit")); } if (dr.IsDBNull(dr.GetOrdinal("ApplicableFrom")) == false) { objItemPrice.ApplicableFrom = dr.GetDateTime(dr.GetOrdinal("ApplicableFrom")); } if (dr.IsDBNull(dr.GetOrdinal("ApplicableTo")) == false) { objItemPrice.ApplicableTo = dr.GetDateTime(dr.GetOrdinal("ApplicableTo")); } if ((dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)) { objItemPrice.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn")); } if ((dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)) { objItemPrice.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy")); } if ((dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)) { objItemPrice.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy")); } if ((dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)) { objItemPrice.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn")); } if ((dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)) { objItemPrice.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID")); } if (dr.IsDBNull(dr.GetOrdinal("BatchNo")) == false) { objItemPrice.BatchNo = dr.GetString(dr.GetOrdinal("BatchNo")); } } dr.Close(); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(ItemPrice).FullName, 1); } return(objItemPrice); }