public int insertKhuyenmaiPhong(BKIT.Entities.KhuyenmaiPhong objKhuyenmaiPhong)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "INSERT INTO KhuyenmaiPhong(IDKhuyenmai,IDNhomSP,NgayBD,NgayKT,Giam,Ghichu) " +
"VALUES (@idkhuyenmai,@idnhomsp,@ngaybd,@ngaykt,@giam,@ghichu)";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
int ID = GetNextAVailableID();
objKhuyenmaiPhong.IDKhuyenmai = ID;
db.AddInParameter(dbCommand, "idkhuyenmai", DbType.Int32, objKhuyenmaiPhong.IDKhuyenmai);
db.AddInParameter(dbCommand, "idnhomsp", DbType.Int32, objKhuyenmaiPhong.IDNhomSP);
db.AddInParameter(dbCommand, "ngaybd", DbType.DateTime, objKhuyenmaiPhong.NgayBD);
db.AddInParameter(dbCommand, "ngaykt", DbType.DateTime, objKhuyenmaiPhong.NgayKT);
db.AddInParameter(dbCommand, "giam", DbType.Int32, objKhuyenmaiPhong.Giam);
db.AddInParameter(dbCommand, "ghichu", DbType.String, objKhuyenmaiPhong.Ghichu);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(ID);
}
catch
{
dbCommand.Connection.Close();
return(-1);
}
}
public bool deleteKhuyenmaiPhong(BKIT.Entities.KhuyenmaiPhong objKhuyenmaiPhong)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "DELETE FROM KhuyenmaiPhong WHERE IDKhuyenmai = @idkhuyenmai";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
db.AddInParameter(dbCommand, "idkhuyenmai", DbType.Int32, objKhuyenmaiPhong.IDKhuyenmai);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(true);
}
catch
{
return(false);
}
}
public bool updateKhuyenmaiPhong(BKIT.Entities.KhuyenmaiPhong objKhuyenmaiPhong)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "UPDATE KhuyenmaiPhong SET IDNhomSP = @idnhomsp, NgayBD = @ngaybd, NgayKT = @ngaykt, Giam = @giam, Ghichu = @ghichu " +
"WHERE IDKhuyenmai = @idkhuyenmai";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
db.AddInParameter(dbCommand, "idnhomsp", DbType.Int32, objKhuyenmaiPhong.IDNhomSP);
db.AddInParameter(dbCommand, "ngaybd", DbType.DateTime, objKhuyenmaiPhong.NgayBD);
db.AddInParameter(dbCommand, "ngaykt", DbType.DateTime, objKhuyenmaiPhong.NgayKT);
db.AddInParameter(dbCommand, "giam", DbType.Int32, objKhuyenmaiPhong.Giam);
db.AddInParameter(dbCommand, "ghichu", DbType.String, objKhuyenmaiPhong.Ghichu);
db.AddInParameter(dbCommand, "idkhuyenmai", DbType.Int32, objKhuyenmaiPhong.IDKhuyenmai);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(true);
}
catch
{
return(false);
}
}
