public int insertKhuyenmai(BKIT.Entities.Khuyenmai objKhuyenmai)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "INSERT INTO Khuyenmai(IDKhuyenmai,IDNhomSP,NgayBD,NgayKT,Giam,Ghichu) " +
"VALUES (@idkhuyenmai,@idnhomsp,@ngaybd,@ngaykt,@giam,@ghichu)";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
int ID = GetNextAVailableID();
objKhuyenmai.IDKhuyenmai = ID;
db.AddInParameter(dbCommand, "idkhuyenmai", DbType.Int32, objKhuyenmai.IDKhuyenmai);
db.AddInParameter(dbCommand, "idnhomsp", DbType.Int32, objKhuyenmai.IDNhomSP);
db.AddInParameter(dbCommand, "ngaybd", DbType.DateTime, objKhuyenmai.NgayBD);
db.AddInParameter(dbCommand, "ngaykt", DbType.DateTime, objKhuyenmai.NgayKT);
db.AddInParameter(dbCommand, "giam", DbType.Int32, objKhuyenmai.Giam);
db.AddInParameter(dbCommand, "ghichu", DbType.String, objKhuyenmai.Ghichu);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(ID);
}
catch
{
dbCommand.Connection.Close();
return(-1);
}
}
public bool deleteKhuyenmai(BKIT.Entities.Khuyenmai objKhuyenmai)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "DELETE FROM Khuyenmai WHERE IDKhuyenmai = @idkhuyenmai";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
db.AddInParameter(dbCommand, "idkhuyenmai", DbType.Int32, objKhuyenmai.IDKhuyenmai);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(true);
}
catch
{
return(false);
}
}
public bool updateKhuyenmai(BKIT.Entities.Khuyenmai objKhuyenmai)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "UPDATE Khuyenmai 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, objKhuyenmai.IDNhomSP);
db.AddInParameter(dbCommand, "ngaybd", DbType.Date, objKhuyenmai.NgayBD.Date);
db.AddInParameter(dbCommand, "ngaykt", DbType.Date, objKhuyenmai.NgayKT.Date);
db.AddInParameter(dbCommand, "giam", DbType.Int32, objKhuyenmai.Giam);
db.AddInParameter(dbCommand, "ghichu", DbType.String, objKhuyenmai.Ghichu);
db.AddInParameter(dbCommand, "idkhuyenmai", DbType.Int32, objKhuyenmai.IDKhuyenmai);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(true);
}
catch
{
return(false);
}
}
