Example #1
0
        public async Task <IActionResult> GetReplacementList(SearchPartNo searchPartNo)
        {
            searchPartNo.partNo = HttpContext.Request.Query["search"].ToString();
            GetReplacementListResponse response = _iAdminReplacementService.GetReplacementList(searchPartNo);

            return(Ok(response));
        }
        public GetReplacementListResponse GetReplacementList(SearchPartNo searchPartNo)
        {
            var request = new RestRequest("api/AdminReplacement/GetReplacementList", Method.POST, DataFormat.Json)
                          .AddJsonBody(searchPartNo);

            var resp = Globals.ApiClient.Execute <GetReplacementListResponse>(request);

            return(resp.Data);
        }
Example #3
0
        public IActionResult GetReplacementList(SearchPartNo searchPartNo)
        {
            var response = _adminReplacement.GetReplacementList(searchPartNo);

            if (response.isSuccess == false)
            {
                return(null);
            }
            return(Ok(response));
        }
Example #4
0
        public GetReplacementListResponse GetReplacementList(SearchPartNo searchPartNo)
        {
            GetReplacementListResponse response = new GetReplacementListResponse();

            List <AdminReplacementPartView> replacementPartData = new List <AdminReplacementPartView>();

            var replacementList = from replacementPart in context.TblSshReplacementPartRepository.Get()
                                  join replacementPartPrice in context.TblSshReplacementPartPriceRepository.Get()
                                  on replacementPart.PartNo equals replacementPartPrice.PartNo into replacementPartAndReplacementPartPrice
                                  from replacementPartPrice in replacementPartAndReplacementPartPrice.DefaultIfEmpty()
                                  select new
            {
                replacementPart.ReplacementPartId,
                replacementPart.Sad,
                replacementPart.PartNo,
                replacementPartPrice.ReplacementPartPriceId,
                replacementPartPrice.DryerModel,
                replacementPartPrice.EdDrawingItemNo,
                replacementPartPrice.Currency,
                replacementPartPrice.Price,
                replacementPartPrice.Qty,
                replacementPartPrice.Voltage
            } into selection
            select selection;


            //if (searchPartNo.partNo == null)
            //{
            //   var replacementList = from replacementPart in context.TblSshReplacementPartRepository.Get()
            //                      join replacementPartPrice in context.TblSshReplacementPartPriceRepository.Get()
            //                      on replacementPart.PartNo equals replacementPartPrice.PartNo into replacementPartAndReplacementPartPrice
            //                      from replacementPartPrice in replacementPartAndReplacementPartPrice.DefaultIfEmpty()
            //                      select new
            //                      {
            //                          replacementPart.ReplacementPartId,
            //                          replacementPart.Sad,
            //                          replacementPart.PartNo,
            //                          replacementPartPrice.ReplacementPartPriceId,
            //                          replacementPartPrice.DryerModel,
            //                          replacementPartPrice.EdDrawingItemNo,
            //                          replacementPartPrice.Currency,
            //                          replacementPartPrice.Price,
            //                          replacementPartPrice.Qty,
            //                          replacementPartPrice.Voltage
            //                      } into selection
            //                      select selection;

            //}
            //else
            //{
            //  var  replacementList = from replacementPart in context.TblSshReplacementPartRepository.Get()
            //                      join replacementPartPrice in context.TblSshReplacementPartPriceRepository.Get()
            //                      on replacementPart.PartNo equals replacementPartPrice.PartNo into replacementPartAndReplacementPartPrice
            //                      from replacementPartPrice in replacementPartAndReplacementPartPrice.DefaultIfEmpty()
            //                      where replacementPart.PartNo == Convert.ToInt32(searchPartNo.partNo)
            //                      select new
            //                      {
            //                          replacementPart.ReplacementPartId,
            //                          replacementPart.Sad,
            //                          replacementPart.PartNo,
            //                          replacementPartPrice.ReplacementPartPriceId,
            //                          replacementPartPrice.DryerModel,
            //                          replacementPartPrice.EdDrawingItemNo,
            //                          replacementPartPrice.Currency,
            //                          replacementPartPrice.Price,
            //                          replacementPartPrice.Qty,
            //                          replacementPartPrice.Voltage
            //                      } into selection
            //                      select selection;

            //}



            if (replacementList != null)
            {
                foreach (var item in replacementList)
                {
                    AdminReplacementPartView data = new AdminReplacementPartView();
                    data.ReplacementPartId = item.ReplacementPartId;
                    data.Sad    = item.Sad;
                    data.PartNo = item.PartNo;
                    data.ReplacementPartPriceId = item.ReplacementPartPriceId;
                    data.DryerModel             = item.DryerModel;
                    data.EdDrawingItemNo        = item.EdDrawingItemNo;
                    data.Currency = item.Currency;
                    data.Price    = item.Price;
                    data.Qty      = item.Qty;
                    data.Voltage  = item.Voltage;
                    replacementPartData.Add(data);
                }
                response.isSuccess       = true;
                response.ReplacementList = replacementPartData;
            }
            else
            {
                response.isSuccess = false;
            }

            return(response);
        }