public IEnumerable <qtUnit> DanhSachUnit()
{
qtUnitService _unit = new qtUnitService();
IEnumerable <qtUnit> dsUnit = _unit.FindList();
return(dsUnit);
}
public qtUnit ThemMoi_HieuChinhUnit(int UnitId, string UnitName, string UnitCode, int?ParentId, string LevelCode, int?SortOrder,
string Email, string PhoneNumber, bool?Status, DateTime?CreatedDate)
{
qtUnitService _unit = new qtUnitService();
qtUnit unit = new qtUnit();
if (UnitId > 0)
{
unit = _unit.FindByKey(UnitId);
}
unit.UnitName = UnitName;
unit.UnitCode = UnitCode;
unit.ParentId = ParentId;
unit.LevelCode = LevelCode;
unit.SortOrder = SortOrder;
unit.Email = Email;
unit.PhoneNumber = PhoneNumber;
unit.Status = Status;
unit.CreatedDate = CreatedDate;
if (UnitId > 0)
{
_unit.Update(unit);
}
else
{
_unit.Insert(unit);
}
return(unit);
}
public IPagedList <qtUnitManager> DanhSachNguoiDung(int page, int pageSize)
{
qtUserService _user = new qtUserService();
qtUnitService _unit = new qtUnitService();
qtUnitManagerService _mangager = new qtUnitManagerService();
var danhsach = (from mangager in _mangager.FindList()
join user in _user.FindList() on mangager.UserId equals user.UserId
select mangager).AsQueryable().GroupBy(m => m.UserId).Select(m => m.FirstOrDefault());
return(danhsach.ToPagedList(page, pageSize));
}
public int SoluongNguoiDung(int?unitId)
{
qtUserService _user = new qtUserService();
qtUnitService _unit = new qtUnitService();
qtUnitManagerService _mangager = new qtUnitManagerService();
var danhsach = (from mangager in _mangager.FindList()
join user in _user.FindList() on mangager.UserId equals user.UserId
where user.UnitId == unitId
select mangager).AsQueryable().GroupBy(m => m.UserId).Select(m => m.FirstOrDefault());
return(danhsach.Count());
}
public List <qtUnit> ListUnit_By_UserId(int?userid)
{
if (!userid.HasValue)
{
return(new List <qtUnit>());
}
qtUnitService _unit = new qtUnitService();
qtUnitManagerService _mangager = new qtUnitManagerService();
List <qtUnit> danhsach = _mangager.FindList().Where(m => m.UserId == userid.Value)
.Join(_unit.FindList().Where(m => m.Status == true), m => m.UnitId, u => u.UnitId, (m, u) => u)
.Distinct().ToList();
return(danhsach);
}
public string UnitName(int?UnitId)
{
string UnitName = string.Empty;
if (UnitId.HasValue)
{
qtUnitService _unit = new qtUnitService();
qtUnit unit = _unit.FindByKey(UnitId);
if (unit != null)
{
return(unit.UnitName);
}
return(UnitName);
}
return(UnitName);
}
public IEnumerable <qtUnit> GetUnitsByParentId(int?ParentId)
{
qtUnitService _unit = new qtUnitService();
return(_unit.FindList().Where(x => x.ParentId == ParentId));
}
public shGoodReceiptIsuue Insert_Update(
string ReceiptIsuueGuid,
int?ReceiptIssueId,
int?Phieu,
string ReceiptIsuueName,
string SKU,
int?MaKho,
string TenKho,
int?LoaiPhieu,
string MaDonHang,
string GhiChu,
int?UserId,
int?TrangThai,
bool?Status,
DateTime?CreateDate
)
{
shGoodReceiptIsuueService _receipt = new shGoodReceiptIsuueService();
shGoodReceiptIsuue receipt = new shGoodReceiptIsuue();
if (!string.IsNullOrEmpty(ReceiptIsuueGuid) || !string.IsNullOrWhiteSpace(ReceiptIsuueGuid))
{
receipt = _receipt.FindByKey(ReceiptIsuueGuid);
}
else
{
receipt.ReceiptIsuueGuid = GuidUnique.getInstance().GenerateUnique();
qtUnitService _unit = new qtUnitService();
string _TenKho = _unit.UnitName(MaKho);
if (string.IsNullOrEmpty(receipt.ReceiptIsuueName) && string.IsNullOrWhiteSpace(receipt.ReceiptIsuueName))
{
receipt.ReceiptIsuueName = StringHelper.ToUnsignString(_TenKho) + "-" + receipt.CreateDate.GetValueOrDefault(DateTime.Now).ToString("dd-MM-yyyy");
}
receipt.TenKho = _TenKho;
}
receipt.Phieu = Phieu;
receipt.SKU = SKU;
receipt.MaKho = MaKho;
receipt.LoaiPhieu = LoaiPhieu;
receipt.MaDonHang = MaDonHang;
receipt.GhiChu = GhiChu;
receipt.UserId = UserId;
receipt.TrangThai = TrangThai;
receipt.Status = Status;
receipt.CreateDate = CreateDate;
if (receipt.ReceiptIssueId > 0)
{
_receipt.Update(receipt);
}
else
{
_receipt.Insert(receipt);
}
return(receipt);
}