public bool delete(KindRoomDTO pt)
{
string query = string.Empty;
query += "DELETE FROM KindRoom WHERE [iDKR] = @iDKR";;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@iDKR", pt.IDKR);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
Console.WriteLine(ex);
throw;
}
}
}
return(true);
}
public bool edit(KindRoomDTO kr)
{
string query = string.Empty;
query += "UPDATE KindRoom SET [nAME] = @nAME, [bedsAMOUNT] = @bedsAMOUNT, [nOTE] = @nOTE WHERE [iDKR] = @iDKR";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@iDKR", kr.IDKR);
cmd.Parameters.AddWithValue("@nAME", kr.NAME);
cmd.Parameters.AddWithValue("@bedsAMOUNT", kr.BedsAMOUNT);
cmd.Parameters.AddWithValue("@nOTE", kr.NOTE);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
Console.WriteLine(ex);
throw;
}
}
}
return(true);
}
public List <KindRoomDTO> search(string Keyword)
{
string query = string.Empty;
query += "SELECT [iDKR], [nAME], [bedsAMOUNT], [nOTE]";
query += "FROM [KindRoom]";
query += " WHERE ([nAME] LIKE CONCAT('%',@Keyword,'%'))";
query += " OR ([iDKR] LIKE CONCAT('%',@Keyword,'%'))";
query += " OR ([bedsAMOUNT] LIKE CONCAT('%',@Keyword,'%'))";
query += " OR ([nOTE] LIKE CONCAT('%',@Keyword,'%'))";
List <KindRoomDTO> lsTimKiem = new List <KindRoomDTO>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Keyword", Keyword);
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
KindRoomDTO kr = new KindRoomDTO();
kr.IDKR = reader["iDKR"].ToString();
kr.NAME = reader["nAME"].ToString();
kr.BedsAMOUNT = int.Parse(reader["bedsAMOUNT"].ToString());
kr.NOTE = reader["nOTE"].ToString();
lsTimKiem.Add(kr);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
Console.WriteLine(ex);
throw;
}
}
}
return(lsTimKiem);
}
public List <KindRoomDTO> select()
{
string query = string.Empty;
query += "SELECT [iDKR], [nAME], [bedsAMOUNT], [nOTE]";
query += "FROM [KindRoom]";
List <KindRoomDTO> IsNameKindRoom = new List <KindRoomDTO>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
KindRoomDTO kr = new KindRoomDTO();
kr.IDKR = reader["iDKR"].ToString();
kr.NAME = reader["nAME"].ToString();
kr.BedsAMOUNT = int.Parse(reader["bedsAMOUNT"].ToString());
kr.NOTE = reader["nOTE"].ToString();
IsNameKindRoom.Add(kr);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
Console.WriteLine(ex);
throw;
}
}
}
return(IsNameKindRoom);
}
public bool add(KindRoomDTO kr)
{
string query = string.Empty;
query += "INSERT INTO [KindRoom] (iDKR,nAME,bedsAMOUNT,nOTE) ";
query += "VALUES (@iDKR,@nAME,@bedsAMOUNT,@nOTE)";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@iDKR", kr.IDKR);
cmd.Parameters.AddWithValue("@nAME", kr.NAME);
cmd.Parameters.AddWithValue("@bedsAMOUNT", kr.BedsAMOUNT);
cmd.Parameters.AddWithValue("@nOTE", kr.NOTE);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
Console.WriteLine(ex);
throw;
}
}
}
return(true);
}
public bool edit(KindRoomDTO pt)
{
bool re = krDao.edit(pt);
return(re);
}
public bool delete(KindRoomDTO pt)
{
bool re = krDao.delete(pt);
return(re);
}
public bool add(KindRoomDTO pt)
{
bool re = krDao.add(pt);
return(re);
}