public string UpdateSupplier(Supplier sup) { try { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var updateSup = context.Suppliers.Where(x => x.Id == sup.Id).FirstOrDefault(); if (updateSup == null) { return("No record found."); } updateSup.SupplierName = sup.SupplierName; updateSup.IsActive = sup.IsActive; updateSup.UpdateUserName = sup.UpdateUserName; updateSup.UpdateDttm = sup.UpdateDttm; updateSup.TelephoneNumber = sup.TelephoneNumber; updateSup.Notes = sup.Notes; updateSup.Email = sup.Email; updateSup.SupplierAddress = sup.SupplierAddress; context.Suppliers.Attach(updateSup); context.Entry(updateSup).State = EntityState.Modified; int result = context.SaveChanges(); return(result > 0 ? "Supplier updated." : "Error saving Supplier."); } } catch (Exception ex) { return("Internal error encountered."); } }
/// <summary> /// /// </summary> /// <param name="brand"></param> /// <returns></returns> public Brand InsertNewBrand(Brand brand) { try { Brand insertBrand = new Brand(); insertBrand.BrandName = brand.BrandName; insertBrand.Notes = brand.Notes; insertBrand.IsActive = brand.IsActive; insertBrand.CreateUserName = brand.CreateUserName; insertBrand.CreateDttm = brand.CreateDttm; insertBrand.UpdateUserName = brand.UpdateUserName; insertBrand.UpdateDttm = brand.UpdateDttm; using (OrmocIMSEntities context = new OrmocIMSEntities()) { context.Brands.Add(insertBrand); int result = context.SaveChanges(); return(result > 0 ? insertBrand : new Brand()); } } catch (Exception ex) { return(new Brand()); } }
public ItemRequestPullDelinquentsResponseModel GetItemRequestFormDelinquents(ItemRequestDelinquentQueryModel query) { ItemRequestPullDelinquentsResponseModel result = new ItemRequestPullDelinquentsResponseModel(); using (OrmocIMSEntities context = new OrmocIMSEntities()) { result.RecordCount = context.ItemRequestFormSearch_SP(query.ModuleNm, null, null, query.FirstFollowupDate.ToString(), query.SecondFollowupDate.ToString(), query.ThirdFollowupDate.ToString()).Count(); result.SearchResult = context.ItemRequestFormSearch_SP(query.ModuleNm, null, null, query.FirstFollowupDate.ToString(), query.SecondFollowupDate.ToString(), query.ThirdFollowupDate.ToString()).Skip(query.NextBatch).Take(10) .Select(x => new ItemRequestDelinquentQueryResultModel { Id = x.Id, Title = x.Title, Status = x.CodeValue, TicketStatus = x.TicketStatus, DateCreated = x.CreateDttm }) .ToList(); return(result); } }
/// <summary> /// /// </summary> /// <param name="brand"></param> /// <returns></returns> public string UpdateBrandDetails(Brand brand) { try { using (OrmocIMSEntities context = new OrmocIMSEntities()) { Brand updateBrand = context.Brands.Where(x => x.Id == brand.Id).FirstOrDefault(); if (updateBrand == null) { return("No record found."); } updateBrand.BrandName = brand.BrandName; updateBrand.Notes = brand.Notes; updateBrand.IsActive = brand.IsActive; updateBrand.UpdateUserName = brand.UpdateUserName; updateBrand.UpdateDttm = brand.UpdateDttm; context.Brands.Attach(updateBrand); context.Entry(updateBrand).State = System.Data.Entity.EntityState.Modified; int result = context.SaveChanges(); return(result > 0 ? "Brand updated." : "Error saving Brand."); } } catch { return("Internal error encountered."); } }
public ItemRequestSearchModel GetItemRequestFormSearchResults(ItemRequestFormSearchQueryModel query) { ItemRequestSearchModel result = new ItemRequestSearchModel(); result.SearchResult = new List <ItemRequestFormSearchResultModel>(); using (OrmocIMSEntities context = new OrmocIMSEntities()) { result.RecordCount = context.ItemRequestFormSearch_SP(query.ModuleNm, query.Id.HasValue ? query.Id.Value.ToString() : null, String.IsNullOrEmpty(query.Title) ? null : query.Title, query.StatusCd.HasValue ? query.StatusCd.Value.ToString() : null, string.IsNullOrEmpty(query.DateCreated) ? null : query.DateCreated, string.IsNullOrEmpty(query.DateTo) ? null : query.DateTo) .Count(); result.SearchResult = context.ItemRequestFormSearch_SP(query.ModuleNm, query.Id.HasValue ? query.Id.Value.ToString() : null, String.IsNullOrEmpty(query.Title) ? null : query.Title, query.StatusCd.HasValue ? query.StatusCd.Value.ToString() : null, string.IsNullOrEmpty(query.DateCreated) ? null : query.DateCreated, string.IsNullOrEmpty(query.DateTo) ? null : query.DateTo) .Skip(query.NextBatch).Take(10) .Select(x => new ItemRequestFormSearchResultModel { Id = x.Id, Title = x.Title, Status = x.CodeValue, DateCreated = x.CreateDttm }).ToList(); return(result); } }
/// <summary> /// /// </summary> /// <param name="cat"></param> /// <returns></returns> public Category InsertNewCategory(Category cat) { try { Category insertCat = new Category(); insertCat.CategoryName = cat.CategoryName; insertCat.IsActive = cat.IsActive; insertCat.CreateUserName = cat.CreateUserName; insertCat.CreateDttm = cat.CreateDttm; insertCat.UpdateUserName = cat.UpdateUserName; insertCat.UpdateDttm = cat.UpdateDttm; using (OrmocIMSEntities context = new OrmocIMSEntities()) { context.Categories.Add(insertCat); int result = context.SaveChanges(); return(result > 0 ? insertCat : new Category()); } } catch (Exception ex) { return(new Category()); } }
public Supplier CreateNewSupplier(Supplier sup) { try { Supplier createSupplier = new Supplier(); createSupplier.SupplierName = sup.SupplierName; createSupplier.SupplierAddress = sup.SupplierAddress; createSupplier.TelephoneNumber = sup.TelephoneNumber; createSupplier.Email = sup.Email; createSupplier.Notes = sup.Notes; createSupplier.IsActive = sup.IsActive; createSupplier.CreateUserName = sup.CreateUserName; createSupplier.CreateDttm = sup.CreateDttm; createSupplier.UpdateDttm = sup.UpdateDttm; createSupplier.UpdateUserName = sup.UpdateUserName; using (OrmocIMSEntities context = new OrmocIMSEntities()) { context.Suppliers.Add(createSupplier); int result = context.SaveChanges(); return(result > 0 ? createSupplier : new Supplier()); } } catch (Exception ex) { return(new Supplier()); } }
public bool RejectItemRequest(int Id) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { int result = 0; var query = context.ItemRequestForms.Where(x => x.Id == Id && x.IsActive == true).FirstOrDefault(); var ticketDetails = context.CodeHeaders.Include(x => x.CodeDetails) .Where(x => x.CodeHeaderName.Equals("Ticket Status")) .FirstOrDefault(); if (query == null) { return(false); } try { query.StatusCd = ticketDetails.CodeDetails.Where(x => x.CodeValue.Equals("Rejected")).Select(x => x.Id).FirstOrDefault(); context.Entry(query).State = EntityState.Modified; result = context.SaveChanges(); } catch (Exception ex) { return(false); } return(result > 0 ? true : false); } }
public ItemSearchResponseModel SimpleSearchItems(string itemName, int skip) { ItemSearchResponseModel result = new ItemSearchResponseModel(); using (OrmocIMSEntities context = new OrmocIMSEntities()) { result.RecordCount = context.Items.Include(x => x.Brand).Include(x => x.Location) .Where(x => x.ItemName.Contains(itemName)).Count(); result.SearchResult = context.Items.Include(x => x.Brand).Include(x => x.Location) .Where(x => x.ItemName.Contains(itemName)) .OrderBy(x => x.Id) .Skip(skip).Take(10) .Select(x => new ItemSearchResult { Id = x.Id, ItemName = x.ItemName, Brand = x.Brand.BrandName, Status = x.StatusCd, CreateDttm = x.CreateDttm, LocationName = x.Location.LocationName, StockLeft = x.Quantity.HasValue ? x.Quantity.Value : 0, Notes = x.Notes }).ToList(); return(result); } }
/// <summary> /// /// </summary> /// <param name="cat"></param> /// <returns></returns> public string UpdateCategoryDetails(Category cat) { try { using (OrmocIMSEntities context = new OrmocIMSEntities()) { Category updateCat = context.Categories.Where(x => x.Id == cat.Id && x.IsActive == true).FirstOrDefault(); if (updateCat == null) { return("No record found."); } updateCat.CategoryName = cat.CategoryName; updateCat.IsActive = cat.IsActive; updateCat.UpdateUserName = cat.UpdateUserName; updateCat.UpdateDttm = cat.UpdateDttm; context.Categories.Attach(updateCat); context.Entry(updateCat).State = System.Data.Entity.EntityState.Modified; int result = context.SaveChanges(); return(result > 0 ? "Category updated." : "Error saving Category."); } } catch (Exception ex) { return("Internal error encountered."); } }
public int AddNewTag(Tag tag) { Tag newTag = new Tag(); using (OrmocIMSEntities context = new OrmocIMSEntities()) { int result = 0; var query = context.Tags.Where(x => x.TagValue.Equals(tag.TagValue)).FirstOrDefault(); if (query == null) { newTag.TagValue = tag.TagValue; newTag.CreateUserName = "******"; newTag.CreateDttm = DateTime.UtcNow; newTag.UpdateUserName = "******"; newTag.UpdateDttm = DateTime.UtcNow; context.Tags.Add(newTag); context.Entry(newTag).State = EntityState.Added; result = context.SaveChanges(); return(result > 0 ? newTag.Id : 0); } else { return(query.Id); } } }
public string SaveToken(User saveToken) { try { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var query = context.Users.Where(x => x.Id == saveToken.Id).FirstOrDefault(); query.Token = saveToken.Token; query.UpdateDttm = DateTime.UtcNow; query.UpdateUserName = "******"; context.Entry(query).State = System.Data.Entity.EntityState.Modified; var result = context.SaveChanges(); if (result > 0) { return(saveToken.Token); } else { return("Error encountered during token save."); } } } catch { return("Internal error encountered."); } }
public bool UpdateItemById(Item item) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var query = context.Items.Where(x => x.Id == item.Id).FirstOrDefault(); if (query != null) { query.ItemName = item.ItemName; query.LocationID = item.LocationID; query.CategoryID = item.CategoryID; query.SubCategoryID = item.SubCategoryID; query.BrandID = item.BrandID; query.Quantity = item.Quantity; query.MeasuredBy = item.MeasuredBy; query.ThresholdQty = item.ThresholdQty; query.Sku = item.Sku; query.Notes = item.Notes; query.UpdateUserName = item.UpdateUserName; query.UpdateDttm = item.UpdateDttm; //for(int i = 0; i < query.ItemDetailMappings.Count; i++) //{ // query.ItemDetailMappings = item.ItemDetailMappings; //} context.Entry(query).State = EntityState.Modified; int result = context.SaveChanges(); return(result > 0 ? true : false); } } return(false); }
/// <summary> /// /// </summary> /// <param name="sub"></param> /// <returns></returns> public string UpdateSubCategoryDetails(SubCategory sub) { try { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var updateSub = context.SubCategories.Where(x => x.Id == sub.Id && x.IsActive == true).FirstOrDefault(); if (updateSub == null) { return("No record found."); } updateSub.CategoryID = sub.CategoryID; updateSub.SubCategoryName = sub.SubCategoryName; updateSub.IsActive = sub.IsActive; updateSub.UpdateUserName = sub.UpdateUserName; updateSub.UpdateDttm = sub.UpdateDttm; context.SubCategories.Attach(updateSub); context.Entry(updateSub).State = EntityState.Modified; int result = context.SaveChanges(); return(result > 0 ? "SubCategory updated." : "Error saving SubCategory."); } } catch (Exception ex) { return("Internal error encountered."); } }
/// <summary> /// /// </summary> /// <param name="sub"></param> /// <returns></returns> public SubCategory InsertNewSubCategory(SubCategory sub) { try { SubCategory insertSub = new SubCategory(); insertSub.CategoryID = sub.CategoryID; insertSub.SubCategoryName = sub.SubCategoryName; insertSub.IsActive = sub.IsActive; insertSub.CreateUserName = sub.CreateUserName; insertSub.CreateDttm = sub.CreateDttm; insertSub.UpdateUserName = sub.UpdateUserName; insertSub.UpdateDttm = sub.UpdateDttm; using (OrmocIMSEntities context = new OrmocIMSEntities()) { context.SubCategories.Add(insertSub); int result = context.SaveChanges(); return(result > 0 ? insertSub : new SubCategory()); } } catch (Exception ex) { return(new SubCategory()); } }
public List <Tag> TagsAutoComplete(string word) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var result = context.Tags.Where(x => x.TagValue.Contains(word)).Take(10).ToList(); return(result); } }
public List <Location> GetAllLocations() { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var result = context.Locations.Where(x => x.IsActive == true).ToList(); return(result); } }
public List <string> ItemAutoComplete(string word) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var result = context.Items.Where(x => x.ItemName.Contains(word)).Select(x => x.ItemName).Distinct().Take(10).ToList(); return(result); } }
/// <summary> /// /// </summary> /// <param name="categoryId"></param> /// <returns></returns> public List <SubCategory> GetSubCategoriesByCategory(int categoryId) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var subs = context.SubCategories.Where(x => x.CategoryID == categoryId && x.IsActive == true).ToList(); return(subs); } }
public Supplier ViewSupplierById(int SupplierId) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var sups = context.Suppliers.Where(x => x.Id == SupplierId).FirstOrDefault(); return(sups); } }
public List <Supplier> GetSuppliers() { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var suppliers = context.Suppliers.ToList(); return(suppliers); } }
/// <summary> /// /// </summary> /// <param name="brandName"></param> /// <returns></returns> public List <Brand> SearchBrands(string brandName) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var search = context.Brands.Where(x => x.BrandName.Contains(brandName)).ToList(); return(search); } }
/// <summary> /// /// </summary> /// <returns></returns> public List <Brand> GetBrands() { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var brands = context.Brands.ToList(); return(brands); } }
public ItemRequestFormMapping ValidateIfMappingExists(int itemId, int itemRequestId) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var result = context.ItemRequestFormMappings.Where(x => x.ItemID == itemId && x.IRFID == itemRequestId).FirstOrDefault(); return(result); } }
public List <Supplier> SuppliersSearch(SupplierSearchModel sup) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var search = context.Suppliers.Where(x => (x.SupplierName.Contains(sup.SupplierName) || sup.SupplierName == null) && (x.SupplierAddress.Contains(sup.SupplierAddress) || sup.SupplierAddress == null)).ToList(); return(search); } }
/// <summary> /// /// </summary> /// <param name="brandName"></param> /// <returns></returns> public int GetBrandsCount(string brandName) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var result = context.Brands.Where(x => x.BrandName.Contains(brandName)).Count(); return(result); } }
public Brand GetBrandByName(string brandName) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var result = context.Brands.Where(x => x.BrandName.Contains(brandName)).FirstOrDefault(); return(result); } }
public CodeHeader GetAllFollowupDetails() { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var result = context.CodeHeaders.Include("CodeDetails").Where(x => x.CodeHeaderName.Equals("Item Request Followup Days")).FirstOrDefault(); return(result); } }
public CodeHeader GetAllTicketStatus() { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var result = context.CodeHeaders.Include("CodeDetails").Where(x => x.CodeHeaderName.Equals("Ticket Status")).FirstOrDefault(); return(result); } }
/// <summary> /// Getting a hashKey /// </summary> /// <returns></returns> public string GetHashKey() { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var hash = context.HashKeys.Select(x => x.KeyValue).FirstOrDefault(); return(hash); } }