void BindSalesReturned()
{
oblSalesReturned = new Store.SalesReturned.BusinessLogic.SalesReturned();
try
{
objSalesReturnedList = oblSalesReturned.GetAllSalesReturnedList(0, 0, "");
if (objSalesReturnedList != null)
{
dgvSalesReturned.DataSource = objSalesReturnedList;
dgvSalesReturned.DataBind();
}
else
{
dgvSalesReturned.DataSource = null;
dgvSalesReturned.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
oblSalesReturned = null;
objSalesReturnedList = null;
}
}
void BindSalesReturned()
{
oblSalesReturn = new Store.SalesReturned.BusinessLogic.SalesReturned();
try
{
objSalesReturnList = oblSalesReturn.GetAllSalesReturnedList(0, 0, "");
if (objSalesReturnList != null)
{
ddlSalesReturnID.DataSource = objSalesReturnList;
ddlSalesReturnID.DataValueField = "SalesReturnedID";
//ddlSalesReturnID.DataTextField = "SaleReturnedID";
ddlSalesReturnID.DataBind();
}
else
{
ddlSalesReturnID.DataSource = null;
ddlSalesReturnID.DataBind();
}
}
catch (Exception)
{
throw;
}
finally
{
oblSalesReturn = null;
objSalesReturnList = null;
}
}
void BindSaleOrder()
{
oblSalesRtn = new Store.SalesReturned.BusinessLogic.SalesReturned();
// oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder();
try
{
objsalesRtnList = oblSalesRtn.GetAllSalesReturnedList(0, 0, "");
//objPurchaseOrderlist = oblPurchaseOrder.GetAllPurchaseOrderList(0, 0, "");
if (objsalesRtnList != null)
{
gvSaleRtn.DataSource = objsalesRtnList;
gvSaleRtn.DataBind();
}
else
{
gvSaleRtn.DataSource = null;
gvSaleRtn.DataBind();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesReturn).FullName, 1);
}
finally
{
oblSalesRtn = null;
objsalesRtnList = null;
}
}
private void BindSalesReturn()
{
try
{
oblSalesRtn = new Store.SalesReturned.BusinessLogic.SalesReturned();
objsalesRtnList = new Store.SalesReturned.BusinessObject.SalesReturnedList();
objsalesRtnList = oblSalesRtn.GetAllSalesReturnedList(0, 0, "");
if (objsalesRtnList != null)
{
gvSalesRtn.DataSource = objsalesRtnList;
gvSalesRtn.DataBind();
}
else
{
gvSalesRtn.DataSource = null;
gvSalesRtn.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
oblSalesRtn = null;
objsalesRtnList = null;
}
}
public Store.SalesReturned.BusinessObject.SalesReturnedList GetAllSalesReturnedList(int SalesReturnedID, int Flag, string FlagValue)
{
Store.SalesReturned.BusinessObject.SalesReturned objSalesReturned = null;
Store.SalesReturned.BusinessObject.SalesReturnedList objSalesReturnedList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_SalesReturn";
objSalesReturnedList = new BusinessObject.SalesReturnedList();
paramList.Add(new SQLParameter("@SalesReturnedID", SalesReturnedID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objSalesReturned = new BusinessObject.SalesReturned();
if (dr.IsDBNull(dr.GetOrdinal("SalesReturnedID")) == false)
{
objSalesReturned.SalesReturnedID = dr.GetInt32(dr.GetOrdinal("SalesReturnedID"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorID")) == false)
{
objSalesReturned.VendorID = dr.GetInt32(dr.GetOrdinal("VendorID"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorName")) == false)
{
objSalesReturned.VendorName = dr.GetString(dr.GetOrdinal("VendorName"));
}
if (dr.IsDBNull(dr.GetOrdinal("SalesReturnDate")) == false)
{
objSalesReturned.SalesReturnDate = dr.GetDateTime(dr.GetOrdinal("SalesReturnDate"));
}
if (dr.IsDBNull(dr.GetOrdinal("TotalSalesReturnAmount")) == false)
{
objSalesReturned.TotalSalesReturnAmount = dr.GetDecimal(dr.GetOrdinal("TotalSalesReturnAmount"));
}
if (dr.IsDBNull(dr.GetOrdinal("TaxValue")) == false)
{
objSalesReturned.TaxValue = dr.GetDecimal(dr.GetOrdinal("TaxValue"));
}
if (dr.IsDBNull(dr.GetOrdinal("ShippingAndHandlingCost")) == false)
{
objSalesReturned.ShippingAndHandlingCost = dr.GetDecimal(dr.GetOrdinal("ShippingAndHandlingCost"));
}
if (dr.IsDBNull(dr.GetOrdinal("MiscCost")) == false)
{
objSalesReturned.MiscCost = dr.GetDecimal(dr.GetOrdinal("MiscCost"));
}
if (dr.IsDBNull(dr.GetOrdinal("SalesOrderID")) == false)
{
objSalesReturned.SalesOrderID = dr.GetInt32(dr.GetOrdinal("SalesOrderID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objSalesReturned.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objSalesReturned.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objSalesReturned.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objSalesReturned.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objSalesReturned.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objSalesReturned.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objSalesReturned.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
objSalesReturnedList.Add(objSalesReturned);
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesReturned).FullName, 1);
}
return(objSalesReturnedList);
}
