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