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