public void insert(Coustomer obj)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Insert into [AddCustomer].[dbo].[Customer] values('" + obj.RoomNO + "','" + obj.FirstName + "','" + obj.LastName + "','" + obj.Cnic
+ "','" + obj.Phone + "')";
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public Coustomer show(int id)
{
conn.Open();
string q = "SELECT * FROM [AddCustomer].[dbo].[Customer] WHERE RoomNo =" + "('" + id + "')";
SqlCommand cmd = new SqlCommand(q, conn);
SqlDataReader sdr = cmd.ExecuteReader();
Coustomer cs = new Coustomer();
sdr.Read();
cs.RoomNO = sdr["RoomNO"].ToString();
cs.FirstName = sdr["FirstName"].ToString();
cs.LastName = sdr["LastName"].ToString();
cs.Cnic = sdr["Cnic"].ToString();
cs.Phone = sdr["Phone"].ToString();
return(cs);
}
public List <Coustomer> GetRecord()
{
List <Coustomer> stlist = new List <Coustomer>();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from[AddCustomer].[dbo].[Customer]", conn);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Coustomer cs = new Coustomer();
cs.RoomNO = sdr["RoomNO"].ToString();
cs.FirstName = sdr["FirstName"].ToString();
cs.LastName = sdr["LastName"].ToString();
cs.Cnic = sdr["Cnic"].ToString();
cs.Phone = sdr["Phone"].ToString();
stlist.Add(cs);
}
return(stlist);
}