void BindPurchaseReceived()
{
oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived();
try
{
objPurchaseReceivedList = oblPurchaseReceived.GetAllPurchaseReceivedList(0, 0, "");
if (objPurchaseReceivedList != null)
{
ddlPurchaseReceivedId.DataSource = objPurchaseReceivedList;
// ddlPurchaseOrderId.DataTextField = "StateName";
ddlPurchaseReceivedId.DataValueField = "PurchaseReceivedID";
ddlPurchaseReceivedId.DataBind();
//ddlState.Items.FindByValue(db.Table.Rows[0]["StateID"].ToString()).Selected=true;
}
else
{
ddlPurchaseReceivedId.DataSource = null;
ddlPurchaseReceivedId.DataBind();
}
}
catch (Exception)
{
throw;
}
finally
{
oblPurchaseReceived = null;
objPurchaseReceivedList = null;
}
}
private void bindPRecived()
{
try
{
oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived();
objPurchaseReceivedList = new Store.PurchaseReceived.BusinessObject.PurchaseReceivedList();
objPurchaseReceivedList = oblPurchaseReceived.GetAllPurchaseReceivedList(0, 0, "");
if (objPurchaseReceivedList != null)
{
gvPOrder.DataSource = objPurchaseReceivedList;
gvPOrder.DataBind();
}
else
{
gvPOrder.DataSource = null;
gvPOrder.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
oblPurchaseReceived = null;
objPurchaseReceivedList = null;
}
}
void BindPurchaseReceived()
{
oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived();
try
{
objPurchaseReceivedList = oblPurchaseReceived.GetAllPurchaseReceivedList(0, 0, "");
if (objPurchaseReceivedList != null)
{
dgvPurchaseReceived.DataSource = objPurchaseReceivedList;
dgvPurchaseReceived.DataBind();
}
else
{
dgvPurchaseReceived.DataSource = null;
dgvPurchaseReceived.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
oblPurchaseReceived = null;
objPurchaseReceivedList = null;
}
}
public Store.PurchaseReceived.BusinessObject.PurchaseReceivedList GetAllPurchaseReceivedList(int PurchaseReceivedID, int Flag, string FlagValue)
{
Store.PurchaseReceived.BusinessObject.PurchaseReceived objPurchaseReceived = null;
Store.PurchaseReceived.BusinessObject.PurchaseReceivedList objPurchaseReceivedList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_PurchaseReceived";
objPurchaseReceivedList = new BusinessObject.PurchaseReceivedList();
paramList.Add(new SQLParameter("@PurchaseReceivedID", PurchaseReceivedID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objPurchaseReceived = new BusinessObject.PurchaseReceived();
if (dr.IsDBNull(dr.GetOrdinal("PurchaseReceivedID")) == false)
{
objPurchaseReceived.PurchaseReceivedID = dr.GetInt32(dr.GetOrdinal("PurchaseReceivedID"));
}
if (dr.IsDBNull(dr.GetOrdinal("PurchaseOrderID")) == false)
{
objPurchaseReceived.PurchaseOrderID = dr.GetInt32(dr.GetOrdinal("PurchaseOrderID"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorID")) == false)
{
objPurchaseReceived.VendorID = dr.GetInt32(dr.GetOrdinal("VendorID"));
}
//if (dr.IsDBNull(dr.GetOrdinal("VendorName")) == false)
//{
// objPurchaseReceived.VendorName = dr.GetString(dr.GetOrdinal("VendorName"));
//}
if (dr.IsDBNull(dr.GetOrdinal("PurchaseRecivedDate")) == false)
{
objPurchaseReceived.PurchaseRecivedDate = dr.GetDateTime(dr.GetOrdinal("PurchaseRecivedDate"));
}
if (dr.IsDBNull(dr.GetOrdinal("PurchaseAmount")) == false)
{
objPurchaseReceived.PurchaseAmount = dr.GetDecimal(dr.GetOrdinal("PurchaseAmount"));
}
if (dr.IsDBNull(dr.GetOrdinal("TaxValue")) == false)
{
objPurchaseReceived.TaxValue = dr.GetDecimal(dr.GetOrdinal("TaxValue"));
}
if (dr.IsDBNull(dr.GetOrdinal("ShipingAndHandlingCost")) == false)
{
objPurchaseReceived.ShipingAndHandlingCost = dr.GetDecimal(dr.GetOrdinal("ShipingAndHandlingCost"));
}
if (dr.IsDBNull(dr.GetOrdinal("MiscCost")) == false)
{
objPurchaseReceived.MiscCost = dr.GetDecimal(dr.GetOrdinal("MiscCost"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objPurchaseReceived.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objPurchaseReceived.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objPurchaseReceived.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objPurchaseReceived.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objPurchaseReceived.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objPurchaseReceived.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objPurchaseReceived.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
objPurchaseReceivedList.Add(objPurchaseReceived);
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseReceived).FullName, 1);
}
return(objPurchaseReceivedList);
}
