public bool leaving(Guest_bll g) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "UPDATE Guest SET available=@available WHERE guest_id=@guest_id "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@available", g.available); cmd.Parameters.AddWithValue("@guest_id", g.guest_id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
public bool InsertGuest(Guest_bll g) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { String sql = "INSERT INTO Guest(guest_id,recepID,Name,address_,NIC,Gender,ContacNo,Country,PassportNo,available,Room_No) VALUES(@guest_id,@recepID,@Name,@address_,@NIC,@Gender,@ContacNo,@Country,@PassportNo,@available,@Room_No) "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@guest_id", g.guest_id); cmd.Parameters.AddWithValue("@recepID", g.recepID); cmd.Parameters.AddWithValue("@Name", g.Name); cmd.Parameters.AddWithValue("@address_", g.address_); cmd.Parameters.AddWithValue("@NIC", g.NIC); cmd.Parameters.AddWithValue("@Gender", g.Gender); cmd.Parameters.AddWithValue("@ContacNo", g.ContacNo); cmd.Parameters.AddWithValue("@Country", g.Country); cmd.Parameters.AddWithValue("@PassportNo", g.PassportNo); cmd.Parameters.AddWithValue("@available", g.available); cmd.Parameters.AddWithValue("@Room_No", g.Room_No); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
public bool UpdateGuest(Guest_bll g) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "UPDATE Guest SET recepID=@recepID,Name=@Name,address_=@address_,NIC=@NIC,Gender=@Gender,ContacNo=@ContacNo,Country=@Country,PassportNo= @PassportNo,Room_No=@Room_No WHERE guest_id=@guest_id "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@recepID", g.recepID); cmd.Parameters.AddWithValue("@Name", g.Name); cmd.Parameters.AddWithValue("@address_", g.address_); cmd.Parameters.AddWithValue("@NIC", g.NIC); cmd.Parameters.AddWithValue("@Gender", g.Gender); cmd.Parameters.AddWithValue("@ContacNo", g.ContacNo); cmd.Parameters.AddWithValue("@Country", g.Country); cmd.Parameters.AddWithValue("@PassportNo", g.PassportNo); cmd.Parameters.AddWithValue("@Room_No", g.Room_No); cmd.Parameters.AddWithValue("@guest_id", g.guest_id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }