public bool update(PhongHocDTO ph)
{
try
{
conn.Open();
string sql = "update phonghoc set ten_PH = @name, ngaysua = @updated, ghichu_PH = @note, succhua_PH = @max where id_PH = @id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("id", ph.Id);
cmd.Parameters.AddWithValue("name", ph.Name);
cmd.Parameters.AddWithValue("updated", ph.Updated);
cmd.Parameters.AddWithValue("note", ph.Note);
cmd.Parameters.AddWithValue("max", ph.MaxSeat);
int rowEffect = cmd.ExecuteNonQuery();
conn.Close();
if (rowEffect == 0)
{
return(false);
}
return(true);
}
catch (Exception ex)
{
conn.Close();
Console.WriteLine(ex.Message);
return(false);
}
}
public bool insert(PhongHocDTO ph)
{
try
{
conn.Open();
string sql = "insert into phonghoc values (@id, @name, @created, @updated, @note, @max)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("id", ph.Id);
cmd.Parameters.AddWithValue("name", ph.Name);
cmd.Parameters.AddWithValue("created", ph.Created);
cmd.Parameters.AddWithValue("updated", ph.Updated);
cmd.Parameters.AddWithValue("note", ph.Note);
cmd.Parameters.AddWithValue("max", ph.MaxSeat);
int rowEffect = cmd.ExecuteNonQuery();
conn.Close();
if (rowEffect == 0)
{
return(false);
}
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
private void Dgv_ph_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
PhongHocDTO ph = new PhongHocDTO();
int index = dgv_ph.CurrentCell.RowIndex;
ph.Id = dgv_ph.Rows[index].Cells["id_PH"].Value.ToString();
ph.Name = dgv_ph.Rows[index].Cells["ten_PH"].Value.ToString();
ph.Note = dgv_ph.Rows[index].Cells["ghichu_PH"].Value.ToString();
ph.Created = DateTime.Parse(dgv_ph.Rows[index].Cells["ngaytao"].Value.ToString());
ph.Updated = DateTime.Parse(dgv_ph.Rows[index].Cells["ngaysua"].Value.ToString());
ph.MaxSeat = int.Parse(dgv_ph.Rows[index].Cells["succhua_PH"].Value.ToString());
new PhongHocDialog_ChiTiet(ph).ShowDialog();
}
public List <PhongHocDTO> getAll()
{
List <PhongHocDTO> phs = new List <PhongHocDTO>();
conn.Open();
string sql = "select * from phonghoc";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
PhongHocDTO ph = PhongHocMapper.map(dr);
phs.Add(ph);
}
conn.Close();
return(phs);
}
public PhongHocDTO findById(string id)
{
conn.Open();
string sql = "select * from phonghoc where id_PH = @id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("id", id);
SqlDataReader dr = cmd.ExecuteReader();
PhongHocDTO ph = null;
while (dr.Read())
{
ph = PhongHocMapper.map(dr);
}
conn.Close();
return(ph);
}
private void PhongHocDialog_insertupdate_Load(object sender, EventArgs e)
{
if (isInsert)
{
lb_title.Text = "Thêm phòng học";
bt_ok.Text = "Thêm";
}
else
{
lb_title.Text = "Sửa phòng học";
bt_ok.Text = "Sửa";
PhongHocDTO ph = PhongHocBLL.Instance.findById(id);
tb_succhua.Text = ph.MaxSeat.ToString();
tb_ghichu.Text = ph.Note;
tb_ten.Text = ph.Name;
}
}
public List <PhongHocDTO> findByName(string name)
{
conn.Open();
List <PhongHocDTO> phs = new List <PhongHocDTO>();
string sql = "select * from phonghoc where ten_PH like concat('%',@ten,'%')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("ten", name);
SqlDataReader dr = cmd.ExecuteReader();
PhongHocDTO ph = null;
while (dr.Read())
{
ph = PhongHocMapper.map(dr);
phs.Add(ph);
}
conn.Close();
return(phs);
}
private bool Them(bool error)
{
if (isInsert && !error)
{
PhongHocDTO ph = new PhongHocDTO();
ph.Name = tb_ten.Text.Trim();
ph.Note = tb_ghichu.Text.Trim();
ph.MaxSeat = int.Parse(tb_succhua.Text.Trim());
ph.Created = DateTime.Now;
ph.Updated = ph.Created;
ph.Id = "PH_" + TimingDTO.getTimeString("dd", "MM", "yy", "HH", "mm", "ss");
if (PhongHocBLL.Instance.insert(ph))
{
MessageBox.Show("Thêm phòng học thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
return(true);
}
}
else if (!error)
{
PhongHocDTO ph = new PhongHocDTO();
ph.Id = id;
ph.Name = tb_ten.Text;
ph.MaxSeat = int.Parse(tb_succhua.Text);
ph.Note = tb_ghichu.Text;
ph.Updated = DateTime.Now;
if (PhongHocBLL.Instance.update(ph))
{
return(true);
}
}
return(false);
}
public PhongHocDialog_ChiTiet(PhongHocDTO p)
{
ph = p;
InitializeComponent();
}
public bool update(PhongHocDTO ph)
{
return(PhongHocDAL.Instance.update(ph));
}
public bool insert(PhongHocDTO ph)
{
return(PhongHocDAL.Instance.insert(ph));
}
