protected override IQueryable <UserList> MainQuery(InventoryDbEntities context)
{
var query = (from row in context.UserLists
select row).OrderBy(row => row.UserId);
return(query);
}
private AccountRole GetLoginLevel(string userName)
{
using (var db = new InventoryDbEntities())
{
return((AccountRole)(db.GetLoginLevel(userName).First() ?? -1));
}
}
public DataTable GetItemCabinetHas()
{
using (var context = new InventoryDbEntities())
{
return(HelperMethods.LINQToDataTable(context.GetCurrentItemsCabinetHas((int)Grid.SelectedRows[0].Cells["CabinetId"].Value)));
}
}
public virtual DataTable GetFilterdDataTable(string s)
{
using (var context = new InventoryDbEntities())
{
return(HelperMethods.LINQToDataTable(FilteredQuery(context, s).ToList()));
}
}
protected override IQueryable <TransPermissionList> MainQuery(InventoryDbEntities context)
{
var query = (from row in context.TransPermissionList
select row
).OrderBy(row => row.PermissionId);
return(query);
}
protected override IQueryable <CabinetList> MainQuery(InventoryDbEntities context)
{
var query = (from item in context.CabinetLists
select item
).OrderBy(row => row.CabinetId);
return(query);
}
protected override IQueryable <CatList> FilteredQuery(InventoryDbEntities context, string like)
{
var query = (from itemCat in context.CatLists
where itemCat.Category_Name.ToLower().Contains(like)
orderby itemCat.CatId
select itemCat);
return(query);
}
public DataTable GetSalesOfItem()
{
int itemId = (int)Grid.SelectedRows[0].Cells["ItemId"].Value;
using (var context = new InventoryDbEntities())
{
return(HelperMethods.LINQToDataTable(context.GetSalesOfItem(itemId)));
}
}
public virtual DataTable GetMainGridDataTable(int page)
{
CurrentPage = page;
using (var context = new InventoryDbEntities())
{
var paged = PagedResult(MainQuery(context), page);
return(HelperMethods.LINQToDataTable(paged.ToList()));
}
}
public DataTable GetItemTransactionOfCabinet()
{
int cabinetId = (int)Grid.SelectedRows[0].Cells["CabinetId"].Value;
int itemId = (int)OnHandReport.Grid.SelectedRows[0].Cells["ItemId"].Value;
using (var context = new InventoryDbEntities())
{
return(HelperMethods.LINQToDataTable(context.GetItemTransactionsOfCabinet(cabinetId, itemId).OrderBy(r => r.ActionDate)));
}
}
protected override IQueryable <CabinetTypeList> FilteredQuery(InventoryDbEntities context, string like)
{
var query = (from row in context.CabinetTypeLists
where row.Description.ToLower().Contains(like) ||
row.Name.ToLower().Contains(like)
orderby row.CabinetTypeId
select row);
return(query);
}
protected override IQueryable <ItemList> FilteredQuery(InventoryDbEntities context, string like)
{
var query = (from item in context.ItemLists
where item.ItemCode.ToLower().Contains(like) ||
item.ItemName.ToLower().Contains(like)
orderby item.ItemId
select item);
return(query);
}
private int GetUserId(string username)
{
using (var context = new InventoryDbEntities())
{
if (!IdTranslater.GetUserId(username, out var id, context))
{
return(-1);
}
return(id ?? -1);
}
}
public ItemController(IViewer view) : base(view)
{
ParseFunc = new Func <List <string[]>, List <Item> >((c) => (new EntityParser(UserId).ParseToItems(c)));
InsertAction = new Func <List <Item>, int>((e) =>
{
using (var context = new InventoryDbEntities())
{
context.Items.AddRange(e);
return(context.SaveChanges());
}
});
}
public static bool GetProviderId(string name, out int?id, InventoryDbEntities context)
{
id = null;
var provider = context.Providers.FirstOrDefault(e => string.Compare(name, e.Name, true) == 0);
if (provider == null)
{
return(false);
}
id = provider.ProviderId;
return(true);
}
public LoginForm()
{
InitializeComponent();
SetVer();
SetServer();
var test = new InventoryDbEntities();
#if DEBUG
textBoxUsername.Text = "luu.nhat-hong";
textBoxPwd.Text = "Dant@760119";
#endif
}
public static bool GetCatId(string name, out int?id, InventoryDbEntities context)
{
id = null;
var cat = context.ItemCats.FirstOrDefault(e => string.Compare(name, e.CatName, true) == 0);
if (cat == null)
{
return(false);
}
id = cat.CatId;
return(true);
}
public void RefreshPageNumber()
{
using (var context = new InventoryDbEntities())
{
TotalRows = MainQuery(context).Count();
TotalPages = (TotalRows + ItemPerPage - 1) / ItemPerPage;
if (TotalPages < 1)
{
TotalPages = 1;
}
}
}
public static bool GetItemId(string name, out int?id, InventoryDbEntities context)
{
id = null;
var item = context.Items.FirstOrDefault(e => string.Compare(name, e.ItemCode, true) == 0);
if (item == null)
{
return(false);
}
id = item.ItemId;
return(true);
}
public static bool GetCabinetTypeId(string name, out int?id, InventoryDbEntities context)
{
id = null;
var type = context.CabinetTypes.FirstOrDefault(e => string.Compare(name, e.Name, true) == 0);
if (type == null)
{
return(false);
}
id = type.CabinetTypeId;
return(true);
}
protected override IQueryable <UserList> FilteredQuery(InventoryDbEntities context, string like)
{
var query = (from row in context.UserLists
where
row.Username.ToLower().Contains(like) ||
row.RoleName.ToLower().Contains(like) ||
row.Note.ToString().ToLower().Contains(like)
orderby row.UserId
select row);
return(query);
}
protected override IQueryable <ProviderList> FilteredQuery(InventoryDbEntities context, string like)
{
var query = (from row in context.ProviderLists
where
row.Name.ToLower().Contains(like) ||
row.Phone.ToLower().Contains(like) ||
row.Address.ToLower().Contains(like)
orderby row.ProviderId
select row);
return(query);
}
protected override IQueryable <TransPermissionList> FilteredQuery(InventoryDbEntities context, string like)
{
var query = (from row in context.TransPermissionList
where
row.Cabinet_Type.ToLower().Contains(like) ||
row.Note.ToLower().Contains(like) ||
row.PermissionType.ToLower().Contains(like) ||
row.Username.ToLower().Contains(like)
orderby row.PermissionId
select row);
return(query);
}
public PermissionController(IViewer view) : base(view)
{
ParseFunc = new Func <List <string[]>, List <TransactionPermission> >((c) =>
(new EntityParser(UserId).ParseToPermission(c)));
InsertAction = new Func <List <TransactionPermission>, int>((e) =>
{
using (var context = new InventoryDbEntities())
{
context.TransactionPermissions.AddRange(e);
return(context.SaveChanges());
}
});
}
public List <Cabinet> ToEntities()
{
var cabinets = new List <Cabinet>();
for (int i = 0; i < CSV.Count; i++)
{
if (CSV[i].Count() != ColumnCount)
{
throw new EntityParsingException("Invalid column count", i);
}
string name = CSV[i][0];
string typeName = CSV[i][1];
string address = CSV[i][2];
string phone = CSV[i][3];
//check length
if (name.Length > NameLength)
{
throw new EntityParsingException("Invalid length", nameof(name), name, i);
}
if (typeName.Length > typeNameLength)
{
throw new EntityParsingException("Invalid length", nameof(typeName), typeName, i);
}
if (address.Length > AddressLength)
{
throw new EntityParsingException("Invalid length", nameof(address), address, i);
}
if (phone.Length > PhoneLength)
{
throw new EntityParsingException("Invalid length", nameof(phone), phone, i);
}
//get id
int?typeId;
using (var context = new InventoryDbEntities())
{
if (!IdTranslater.GetCabinetTypeId(typeName, out typeId, context))
{
throw new EntityParsingException("Name doesnt exist", "CabinetType", typeName, i);
}
}
var cabinet = new Cabinet()
{
CabinetName = name,
CabinetTypeId = typeId ?? -1,
Address = address,
Phone = phone
};
cabinets.Add(cabinet);
}
return(cabinets);
}
protected override IQueryable <OrderList> FilteredQuery(InventoryDbEntities context, string like)
{
var query = (from row in context.OrderLists
where row.CabinetName.ToLower().Contains(like) ||
row.InputDate.ToString().ToLower().Contains(like) ||
row.ItemCode.ToLower().Contains(like) ||
row.Note.ToLower().Contains(like) ||
row.Provider.ToLower().Contains(like) ||
row.Username.ToLower().Contains(like)
orderby row.OrderId
select row);
return(query);
}
protected override IQueryable <TransactionList> FilteredQuery(InventoryDbEntities context, string like)
{
var query = (from row in context.TransactionLists
where
row.From.ToLower().Contains(like) ||
row.To.ToLower().Contains(like) ||
row.TransactionDate.ToString().ToLower().Contains(like) ||
row.Username.ToLower().Contains(like) ||
row.ItemCode.ToLower().Contains(like) ||
row.Note.ToLower().Contains(like)
orderby row.TransactionsId
select row);
return(query);
}
public List <TransactionPermission> ToEntities()
{
var entities = new List <TransactionPermission>();
for (int i = 0; i < CSV.Count; i++)
{
string pType = CSV[i][0];
string userName = CSV[i][1];
string cabinetType = CSV[i][2];
string note = CSV[i][3];
if (note.Length > NoteLength)
{
throw new EntityParsingException("Invalid length", nameof(note), note, i);
}
int cId, userId;
int?id;
using (var context = new InventoryDbEntities())
{
//to cabinet id
if (!IdTranslater.GetCabinetTypeId(cabinetType, out id, context))
{
throw new EntityParsingException("Name doesnt exist", "CabinetType", cabinetType, i);
}
cId = id ?? -1;
//username
if (!IdTranslater.GetUserId(userName, out id, context))
{
throw new EntityParsingException("Name doesnt exist", "Username", userName, i);
}
userId = id ?? -1;
}
var per = new TransactionPermission()
{
PermissionTypeName = pType,
CabinetTypeId = cId,
UserId = userId,
Note = note
};
entities.Add(per);
}
return(entities);
}
private void SetServer()
{
var server = string.Empty;
try
{
using (var context = new InventoryDbEntities())
{
server = context.Database.Connection.DataSource.Split('\\').First();
}
}
catch (Exception)
{
server = "Unknown";
}
labelDataSourse.Text = $"Server: {server}";
}
public List <Item> ToEntities()
{
var entities = new List <Item>();
for (int i = 0; i < CSV.Count; i++)
{
if (CSV[i].Count() != ColumnCount)
{
throw new EntityParsingException("Invalid column count", i);
}
string code = CSV[i][0];
string name = CSV[i][1];
string cat = CSV[i][2];
if (code.Length > CodeLength)
{
throw new EntityParsingException("Invalid length", "ItemCode", code, i);
}
if (name.Length > NameLength)
{
throw new EntityParsingException("Invalid length", "ItemName", name, i);
}
int catId;
int?id;
using (var context = new InventoryDbEntities())
{
if (!IdTranslater.GetCatId(cat, out id, context))
{
throw new EntityParsingException("Name doesnt exist", "Item Category", cat, i);
}
}
catId = id ?? -1;
var item = new Item()
{
ItemCode = code,
ItemName = name,
CatId = catId
};
entities.Add(item);
}
return(entities);
}
