public List <SouvenirStockViewModel> GetAllSouvenirStock(SearchTransactionSouvenirViewModel parameters) { using (MarcommEntities db = new MarcommEntities()) { bool NullCode = string.IsNullOrWhiteSpace(parameters.code); bool NullRequestBy = string.IsNullOrWhiteSpace(parameters.requestBy); bool NullRequestDate = string.IsNullOrWhiteSpace(parameters.requestDate); bool NullDueDate = string.IsNullOrWhiteSpace(parameters.dueDate); bool NullStatus = string.IsNullOrWhiteSpace(parameters.status); bool NullCreatedDate = string.IsNullOrWhiteSpace(parameters.createdDate); bool NullCreatedBy = string.IsNullOrWhiteSpace(parameters.createdBy); DateTime?requestDate = NullRequestDate ? (DateTime?)null : DateTime.Parse( DateTime.ParseExact(parameters.requestDate, "dd'-'MM'-'yyyy", CultureInfo.InvariantCulture).ToString("MM'/'dd'/'yyyy")); DateTime?dueDate = NullDueDate ? (DateTime?)null : DateTime.Parse( DateTime.ParseExact(parameters.dueDate, "dd'-'MM'-'yyyy", CultureInfo.InvariantCulture).ToString("MM'/'dd'/'yyyy")); DateTime?createdDate = NullCreatedDate ? (DateTime?)null : DateTime.Parse( DateTime.ParseExact(parameters.createdDate, "dd'-'MM'-'yyyy", CultureInfo.InvariantCulture).ToString("MM'/'dd'/'yyyy")); var souvenir_stock = (from p in db.t_souvenir where p.is_delete == false select p).ToList(); souvenir_stock = !NullCode ? (from p in souvenir_stock where p.code.Contains(parameters.code) select p).ToList() : souvenir_stock; souvenir_stock = !NullRequestDate ? (from p in souvenir_stock where DateTime.Compare((DateTime)p.request_date, (DateTime)requestDate) == 0 select p).ToList() : souvenir_stock; souvenir_stock = !NullDueDate ? (from p in souvenir_stock where DateTime.Compare((DateTime)p.request_due_date, (DateTime)dueDate) == 0 select p).ToList() : souvenir_stock; souvenir_stock = !NullCreatedDate ? (from p in souvenir_stock where DateTime.Compare((DateTime)p.created_date, (DateTime)createdDate) == 0 select p).ToList() : souvenir_stock; souvenir_stock = !NullRequestBy ? (from p in souvenir_stock where p.request_by.Equals( (from q in db.m_employee where !q.id_delete && (q.first_name + " " + q.last_name).Contains(parameters.requestBy) select q.id).SingleOrDefault()) select p).ToList() : souvenir_stock; souvenir_stock = !NullCreatedBy ? (from p in souvenir_stock where p.created_by.Equals(Convert.ToInt64( (from q in db.m_employee where !q.id_delete && (q.first_name + " " + q.last_name).Contains(parameters.createdBy) select q.id).SingleOrDefault())) select p).ToList() : souvenir_stock; souvenir_stock = !NullStatus ? (from p in souvenir_stock where GetStatusId(parameters.status.ToLower()).Contains((int)p.status) select p).ToList() : souvenir_stock; List <SouvenirStockViewModel> SouvenirStock = new List <SouvenirStockViewModel>(); foreach (var souvenir in souvenir_stock) { SouvenirStockViewModel Souvenir = new SouvenirStockViewModel(); Souvenir.id = souvenir.id; Souvenir.code = souvenir.code; Souvenir.requestBy = souvenir.request_by; Souvenir.requestDate = souvenir.request_date; Souvenir.requestDueDate = souvenir.request_due_date; Souvenir.status = souvenir.status; Souvenir.createdDate = souvenir.created_date; Souvenir.createdBy = souvenir.created_by; Souvenir.requestByToFullName = GetFullNameFromIdEmployee(souvenir.request_by); Souvenir.createdByToFullName = GetFullNameFromIdEmployee(Convert.ToInt32(souvenir.created_by)); SouvenirStock.Add(Souvenir); } return(SouvenirStock); } }
public List <SouvenirStockViewModel> Get([FromUri] SearchTransactionSouvenirViewModel parameters) { return(service.GetAllSouvenirStock(parameters)); }