public List <tblCashierRecord> getAllCashier()
{
SqlDataReader reader = ReadData("delete from tblCashierRecord");
List <tblCashierRecord> dsSaleRe = new List <tblCashierRecord>();
while (reader.Read())
{
string cashier = reader.GetString(0);
string pid = reader.GetString(1);
string descrip = reader.GetString(2);
string price = reader.GetString(3);
string quantity = reader.GetString(4);
string totalsum = reader.GetString(5);
string type = reader.GetString(6);
string size = reader.GetString(7);
string brand = reader.GetString(8);
DateTime date = reader.GetDateTime(9);
tblCashierRecord sale = new tblCashierRecord();
sale.Cashier = cashier;
sale.PID = pid;
sale.Descrip = descrip;
sale.Price = price;
sale.Quantity = quantity;
sale.TotalSum = totalsum;
sale.Type = type;
sale.Size = size;
sale.Brand = brand;
sale.DateTime = date;
dsSaleRe.Add(sale);
}
reader.Close();
return(dsSaleRe);
}
public List <tblCashierRecord> search(string Descrip)
{
SqlDataReader reader = ReadData("Select * from tblRecord where Description like '" + Descrip + "%' Order by DateTime DESC");
List <tblCashierRecord> dsSale = new List <tblCashierRecord>();
while (reader.Read())
{
string cashier = reader.GetString(0);
string id = reader.GetString(1);
string descrip = reader.GetString(2);
string price = reader.GetString(3);
string quantity = reader.GetString(4);
string totalsum = reader.GetString(5);
string type = reader.GetString(6);
string size = reader.GetString(7);
string brand = reader.GetString(8);
DateTime date = reader.GetDateTime(9);
tblCashierRecord sale = new tblCashierRecord();
sale.Cashier = cashier;
sale.PID = id;
sale.Descrip = descrip;
sale.Price = price;
sale.Quantity = quantity;
sale.TotalSum = totalsum;
sale.Type = type;
sale.Size = size;
sale.Brand = brand;
sale.DateTime = date;
dsSale.Add(sale);
}
reader.Close();
return(dsSale);
}
