public bool UpdateBaoCao(BaoCaoCongNo bccn)
{
try
{
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
string query = "update BaoCaoCongNo" +
"set Thang=@Thang," +
"Nam=@Nam" +
"where MaBaoCaoCongNo=@MaBaoCaoCongNo";
SqlCommand cmd = new SqlCommand(query, _connection);
cmd.Parameters.Add("@MaBaoCaoCongNo", SqlDbType.Char).Value = bccn.MaBaoCaoCongNo;
cmd.Parameters.Add("@Thang", SqlDbType.Int).Value = bccn.Thang;
cmd.Parameters.Add("@Nam", SqlDbType.Int).Value = bccn.Nam;
cmd.ExecuteNonQuery();
_connection.Close();
return(true);
}
catch (Exception ex)
{
_connection.Close();
}
return(false);
}
public BaoCaoCongNo GetBaoCaoFromThangNam(int thang, int nam)
{
try
{
var obj = new BaoCaoCongNo();
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
SqlCommand command = new SqlCommand("SELECT * FROM BaoCaoCongNo WHERE Thang = @thang and Nam=@nam", _connection);
command.Parameters.Add("@thang", SqlDbType.Int).Value = thang;
command.Parameters.Add("@nam", SqlDbType.Int).Value = nam;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
obj.MaBaoCaoCongNo = reader["MaBaoCaoCongNo"].ToString();
obj.Thang = int.Parse(reader["Thang"].ToString());
obj.Nam = int.Parse(reader["Nam"].ToString());
reader.Close();
}
_connection.Close();
return(obj);
}
catch
(Exception ex)
{
_connection.Close();
}
return(null);
}
private void báoCáoCôngNợToolStripMenuItem_Click(object sender, EventArgs e)
{
BaoCaoCongNo f = new BaoCaoCongNo();
f.MdiParent = this;
f.Show();
}
private void BtBaoCaoCongNo_Click(object sender, RoutedEventArgs e)
{
BaoCaoCongNo baoCaoCongNo = new BaoCaoCongNo();
baoCaoCongNo.myEvent += new EventHandler(OnClosedBaoCaoCongNoWindow);
BtBaoCaoCongNo.IsEnabled = false;
baoCaoCongNo.Show();
}
// Chuyển giá trị trong Textbox thành BaoCaoCongNo
public BaoCaoCongNo Textbox_To_BaoCaoCongNo()
{
try
{
BaoCaoCongNo result = new BaoCaoCongNo();
result.id = (int)this.numbid.Value;
result.id_tblKhachHang = (int)this.numbid_tblKhachHang.Value;
result.noTien = (int)this.numbnoTien.Value;
result.ngayNo = this.datengayNo.Value;
result.moTa = (this.txtmoTa.Text == null ? null : (string)(this.txtmoTa.Text));
return(result);
}
catch (Exception ex) { ShowMessage(ex.Message, false); } // Không load được hoặc xảy ra lỗi
return(null);
}
// Chuyển giá trị trong DataGridView thành BaoCaoCongNo
public BaoCaoCongNo DataGridView_To_BaoCaoCongNo(int index)
{
try
{
BaoCaoCongNo result = new BaoCaoCongNo();
var id = this.dgvData.Rows[index].Cells["id"].Value;
if (id != null)
{
result.id = int.Parse(id.ToString());
}
var id_tblKhachHang = this.dgvData.Rows[index].Cells["id_tblKhachHang"].Value;
if (id_tblKhachHang != null)
{
result.id_tblKhachHang = (id_tblKhachHang == null ? null : (int?)int.Parse(id_tblKhachHang.ToString()));
}
var noTien = this.dgvData.Rows[index].Cells["noTien"].Value;
if (noTien != null)
{
result.noTien = (noTien == null ? null : (int?)int.Parse(noTien.ToString()));
}
var ngayNo = this.dgvData.Rows[index].Cells["ngayNo"].Value;
if (ngayNo != null)
{
result.ngayNo = (ngayNo == null ? null : (DateTime?)DateTime.Parse(ngayNo.ToString()));
}
var moTa = this.dgvData.Rows[index].Cells["moTa"].Value;
if (moTa != null)
{
result.moTa = (moTa == null ? null : (string)(moTa));
}
return(result);
}
catch (Exception ex) { ShowMessage(ex.Message, false); } // Không load được hoặc xảy ra lỗi
return(null);
}
public bool AddBaoCaoCongNo(BaoCaoCongNo bccn)
{
try
{
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
string sql = "insert into BaoCaoCongNo values(@MaBaoCao,@Thang,@Nam)";
SqlCommand cmd = new SqlCommand(sql, _connection);
cmd.Parameters.Add("@MaBaoCao", SqlDbType.Char).Value = bccn.MaBaoCaoCongNo;
cmd.Parameters.Add("@Thang", SqlDbType.Int).Value = bccn.Thang;
cmd.Parameters.Add("@Nam", SqlDbType.Int).Value = bccn.Nam;
cmd.ExecuteNonQuery();
_connection.Close();
return(true);
}
catch (Exception ex)
{
_connection.Close();
Console.WriteLine(ex.Message);
}
return(false);
}
public bool UpdateBaoCao(BaoCaoCongNo bccn)
{
return(objBCCN.UpdateBaoCao(bccn));
}
public bool AddBaoCao(BaoCaoCongNo bccn)
{
return(objBCCN.AddBaoCaoCongNo(bccn));
}
