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);
}
