public async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
TransferObj <PagedObj <NvXuatKhacVm.Dto> > result = new TransferObj <PagedObj <NvXuatKhacVm.Dto> >();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvXuatKhacVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvXuatKhacVm.Search> >();
filtered.OrderBy = "NgayCT";
filtered.OrderType = "DESC";
PagedObj <NvVatTuChungTu> paged = ((JObject)postData.paged).ToObject <PagedObj <NvVatTuChungTu> >();
string unitCode = _service.GetCurrentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvVatTuChungTu().LoaiPhieu),
Method = FilterMethod.EqualTo,
Value = TypeVoucher.XKHAC.ToString()
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvVatTuChungTu().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
}
},
Method = FilterMethod.And
},
Orders = new List <IQueryOrder>()
{
new QueryOrder()
{
Field = ClassHelper.GetPropertyName(() => new NvVatTuChungTu().ICreateDate),
Method = OrderMethod.DESC
}
}
};
try
{
ResultObj <PagedObj <NvVatTuChungTu> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvVatTuChungTu>, PagedObj <NvXuatKhacVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception e)
{
return(InternalServerError());
}
}
private async Task <PagedObj <TEntity> > QueryPagedAsync(IQueryBuilder query)
{
var result = new PagedObj <TEntity>();
IQueryable <TEntity> data = _repository.Queryable();
var filterString = query.BuildFilter();
var orderString = query.BuildOrder();
if (!string.IsNullOrEmpty(filterString))
{
data = data.Where(filterString, query.Filter.QueryStringParams.Params.ToArray());
}
if (!string.IsNullOrEmpty(orderString))
{
data = data.OrderBy(orderString);
}
result.totalItems = await data.CountAsync();
if (query.Skip > 0)
{
data = data.Skip(query.Skip);
}
if (query.Take > 0)
{
data = data.Take(query.Take);
}
result.Data.AddRange(await data.ToListAsync());
return(result);
}
public async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
TransferObj <PagedObj <NvCongNoVm.Dto> > result = new TransferObj <PagedObj <NvCongNoVm.Dto> >();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvCongNoVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvCongNoVm.Search> >();
PagedObj <NvCongNo> paged = ((JObject)postData.paged).ToObject <PagedObj <NvCongNo> >();
string unitCode = _service.GetCurrentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvCongNo().LoaiChungTu),
Method = FilterMethod.EqualTo,
Value = filtered.AdvanceData.LoaiChungTu
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvCongNo().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
}
},
Method = FilterMethod.And
},
Orders = new List <IQueryOrder>()
{
new QueryOrder()
{
Field = ClassHelper.GetPropertyName(() => new NvCongNo().ICreateDate),
Method = OrderMethod.DESC
}
}
};
try
{
ResultObj <PagedObj <NvCongNo> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvCongNo>, PagedObj <NvCongNoVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Status = false;
result.Message = e.Message.ToString();
return(Ok(result));
}
}
public async Task <IHttpActionResult> PostQuerySummary(JObject jsonData)
{
TransferObj <PagedObj <NvPhieuDatHangNCCVm.Dto> > result = new TransferObj <PagedObj <NvPhieuDatHangNCCVm.Dto> >();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvPhieuDatHangNCCVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvPhieuDatHangNCCVm.Search> >();
filtered.OrderType = "DESC";
filtered.OrderBy = "Ngay";
PagedObj <NvDatHang> paged = ((JObject)postData.paged).ToObject <PagedObj <NvDatHang> >();
string unitCode = _service.GetCurrentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvDatHang().SoPhieuCon),
Method = FilterMethod.NotNull,
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvDatHang().Loai),
Method = FilterMethod.EqualTo,
Value = (int)LoaiDatHang.NHACUNGCAP
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvVatTuChungTu().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
}
},
Method = FilterMethod.And
},
};
try
{
ResultObj <PagedObj <NvDatHang> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvDatHang>, PagedObj <NvPhieuDatHangNCCVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception)
{
return(InternalServerError());
}
}
public async Task <IHttpActionResult> PostSelectData(JObject jsonData)
{
TransferObj result = new TransferObj();
dynamic postData = ((dynamic)jsonData);
FilterObj <AuNguoiDungVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <AuNguoiDungVm.Search> >();
PagedObj <AU_NGUOIDUNG> paged = ((JObject)postData.paged).ToObject <PagedObj <AU_NGUOIDUNG> >();
string unitCode = _service.GetCurrentUnitCode();
string maDonViCha = _service.GetParentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new AU_NGUOIDUNG().UnitCode),
Method = FilterMethod.StartsWith,
Value = maDonViCha
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new AU_NGUOIDUNG().TenNhanVien),
Method = FilterMethod.Like,
Value = filtered.Summary
}
},
Method = FilterMethod.And
}
};
try
{
ResultObj <PagedObj <AU_NGUOIDUNG> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <AU_NGUOIDUNG>, PagedObj <ChoiceObj> >
(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
string _unitCode = _service.GetCurrentUnitCode();
TransferObj <PagedObj <NvGiaoDichQuayVm.Dto> > result = new TransferObj <PagedObj <NvGiaoDichQuayVm.Dto> >();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvGiaoDichQuayVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvGiaoDichQuayVm.Search> >();
filtered.OrderBy = "NgayPhatSinh";
PagedObj <NvGiaoDichQuay> paged = ((JObject)postData.paged).ToObject <PagedObj <NvGiaoDichQuay> >();
string unitCode = _service.GetCurrentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvGiaoDichQuay().MaDonVi),
Method = FilterMethod.StartsWith,
Value = _unitCode
},
Orders = new List <IQueryOrder>
{
new QueryOrder()
{
Field = ClassHelper.GetPropertyName(() => new NvGiaoDichQuay().NgayPhatSinh),
Method = OrderMethod.DESC
}
}
};
try
{
ResultObj <PagedObj <NvGiaoDichQuay> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvGiaoDichQuay>, PagedObj <NvGiaoDichQuayVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception)
{
return(InternalServerError());
}
}
public async Task <IHttpActionResult> PostPrint(JObject jsonData)
{
List <NvXuatKhacVm.Dto> result = new List <NvXuatKhacVm.Dto>();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvXuatKhacVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvXuatKhacVm.Search> >();
PagedObj <NvVatTuChungTu> paged = ((JObject)postData.paged).ToObject <PagedObj <NvVatTuChungTu> >();
string unitCode = _service.GetCurrentUnitCode();
QueryBuilder query = new QueryBuilder
{
TakeAll = true,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvVatTuChungTu().LoaiPhieu),
Method = FilterMethod.EqualTo,
Value = TypeVoucher.XKHAC.ToString()
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvVatTuChungTu().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
}
},
Method = FilterMethod.And
}
};
try
{
ResultObj <PagedObj <NvVatTuChungTu> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result = Mapper.Map <List <NvVatTuChungTu>, List <NvXuatKhacVm.Dto> >(filterResult.Value.Data);
return(Ok(result));
}
catch (Exception e)
{
return(InternalServerError());
}
}
public async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
var result = new TransferObj();
var postData = ((dynamic)jsonData);
var paged = new PagedObj <MdXuatXu>();
var filtered = ((JObject)postData.filtered).ToObject <FilterObj <MdXuatXuVm.Search> >();
paged = ((JObject)postData.paged).ToObject <PagedObj <MdXuatXu> >();
var maDonViCha = _service.GetParentUnitCode();
var query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new MdXuatXu().UnitCode),
Method = FilterMethod.StartsWith,
Value = maDonViCha
},
Orders = new List <IQueryOrder>()
{
new QueryOrder()
{
Field = ClassHelper.GetPropertyName(() => new MdXuatXu().MaXuatXu),
Method = OrderMethod.ASC
}
}
};
try
{
var filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = filterResult.Value;
result.Status = true;
return(Ok(result));
}
catch (Exception)
{
return(InternalServerError());
}
}
public IHttpActionResult PostQuery(JObject jsonData)
{
TransferObj <PagedObj <CHUNGTU> > result = new TransferObj <PagedObj <CHUNGTU> >();
var postData = ((dynamic)jsonData);
var filtered = ((JObject)postData.filtered).ToObject <FilterObj <NhapMuaViewModel.Search> >();
var paged = ((JObject)postData.paged).ToObject <PagedObj <CHUNGTU> >();
var unitCode = _service.GetCurrentUnitCode();
try
{
PagedObj <CHUNGTU> tempData = _service.QueryPageChungTu(_service.GetConnectionString(), paged, filtered.Summary, unitCode);
result.Data = tempData;
result.Status = true;
return(Ok(result));
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public IHttpActionResult PostQuery(JObject jsonData)
{
TransferObj <PagedObj <LOAIHANG> > result = new TransferObj <PagedObj <LOAIHANG> >();
var postData = ((dynamic)jsonData);
var filtered = ((JObject)postData.filtered).ToObject <FilterObj <LoaiHangViewModel.Search> >();
var paged = ((JObject)postData.paged).ToObject <PagedObj <LOAIHANG> >();
var unitCode = string.IsNullOrEmpty(filtered.PARENT_UNITCODE) ? filtered.UNITCODE : filtered.PARENT_UNITCODE;
try
{
PagedObj <LOAIHANG> tempData = _service.QueryPageLoaiHang(_service.GetConnectionString(), paged, filtered.Summary, unitCode);
result.Data = tempData;
result.Status = true;
return(Ok(result));
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public IHttpActionResult PostQuery(JObject jsonData)
{
TransferObj <PagedObj <DatPhongViewModel.ViewModel> > result = new TransferObj <PagedObj <DatPhongViewModel.ViewModel> >();
var postData = ((dynamic)jsonData);
var filtered = ((JObject)postData.filtered).ToObject <FilterObj <DatPhongViewModel.Search> >();
var paged = ((JObject)postData.paged).ToObject <PagedObj <DatPhongViewModel.ViewModel> >();
var unitCode = _service.GetCurrentUnitCode();
try
{
PagedObj <DatPhongViewModel.ViewModel> tempData = _service.QueryBookingRoom(_service.GetConnectionString(), paged, filtered.AdvanceData.MAPHONG, unitCode);
result.Data = tempData;
result.Status = true;
return(Ok(result));
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public async Task <PagedObj <TEntity> > QueryPagedAsync(IQueryBuilder query,
List <Expression <Func <TEntity, object> > > includes = null)
{
var result = new PagedObj <TEntity> {
ItemsPerPage = query.Take
};
IQueryable <TEntity> data = Get(query, includes);
result.TotalItems = await data.CountAsync();
if (query.Skip > 0)
{
data = data.Skip(query.Skip);
}
if (query.Take > 0)
{
data = data.Take(query.Take);
}
result.Data.AddRange(await data.ToListAsync());
return(result);
}
public PagedObj <TEntity> QueryPaged(IQueryBuilder query, List <Expression <Func <TEntity, object> > > includes = null)
{
var result = new PagedObj <TEntity>
{
ItemsPerPage = query.Take,
FromItem = query.Skip + 1,
};
IQueryable <TEntity> data = Get(query, includes);
result.TotalItems = data.Count();
if (query.Skip > 0)
{
data = data.Skip(query.Skip);
}
if (query.Take > 0)
{
data = data.Take(query.Take);
}
result.Data.AddRange(data.ToList());
return(result);
}
public IHttpActionResult PostQueryInventory(JObject jsonData)
{
TransferObj <PagedObj <MatHangViewModel.VIEW_MODEL> > result = new TransferObj <PagedObj <MatHangViewModel.VIEW_MODEL> >();
var postData = ((dynamic)jsonData);
var filtered = ((JObject)postData.filtered).ToObject <FilterObj <MatHangViewModel.Search> >();
var paged = ((JObject)postData.paged).ToObject <PagedObj <MatHangViewModel.VIEW_MODEL> >();
var unitCode = _service.GetCurrentUnitCode();
try
{
string TableName = filtered.AdvanceData.TABLE_NAME;
string MaKho = filtered.AdvanceData.MAKHO;
PagedObj <MatHangViewModel.VIEW_MODEL> tempData = _service.QueryPageMatHangInventory(_service.GetConnectionString(), paged, filtered.Summary, unitCode, TableName, MaKho);
result.Data = tempData;
result.Status = true;
return(Ok(result));
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
TransferObj <PagedObj <NvKiemKeVm.Dto> > result = new TransferObj <PagedObj <NvKiemKeVm.Dto> >();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvKiemKeVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvKiemKeVm.Search> >();
filtered.OrderType = "DESC";
filtered.OrderBy = "NgayKiemKe";
PagedObj <NvKiemKe> paged = ((JObject)postData.paged).ToObject <PagedObj <NvKiemKe> >();
string unitCode = _serviceKK.GetCurrentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvKiemKe().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
},
};
try
{
ResultObj <PagedObj <NvKiemKe> > filterResult = _serviceKK.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvKiemKe>, PagedObj <NvKiemKeVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception)
{
return(InternalServerError());
}
}
public PagedObj <DatPhongViewModel.ViewModel> QueryBookingRoom(string stringConnect, PagedObj <DatPhongViewModel.ViewModel> page, string maPhong, string maDonVi)
{
var TotalItem = 0;
List <DatPhongViewModel.ViewModel> ListBookingRoom = new List <DatPhongViewModel.ViewModel>();
try
{
using (OracleConnection connection = new OracleConnection(stringConnect))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"TIMKIEM_DATPHONG_PAGINATION";
command.Parameters.Add(@"P_MADONVI", OracleDbType.NVarchar2, 50).Value = maDonVi;
command.Parameters.Add(@"P_MAPHONG", OracleDbType.NVarchar2, 500).Value = maPhong.ToString().ToUpper().Trim();
command.Parameters.Add(@"P_PAGENUMBER", OracleDbType.Int32).Value = page.CurrentPage;
command.Parameters.Add(@"P_PAGESIZE", OracleDbType.Int32).Value = page.ItemsPerPage;
command.Parameters.Add(@"P_TOTALITEM", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
command.Parameters.Add(@"CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["TOTAL_ITEM"] != null)
{
int.TryParse(dataReader["TOTAL_ITEM"].ToString(), out TotalItem);
}
}
if (dataReader.NextResult())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
DatPhongViewModel.ViewModel DatPhong = new DatPhongViewModel.ViewModel();
if (dataReader["ID"] != null)
{
DatPhong.ID = dataReader["ID"].ToString();
}
if (dataReader["MA_DATPHONG"] != null)
{
DatPhong.MA_DATPHONG = dataReader["MA_DATPHONG"].ToString();
}
if (dataReader["MAPHONG"] != null)
{
DatPhong.MAPHONG = dataReader["MAPHONG"].ToString();
}
if (dataReader["THOIGIAN_DATPHONG"] != null)
{
DatPhong.THOIGIAN_DATPHONG = dataReader["THOIGIAN_DATPHONG"].ToString();
}
if (dataReader["TEN_KHACHHANG"] != null)
{
DatPhong.TEN_KHACHHANG = dataReader["TEN_KHACHHANG"].ToString();
}
if (dataReader["DIENTHOAI"] != null)
{
DatPhong.DIENTHOAI = dataReader["DIENTHOAI"].ToString();
}
if (dataReader["CANCUOC_CONGDAN"] != null)
{
DatPhong.CANCUOC_CONGDAN = dataReader["CANCUOC_CONGDAN"].ToString();
}
if (dataReader["DIENGIAI"] != null)
{
DatPhong.DIENGIAI = dataReader["DIENGIAI"].ToString();
}
if (dataReader["TRANGTHAI"] != DBNull.Value)
{
int TRANGTHAI = 0;
int.TryParse(dataReader["TRANGTHAI"].ToString(), out TRANGTHAI);
DatPhong.TRANGTHAI = TRANGTHAI;
}
if (dataReader["NGAY_DATPHONG"] != null)
{
DatPhong.NGAY_DATPHONG = GetNullableDateTime(dataReader, "NGAY_DATPHONG");
}
if (dataReader["MALOAIPHONG"] != null)
{
DatPhong.MALOAIPHONG = dataReader["MALOAIPHONG"].ToString();
}
if (dataReader["UNITCODE"] != null)
{
DatPhong.UNITCODE = dataReader["UNITCODE"].ToString();
}
ListBookingRoom.Add(DatPhong);
}
}
}
}
dataReader.Close();
page.Data = ListBookingRoom;
page.TotalItems = TotalItem;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch
{
throw new Exception("Lỗi không thể truy xuất hàng hóa");
}
return(page);
}
public async Task <IHttpActionResult> PostSelectData(JObject jsonData)
{
TransferObj <PagedObj <NvDatHang> > result = new TransferObj <PagedObj <NvDatHang> >();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvPhieuDatHangNCCVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvPhieuDatHangNCCVm.Search> >();
filtered.OrderBy = "Ngay";
filtered.OrderType = "DESC";
PagedObj <NvDatHang> paged = ((JObject)postData.paged).ToObject <PagedObj <NvDatHang> >();
string parentUnitCode = _service.GetParentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => new NvDatHang().UnitCode),
Method = FilterMethod.StartsWith,
Value = parentUnitCode
},
new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => new NvDatHang().TrangThai),
Method = FilterMethod.EqualTo,
Value = (int)OrderState.IsApproval
},
new QueryFilterLinQ
{
Property = ClassHelper.GetProperty(() => new NvDatHang().MaNhaCungCap),
Method = FilterMethod.EqualTo,
Value = filtered.AdvanceData.MaNhaCungCap
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvDatHang().Loai),
Method = FilterMethod.EqualTo,
Value = (int)LoaiDatHang.NHACUNGCAP
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvDatHang().SoPhieuCon),
Method = FilterMethod.Null,
}
},
Method = FilterMethod.And
},
Orders = new List <IQueryOrder>()
{
new QueryOrder()
{
Field = ClassHelper.GetPropertyName(() => new NvDatHang().ICreateDate),
Method = OrderMethod.DESC
}
}
};
try
{
ResultObj <PagedObj <NvDatHang> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = filterResult.Value;
result.Status = true;
return(Ok(result));
}
catch (Exception)
{
return(InternalServerError());
}
}
public PagedObj <KHOHANG> QueryPageKhoHang(string stringConnect, PagedObj <KHOHANG> page, string strKey, string maDonVi)
{
var TotalItem = 0;
List <KHOHANG> ListMatHang = new List <KHOHANG>();
try
{
using (OracleConnection connection = new OracleConnection(stringConnect))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"TIMKIEM_KHOHANG_PAGINATION";
command.Parameters.Add(@"P_MADONVI", OracleDbType.NVarchar2, 50).Value = maDonVi;
command.Parameters.Add(@"P_TUKHOA", OracleDbType.NVarchar2, 500).Value = strKey.ToString().ToUpper().Trim();
command.Parameters.Add(@"P_PAGENUMBER", OracleDbType.Int32).Value = page.CurrentPage;
command.Parameters.Add(@"P_PAGESIZE", OracleDbType.Int32).Value = page.ItemsPerPage;
command.Parameters.Add(@"P_TOTALITEM", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
command.Parameters.Add(@"CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["TOTAL_ITEM"] != null)
{
int.TryParse(dataReader["TOTAL_ITEM"].ToString(), out TotalItem);
}
}
if (dataReader.NextResult())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
KHOHANG MatHang = new KHOHANG();
if (dataReader["ID"] != null)
{
MatHang.ID = dataReader["ID"].ToString();
}
if (dataReader["MAKHO"] != null)
{
MatHang.MAKHO = dataReader["MAKHO"].ToString();
}
if (dataReader["TENKHO"] != null)
{
MatHang.TENKHO = dataReader["TENKHO"].ToString();
}
if (dataReader["DIENGIAI"] != null)
{
MatHang.DIENGIAI = dataReader["DIENGIAI"].ToString();
}
if (dataReader["UNITCODE"] != null)
{
MatHang.UNITCODE = dataReader["UNITCODE"].ToString();
}
if (dataReader["TRANGTHAI"] != DBNull.Value)
{
MatHang.TRANGTHAI = int.Parse(dataReader["TRANGTHAI"].ToString());
}
ListMatHang.Add(MatHang);
}
}
}
}
dataReader.Close();
page.Data = ListMatHang;
page.TotalItems = TotalItem;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch
{
throw new Exception("Lỗi không thể truy xuất kho hàng");
}
return(page);
}
public PagedObj <KHUYENMAI> QueryPageGiamGiaNhaCungCap(string stringConnect, PagedObj <KHUYENMAI> page, string strKey, string maDonVi)
{
var TotalItem = 0;
List <KHUYENMAI> ListKhuyenMai = new List <KHUYENMAI>();
try
{
using (OracleConnection connection = new OracleConnection(stringConnect))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"TIMKIEM_KHUYENMAI_PAGINATION";
command.Parameters.Add(@"P_MADONVI", OracleDbType.NVarchar2, 50).Value = maDonVi;
command.Parameters.Add(@"P_TUKHOA", OracleDbType.NVarchar2, 500).Value = strKey.ToString().ToUpper().Trim();
command.Parameters.Add(@"P_PAGENUMBER", OracleDbType.Int32).Value = page.CurrentPage;
command.Parameters.Add(@"P_PAGESIZE", OracleDbType.Int32).Value = page.ItemsPerPage;
command.Parameters.Add(@"P_LOAI_KHUYENMAI", OracleDbType.NVarchar2, 20).Value = TypeBuildCode.GGNHACUNGCAP.ToString();
command.Parameters.Add(@"P_TOTALITEM", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
command.Parameters.Add(@"CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["TOTAL_ITEM"] != null)
{
int.TryParse(dataReader["TOTAL_ITEM"].ToString(), out TotalItem);
}
}
if (dataReader.NextResult())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
KHUYENMAI KhuyenMai = new KHUYENMAI();
if (dataReader["ID"] != null)
{
KhuyenMai.ID = dataReader["ID"].ToString();
}
if (dataReader["MA_KHUYENMAI"] != null)
{
KhuyenMai.MA_KHUYENMAI = dataReader["MA_KHUYENMAI"].ToString();
}
if (dataReader["TUNGAY"] != DBNull.Value)
{
KhuyenMai.TUNGAY = DateTime.Parse(dataReader["TUNGAY"].ToString());
}
if (dataReader["DENNGAY"] != DBNull.Value)
{
KhuyenMai.DENNGAY = DateTime.Parse(dataReader["DENNGAY"].ToString());
}
if (dataReader["THOIGIAN_TAO"] != null)
{
KhuyenMai.THOIGIAN_TAO = dataReader["THOIGIAN_TAO"].ToString();
}
if (dataReader["TUGIO"] != null)
{
KhuyenMai.TUGIO = dataReader["TUGIO"].ToString();
}
if (dataReader["DENGIO"] != null)
{
KhuyenMai.DENGIO = dataReader["DENGIO"].ToString();
}
if (dataReader["MAKHO_KHUYENMAI"] != null)
{
KhuyenMai.MAKHO_KHUYENMAI = dataReader["MAKHO_KHUYENMAI"].ToString();
}
if (dataReader["DIENGIAI"] != null)
{
KhuyenMai.DIENGIAI = dataReader["DIENGIAI"].ToString();
}
if (dataReader["UNITCODE"] != null)
{
KhuyenMai.UNITCODE = dataReader["UNITCODE"].ToString();
}
if (dataReader["TRANGTHAI"] != DBNull.Value)
{
int TRANGTHAI = 0;
int.TryParse(dataReader["TRANGTHAI"].ToString(), out TRANGTHAI);
KhuyenMai.TRANGTHAI = TRANGTHAI;
}
if (dataReader["I_CREATE_DATE"] != DBNull.Value)
{
KhuyenMai.I_CREATE_DATE = DateTime.Parse(dataReader["I_CREATE_DATE"].ToString());
}
ListKhuyenMai.Add(KhuyenMai);
}
}
}
}
dataReader.Close();
page.Data = ListKhuyenMai;
page.TotalItems = TotalItem;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch
{
throw new Exception("Lỗi không thể truy xuất chương trình khuyến mãi");
}
return(page);
}
public PagedObj <CHUNGTU> QueryPageChungTu(string stringConnect, PagedObj <CHUNGTU> page, string strKey, string maDonVi)
{
var TotalItem = 0;
List <CHUNGTU> ListChungTu = new List <CHUNGTU>();
try
{
using (OracleConnection connection = new OracleConnection(stringConnect))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"TIMKIEM_CHUNGTU_PAGINATION";
command.Parameters.Add(@"P_MADONVI", OracleDbType.NVarchar2, 50).Value = maDonVi;
command.Parameters.Add(@"P_TUKHOA", OracleDbType.NVarchar2, 500).Value = strKey.ToString().ToUpper().Trim();
command.Parameters.Add(@"P_PAGENUMBER", OracleDbType.Int32).Value = page.CurrentPage;
command.Parameters.Add(@"P_PAGESIZE", OracleDbType.Int32).Value = page.ItemsPerPage;
command.Parameters.Add(@"P_LOAI_CHUNGTU", OracleDbType.NVarchar2, 50).Value = TypeBuildCode.XBAN.ToString();
command.Parameters.Add(@"P_TOTALITEM", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
command.Parameters.Add(@"CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["TOTAL_ITEM"] != null)
{
int.TryParse(dataReader["TOTAL_ITEM"].ToString(), out TotalItem);
}
}
if (dataReader.NextResult())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
CHUNGTU ChungTu = new CHUNGTU();
if (dataReader["ID"] != null)
{
ChungTu.ID = dataReader["ID"].ToString();
}
if (dataReader["MA_CHUNGTU"] != null)
{
ChungTu.MA_CHUNGTU = dataReader["MA_CHUNGTU"].ToString();
}
if (dataReader["NGAY_CHUNGTU"] != DBNull.Value)
{
ChungTu.NGAY_CHUNGTU = DateTime.Parse(dataReader["NGAY_CHUNGTU"].ToString());
}
if (dataReader["NGAY_DUYETPHIEU"] != DBNull.Value)
{
ChungTu.NGAY_DUYETPHIEU = DateTime.Parse(dataReader["NGAY_DUYETPHIEU"].ToString());
}
if (dataReader["MAKHO_NHAP"] != null)
{
ChungTu.MAKHO_NHAP = dataReader["MAKHO_NHAP"].ToString();
}
if (dataReader["MAKHO_XUAT"] != null)
{
ChungTu.MAKHO_XUAT = dataReader["MAKHO_XUAT"].ToString();
}
if (dataReader["TRANGTHAI"] != null)
{
int TRANGTHAI = 0;
int.TryParse(dataReader["TRANGTHAI"].ToString(), out TRANGTHAI);
ChungTu.TRANGTHAI = TRANGTHAI;
}
if (dataReader["MANHACUNGCAP"] != null)
{
ChungTu.MANHACUNGCAP = dataReader["MANHACUNGCAP"].ToString();
}
if (dataReader["MAKHACHHANG"] != null)
{
ChungTu.MAKHACHHANG = dataReader["MAKHACHHANG"].ToString();
}
ListChungTu.Add(ChungTu);
}
}
}
}
dataReader.Close();
page.Data = ListChungTu;
page.TotalItems = TotalItem;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch
{
throw new Exception("Lỗi không thể truy xuất hàng hóa");
}
return(page);
}
public PagedObj <XuatBanLeThuNganViewModel.View> QueryPageGiaoDich(string stringConnect, PagedObj <XuatBanLeThuNganViewModel.View> page, string strKey, string maDonVi)
{
var TotalItem = 0;
List <XuatBanLeThuNganViewModel.View> ListGiaoDich = new List <XuatBanLeThuNganViewModel.View>();
try
{
using (OracleConnection connection = new OracleConnection(stringConnect))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"TIMKIEM_GIAODICH_PAGINATION";
command.Parameters.Add(@"P_MADONVI", OracleDbType.NVarchar2, 50).Value = maDonVi;
command.Parameters.Add(@"P_TUKHOA", OracleDbType.NVarchar2, 500).Value = strKey.ToString().ToUpper().Trim();
command.Parameters.Add(@"P_PAGENUMBER", OracleDbType.Int32).Value = page.CurrentPage;
command.Parameters.Add(@"P_PAGESIZE", OracleDbType.Int32).Value = page.ItemsPerPage;
command.Parameters.Add(@"P_TOTALITEM", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
command.Parameters.Add(@"CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["TOTAL_ITEM"] != null)
{
int.TryParse(dataReader["TOTAL_ITEM"].ToString(), out TotalItem);
}
}
if (dataReader.NextResult())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
XuatBanLeThuNganViewModel.View GiaoDich = new XuatBanLeThuNganViewModel.View();
if (dataReader["ID"] != null)
{
GiaoDich.ID = dataReader["ID"].ToString();
}
if (dataReader["MA_GIAODICH"] != null)
{
GiaoDich.MA_GIAODICH = dataReader["MA_GIAODICH"].ToString();
}
if (dataReader["LOAI_GIAODICH"] != null)
{
GiaoDich.LOAI_GIAODICH = dataReader["LOAI_GIAODICH"].ToString();
}
if (dataReader["NGAY_GIAODICH"] != DBNull.Value)
{
GiaoDich.NGAY_GIAODICH = DateTime.Parse(dataReader["NGAY_GIAODICH"].ToString());
}
if (dataReader["MAKHACHHANG"] != null)
{
GiaoDich.MAKHACHHANG = dataReader["MAKHACHHANG"].ToString();
}
if (dataReader["THOIGIAN_TAO"] != null)
{
GiaoDich.THOIGIAN_TAO = dataReader["THOIGIAN_TAO"].ToString();
}
if (dataReader["TIENKHACH_TRA"] != DBNull.Value)
{
GiaoDich.TIENKHACH_TRA = decimal.Parse(dataReader["TIENKHACH_TRA"].ToString());
}
if (dataReader["TIEN_TRALAI_KHACH"] != DBNull.Value)
{
GiaoDich.TIEN_TRALAI_KHACH = decimal.Parse(dataReader["TIEN_TRALAI_KHACH"].ToString());
}
if (dataReader["MAKHO_XUAT"] != null)
{
GiaoDich.MAKHO_XUAT = dataReader["MAKHO_XUAT"].ToString();
}
if (dataReader["DIENGIAI"] != null)
{
GiaoDich.MAKHACHHANG = dataReader["DIENGIAI"].ToString();
}
ListGiaoDich.Add(GiaoDich);
}
}
}
}
dataReader.Close();
page.Data = ListGiaoDich;
page.TotalItems = TotalItem;
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch
{
throw new Exception("Lỗi không thể truy xuất phiếu nhập mua");
}
return(page);
}
