void BindClient()
{
oblClient = new Store.Client.BusinessLogic.Client();
try
{
objClientList = oblClient.GetAllClientList(0, 0, "");
if (objClientList != null)
{
dgvClient.DataSource = objClientList;
dgvClient.DataBind();
}
else
{
dgvClient.DataSource = null;
dgvClient.DataBind();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Client).FullName, 1);
}
finally
{
oblClient = null;
objClientList = null;
}
}
public Store.Client.BusinessObject.ClientList GetAllClientList(int ClientID, int Flag, string FlagValue)
{
Store.Client.BusinessObject.Client objClient = null;
Store.Client.BusinessObject.ClientList objClientList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_Client";
objClientList = new BusinessObject.ClientList();
paramList.Add(new SQLParameter("@ClientID", ClientID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objClient = new BusinessObject.Client();
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objClient.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientName")) == false)
{
objClient.ClientName = dr.GetString(dr.GetOrdinal("ClientName"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientDisplayName")) == false)
{
objClient.ClientDisplayName = dr.GetString(dr.GetOrdinal("ClientDisplayName"));
}
if (dr.IsDBNull(dr.GetOrdinal("Address")) == false)
{
objClient.Address = dr.GetString(dr.GetOrdinal("Address"));
}
if (dr.IsDBNull(dr.GetOrdinal("CityID")) == false)
{
objClient.CityID = dr.GetInt32(dr.GetOrdinal("CityID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CityName")) == false)
{
objClient.CityName = dr.GetString(dr.GetOrdinal("CityName"));
}
if (dr.IsDBNull(dr.GetOrdinal("StateID")) == false)
{
objClient.StateID = dr.GetInt32(dr.GetOrdinal("StateID"));
}
if (dr.IsDBNull(dr.GetOrdinal("StateName")) == false)
{
objClient.StateName = dr.GetString(dr.GetOrdinal("StateName"));
}
if (dr.IsDBNull(dr.GetOrdinal("CountryID")) == false)
{
objClient.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CountryName")) == false)
{
objClient.CountryName = dr.GetString(dr.GetOrdinal("CountryName"));
}
if (dr.IsDBNull(dr.GetOrdinal("PinID")) == false)
{
objClient.PinID = dr.GetInt32(dr.GetOrdinal("PinID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objClient.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objClient.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objClient.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objClient.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objClient.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objClient.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
objClientList.Add(objClient);
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Client).FullName, 1);
}
return(objClientList);
}
