public CustomerInfo CustomerIDataReader(IDataReader dr)
{
DataAccess.CustomerInfo obj = new DataAccess.CustomerInfo();
obj.CustomerID = (dr["CustomerID"] is DBNull) ? string.Empty : dr["CustomerID"].ToString();
obj.UserName = (dr["UserName"] is DBNull) ? string.Empty : dr["UserName"].ToString();
obj.Password = (dr["Password"] is DBNull) ? string.Empty : dr["Password"].ToString();
obj.FullName = (dr["FullName"] is DBNull) ? string.Empty : dr["FullName"].ToString();
obj.Gender = (dr["Gender"] is DBNull) ? string.Empty : dr["Gender"].ToString();
obj.Birthday = (dr["Birthday"] is DBNull) ? string.Empty : dr["Birthday"].ToString();
obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString();
obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString();
obj.IdentityCard = (dr["IdentityCard"] is DBNull) ? string.Empty : dr["IdentityCard"].ToString();
obj.MobileNumber = (dr["MobileNumber"] is DBNull) ? string.Empty : dr["MobileNumber"].ToString();
obj.HomePhone = (dr["HomePhone"] is DBNull) ? string.Empty : dr["HomePhone"].ToString();
obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString();
return(obj);
}
public List <CustomerInfo> Customer_GetByAll()
{
List <DataAccess.CustomerInfo> list = new List <DataAccess.CustomerInfo>();
DataAccess.CustomerInfo obj = new DataAccess.CustomerInfo();
DbCommand cmd = db.GetStoredProcCommand("CustomerInfos_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.CustomerIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <CustomerInfo> Customer_Paging(string CurentCustomerInfo, string CustomerInfoSize)
{
List <DataAccess.CustomerInfo> list = new List <DataAccess.CustomerInfo>();
DataAccess.CustomerInfo obj = new DataAccess.CustomerInfo();
DbCommand cmd = db.GetStoredProcCommand("CustomerInfos_SelectPage", CurentCustomerInfo, CustomerInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.CustomerIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <CustomerInfo> Customer_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.CustomerInfo> list = new List <DataAccess.CustomerInfo>();
DataAccess.CustomerInfo obj = new DataAccess.CustomerInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_CustomerInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.CustomerIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
