public async Task <IActionResult> GetReplacementList(SearchPartNo searchPartNo) { searchPartNo.partNo = HttpContext.Request.Query["search"].ToString(); GetReplacementListResponse response = _iAdminReplacementService.GetReplacementList(searchPartNo); return(Ok(response)); }
public async Task <IActionResult> SaveReplacementPrice(UpdateReplacementPrice UpdateReplacementPrice) { UpdateReplacementPrice.PartNo = Convert.ToInt32(HttpContext.Request.Query["PartNo"].ToString()); UpdateReplacementPrice.Qty = Convert.ToInt32(HttpContext.Request.Query["Qty"].ToString()); UpdateReplacementPrice.Price = Convert.ToDecimal(HttpContext.Request.Query["Price"].ToString()); UpdateReplacementPrice.DryerModel = HttpContext.Request.Query["DryerModel"].ToString(); UpdateReplacementPrice.Voltage = HttpContext.Request.Query["Voltage"].ToString(); UpdateReplacementPrice.EdDrawingItemNo = Convert.ToInt32(HttpContext.Request.Query["EdDrawingItemNo"].ToString()); UpdateReplacementPrice.Currency = HttpContext.Request.Query["Currency"].ToString(); GetReplacementListResponse response = _iAdminReplacementService.SaveReplacementPrice(UpdateReplacementPrice); return(Ok(response)); }
public GetReplacementListResponse SaveReplacementPrice(UpdateReplacementPrice UpdateReplacementPrice) { GetReplacementListResponse response = new GetReplacementListResponse(); TblSshReplacementPartPrice ReplacementPartPrice = new TblSshReplacementPartPrice(); ReplacementPartPrice.Price = UpdateReplacementPrice.Price; ReplacementPartPrice.PartNo = UpdateReplacementPrice.PartNo; ReplacementPartPrice.EdDrawingItemNo = UpdateReplacementPrice.EdDrawingItemNo; ReplacementPartPrice.DryerModel = UpdateReplacementPrice.DryerModel; ReplacementPartPrice.Currency = UpdateReplacementPrice.Currency; ReplacementPartPrice.Qty = UpdateReplacementPrice.Qty; ReplacementPartPrice.Voltage = UpdateReplacementPrice.Voltage; //var dataKontrol = context.TblSshReplacementPartPriceRepository.Get().Where(q => q.PartNo == Convert.ToInt32(UpdateReplacementPrice.PartNo)); bool kaydedildiMi; //if (dataKontrol == null) //{ // kaydedildiMi = context.TblSshReplacementPartPriceRepository.Insert(ReplacementPartPrice); // context.Save(); //} //else //{ // kaydedildiMi = context.TblSshReplacementPartPriceRepository.Update(ReplacementPartPrice); // context.Save(); //} kaydedildiMi = context.TblSshReplacementPartPriceRepository.Insert(ReplacementPartPrice); context.Save(); if (kaydedildiMi == false) { response.isSuccess = false; response.ErrorMessage = "Hata oluştu!!"; return(response); } return(response); }
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); }