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); } }