void BindPurchaseReceivedItem()
{
oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem();
try
{
objPurchaseReceivedItemList = oblPurchaseReceivedItem.GetAllPurchaseReceivedItemList(0, 0, "");
if (objPurchaseReceivedItemList != null)
{
dgvPurchaseItemReceived.DataSource = objPurchaseReceivedItemList;
dgvPurchaseItemReceived.DataBind();
}
else
{
dgvPurchaseItemReceived.DataSource = null;
dgvPurchaseItemReceived.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
oblPurchaseReceivedItem = null;
objPurchaseReceivedItemList = null;
}
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
try
{
string transid = "";
transid = insertReceived(txtSubTotal.Text, txtTax.Text, txtSHC.Text, txtMiscCost.Text, txttotal.Text);
objPurchaseReceivedItemList = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList();
for (int i = 0; i < Gridview1.Rows.Count; i++)
{
objPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem();
TextBox txtItemNames = (TextBox)Gridview1.Rows[i].FindControl("txtItemName");
if (txtItemNames.Text == "")
{
break;
}
TextBox txtDecs = (TextBox)Gridview1.Rows[i].FindControl("txtDec");
TextBox txtPrices = (TextBox)Gridview1.Rows[i].FindControl("txtPrice");
TextBox txtQuts = (TextBox)Gridview1.Rows[i].FindControl("txtQut");
TextBox txtTotals = (TextBox)Gridview1.Rows[i].FindControl("txtTotal");
objPurchaseReceivedItem.ItemPrefix = txtItemNames.Text;
objPurchaseReceivedItem.Description = txtDecs.Text;
objPurchaseReceivedItem.ItemPrice = Convert.ToDecimal(txtPrices.Text);
objPurchaseReceivedItem.ItemUnit = txtQuts.Text;
objPurchaseReceivedItem.TotalPrice = Convert.ToDecimal(txtTotals.Text);
objPurchaseReceivedItem.PurchaseReceivedID = Convert.ToInt32(transid);
objPurchaseReceivedItem.PurchaseOrderID = Convert.ToInt32(hfPOrder.Value);
objPurchaseReceivedItemList.Add(objPurchaseReceivedItem);
}
oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem();
objMessageInfo = oblPurchaseReceivedItem.ManageItemMaster(objPurchaseReceivedItemList, cmdMode);
reset();
}
catch (Exception ex)
{ Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PReceived).FullName, 1); }
}
public Store.Common.MessageInfo ManageItemMaster(Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList objPurchaseReceivedItemList, CommandMode cmdMode)
{
try
{
return(odlPurchaseReceivedItem.ManagePurchaseReceived(objPurchaseReceivedItemList, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseReceivedItem).FullName, 1);
return(null);
}
}
public Store.Common.MessageInfo ManagePurchaseReceived(Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList objPurchaseReceivedItemList, CommandMode cmdMode)
{
string SQL = "";
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
// 'USP_PurchaseReceivedItem'.
SQL = "USP_ManagePurchaseReceivedItem";
foreach (Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem objPurchaseReceivedItem in objPurchaseReceivedItemList)
{
ParameterList param = new ParameterList();
param.Add(new SQLParameter("@PurchaseItemReceivedID", objPurchaseReceivedItem.PurchaseItemReceivedID));
param.Add(new SQLParameter("@PurchaseReceivedID", objPurchaseReceivedItem.PurchaseReceivedID));
param.Add(new SQLParameter("@PurchaseOrderID", objPurchaseReceivedItem.PurchaseOrderID));
param.Add(new SQLParameter("@ItemPrefix", objPurchaseReceivedItem.ItemPrefix));
//param.Add(new SQLParameter("@ItemID", objPurchaseReceivedItem.ItemID));
//param.Add(new SQLParameter("@TotalPrice", objPurchaseReceivedItem.TotalPrice));
param.Add(new SQLParameter("@ItemUnit", objPurchaseReceivedItem.ItemUnit));
param.Add(new SQLParameter("@Description", objPurchaseReceivedItem.Description));
param.Add(new SQLParameter("@ItemPrice", objPurchaseReceivedItem.ItemPrice));
param.Add(new SQLParameter("@UserId", objPurchaseReceivedItem.CreatedBy));
param.Add(new SQLParameter("@ReferenceID", objPurchaseReceivedItem.ReferenceID));
param.Add(new SQLParameter("@IsActive", objPurchaseReceivedItem.IsActive));
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(PurchaseReceivedItem).FullName, 1);
}
return(objMessageInfo);
}
Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList BindPurchaseReceivedItem(int id)
{
try
{
oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem();
objPurchaseReceivedItemList = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList();
objPurchaseReceivedItemList = oblPurchaseReceivedItem.GetAllPurchaseReceivedItemList(id, 0, "");
return(objPurchaseReceivedItemList);
}
catch (Exception ex)
{
//return null;
throw ex;
}
finally
{
oblPurchaseReceivedItem = null;
objPurchaseReceivedItemList = null;
}
}
public Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList GetAllPurchaseReceivedItemList(int PurchaseItemReceivedID, int Flag, string FlagValue)
{
Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem objPurchaseReceivedItem = null;
Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList objPurchaseReceivedItemList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_PurchaseReceivedItem";
objPurchaseReceivedItemList = new BusinessObject.PurchaseReceivedItemList();
paramList.Add(new SQLParameter("@PurchaseItemReceivedID", PurchaseItemReceivedID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objPurchaseReceivedItem = new BusinessObject.PurchaseReceivedItem();
if (dr.IsDBNull(dr.GetOrdinal("PurchaseItemReceivedID")) == false)
{
objPurchaseReceivedItem.PurchaseItemReceivedID = dr.GetInt32(dr.GetOrdinal("PurchaseItemReceivedID"));
}
if (dr.IsDBNull(dr.GetOrdinal("PurchaseOrderID")) == false)
{
objPurchaseReceivedItem.PurchaseOrderID = dr.GetInt32(dr.GetOrdinal("PurchaseOrderID"));
}
if (dr.IsDBNull(dr.GetOrdinal("PurchaseReceivedID")) == false)
{
objPurchaseReceivedItem.PurchaseReceivedID = dr.GetInt32(dr.GetOrdinal("PurchaseReceivedID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemID")) == false)
{
objPurchaseReceivedItem.ItemID = dr.GetInt32(dr.GetOrdinal("ItemID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrefix")) == false)
{
objPurchaseReceivedItem.ItemPrefix = dr.GetString(dr.GetOrdinal("ItemPrefix"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemUnit")) == false)
{
objPurchaseReceivedItem.ItemUnit = dr.GetString(dr.GetOrdinal("ItemUnit"));
}
if (dr.IsDBNull(dr.GetOrdinal("Description")) == false)
{
objPurchaseReceivedItem.Description = dr.GetString(dr.GetOrdinal("Description"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrice")) == false)
{
objPurchaseReceivedItem.ItemPrice = dr.GetDecimal(dr.GetOrdinal("ItemPrice"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objPurchaseReceivedItem.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objPurchaseReceivedItem.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objPurchaseReceivedItem.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objPurchaseReceivedItem.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objPurchaseReceivedItem.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objPurchaseReceivedItem.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objPurchaseReceivedItem.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
objPurchaseReceivedItemList.Add(objPurchaseReceivedItem);
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseReceivedItem).FullName, 1);
}
return(objPurchaseReceivedItemList);
}
