public bool updateVanDe(BKIT.Entities.VanDe objVanDe)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "UPDATE VanDe SET Ten = @Ten, IDLoaiVD = @IDLoaiVD, Tien = @Tien,UserID = @UserID, Ghichu = @Ghichu, NgayCapNhat = @NgayCapNhat " +
"WHERE IDVanDe = @IDVanDe";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
db.AddInParameter(dbCommand, "Ten", DbType.String, objVanDe.Ten);
db.AddInParameter(dbCommand, "IDLoaiVD", DbType.Int32, objVanDe.IDLoaiVD);
db.AddInParameter(dbCommand, "Tien", DbType.Decimal, objVanDe.Tien);
db.AddInParameter(dbCommand, "UserID", DbType.Int32, objVanDe.UserID);
db.AddInParameter(dbCommand, "Ghichu", DbType.String, objVanDe.GhiChu);
db.AddInParameter(dbCommand, "NgayCapNhat", DbType.DateTime, objVanDe.NgayCapNhat);
db.AddInParameter(dbCommand, "IDVanDe", DbType.Int32, objVanDe.IDVanDe);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(true);
}
catch
{
return(false);
}
}
public int insertVanDe(BKIT.Entities.VanDe objVanDe)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "INSERT INTO VanDe(IDVanDe,Ten,IDLoaiVD,Tien,UserID,Ghichu,NgayCapNhat) " +
"VALUES (@IDVanDe,@Ten,@IDLoaiVD,@Tien,@UserID,@Ghichu,@NgayCapNhat)";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
int ID = GetNextAVailableID();
objVanDe.IDVanDe = ID;
db.AddInParameter(dbCommand, "IDVanDe", DbType.Int32, objVanDe.IDVanDe);
db.AddInParameter(dbCommand, "Ten", DbType.String, objVanDe.Ten);
db.AddInParameter(dbCommand, "IDLoaiVD", DbType.Int32, objVanDe.IDLoaiVD);
db.AddInParameter(dbCommand, "Tien", DbType.Decimal, objVanDe.Tien);
db.AddInParameter(dbCommand, "UserID", DbType.Int32, objVanDe.UserID);
db.AddInParameter(dbCommand, "Ghichu", DbType.String, objVanDe.GhiChu);
db.AddInParameter(dbCommand, "NgayCapNhat", DbType.DateTime, objVanDe.NgayCapNhat);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(ID);
}
catch
{
dbCommand.Connection.Close();
return(-1);
}
}
public bool deleteVanDe(BKIT.Entities.VanDe objVanDe)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "DELETE FROM VanDe WHERE IDVanDe = @idVanDe";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
db.AddInParameter(dbCommand, "idVanDe", DbType.Int32, objVanDe.IDVanDe);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(true);
}
catch
{
return(false);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtTenGoiNho.Text))
{
MessageBox.Show("Nhập tên gợi nhớ cho ghi chú xử lý.");
txtTenGoiNho.Focus();
return;
}
if (string.IsNullOrEmpty(cboLoaiXuLy.Text))
{
MessageBox.Show("Chọn loại tình huống cho ghi chú xử lý.");
cboLoaiXuLy.Focus();
return;
}
VanDe objVande = new VanDe();
objVande.GhiChu = txtGhiChu.Text;
objVande.NgayCapNhat = DateTime.Now.Date;
objVande.Ten = txtTenGoiNho.Text;
objVande.IDLoaiVD = new DataAccess().getIDLoaiVDByTenLoaiVD(cboLoaiXuLy.Text);
objVande.UserID = Program.IDNhanvien;
if (!string.IsNullOrEmpty(txtTien.Text))
{
objVande.Tien = Convert.ToInt32(txtTien.Text);
}
if (new DataAccess().insertVanDe(objVande) >= 0)
{
MessageBox.Show("Thêm ghi chú thành công");
this.Close();
}
else
{
MessageBox.Show("Thêm ghi chú không thành công");
this.Close();
}
}
public bool updateVanDe(VanDe objVanDe)
{
return new VanDeService().updateVanDe(objVanDe);
}
public int insertVanDe(VanDe objVanDe)
{
return new VanDeService().insertVanDe(objVanDe);
}
public bool deleteVanDe(VanDe objVanDe)
{
return new VanDeService().deleteVanDe(objVanDe);
}