public CustomerBook GetCustomer(int id)
{
SqlParameter pId = new SqlParameter("@Id", SqlDbType.Int);
cmSelectOne.Parameters.Add(pId);
pId.Value = id;
CustomerBook cus = new CustomerBook();
cmSelectOne.CommandText = "Select * from customers where customerid = @Id";
cn.Open();
rd = cmSelectOne.ExecuteReader();
if (rd.Read())
{
cus.CustomerID = Convert.ToInt32(rd["CustomerID"].ToString());
cus.Name = rd["Name"].ToString();
cus.Gender = Convert.ToChar(rd["Gender"].ToString());
cus.DOB = Convert.ToDateTime(rd["DOB"].ToString());
cus.Address = rd["Address"].ToString();
cus.Email = rd["Email"].ToString();
cus.NRIC = rd["NRIC"].ToString();
cus.CustStatus = Convert.ToBoolean(rd["Custstatus"].ToString());
cus.PostalCode = rd["PostalCode"].ToString();
cus.Phoneno = rd["Phoneno"].ToString();
cus.Remarks = rd["Remarks"].ToString();
cn.Close();
}
return(cus);
}
public CustomerBook GetCustomer(int id)
{
CustomerBroker cb = new CustomerBroker();
CustomerBook cus = cb.GetCustomer(id);
return(cus);
}
public List <CustomerBook> GetAllCustomers()
{
cmSelectAll.CommandText = "select * from customers where custstatus = 1";
cn.Open();
rd = cmSelectAll.ExecuteReader();
List <CustomerBook> customerList = new List <CustomerBook>();
while (rd.Read())
{
CustomerBook customer = new CustomerBook();
customer.CustomerID = Convert.ToInt32(rd["CustomerID"].ToString());
customer.Name = rd["Name"].ToString();
customer.Gender = Convert.ToChar(rd["Gender"].ToString());
customer.DOB = Convert.ToDateTime(rd["DOB"].ToString());
customer.Address = rd["Address"].ToString();
customer.Email = rd["Email"].ToString();
customer.NRIC = rd["NRIC"].ToString();
customer.CustStatus = Convert.ToBoolean(rd["Custstatus"].ToString());
customer.PostalCode = rd["PostalCode"].ToString();
customer.Phoneno = rd["Phoneno"].ToString();
customer.Remarks = rd["Remarks"].ToString();
customerList.Add(customer);
}
return(customerList);
}
