public override Task <UpdateCategoryStateResponse> UpdateCategoryState(UpdateCategoryStateRequest request, ServerCallContext context) { UpdateCategoryStateResponse response; using (var priceContext = new pricecompContext()) { var updatedCatogories = request.UpdatedCategories; List <Int32> updatedRecord = new List <Int32>(); try { foreach (var category in updatedCatogories) { var record = priceContext.Stateassignment.FirstOrDefault( item => item.Id == category.Id); if (record != null) { record.State = category.Category; priceContext.Update(record); var res = priceContext.SaveChanges(); updatedRecord.Add(res); } else { updatedRecord.Add(0); } } } catch (Exception e) { response = (new UpdateCategoryStateResponse() { Status = "update state fail" }); } if (updatedRecord.Contains(0)) { response = (new UpdateCategoryStateResponse() { Status = "update state fail" }); } else { response = (new UpdateCategoryStateResponse() { Status = "update state success" }); } } return(Task.FromResult(response)); }
public override Task <AddCategoryMarginResponse> AddCategoryMargin(AddCategoryMarginRequest request, ServerCallContext conetxt) { AddCategoryMarginResponse response; using (var priceContext = new pricecompContext()) { var categorymargin = priceContext.Categorymargin; var margin = Double.Parse(request.Margin.ToString("0.##")); var addedCategoryMargin = new Categorymargin() { Category = request.Category, Id = request.Id, Targetmargin = margin, Pricelow = request.PriceRangeStart, Pricehigh = request.PriceRangeEnd }; var status = false; try { categorymargin.Add(addedCategoryMargin); var res = priceContext.SaveChanges(); if (res != 0) { status = true; } else { status = false; } } catch (Exception e) { status = false; } if (status) { response = new AddCategoryMarginResponse() { Status = "add successful" }; } else { response = new AddCategoryMarginResponse() { Status = "fail to add new rule" }; } } return(Task.FromResult(response)); }
public override Task <UpdateCompetitorTierResponse> UpdateCompetitorTier(UpdateCompetitorTierRequest request, ServerCallContext context) { UpdateCompetitorTierResponse response; using (var priceContext = new pricecompContext()) { var updatedCompetitors = request.UpdatedCompetitor; List <Int32> updatedRecord = new List <Int32>(); try { foreach (var competitor in updatedCompetitors) { var record = priceContext.Competitor1.FirstOrDefault( item => item.Competitorid == competitor.CompetitorId); if (record != null) { record.Tier = competitor.UpdatedTier; priceContext.Update(record); var res = priceContext.SaveChanges(); updatedRecord.Add(res); } else { updatedRecord.Add(0); } } } catch (Exception e) { response = (new UpdateCompetitorTierResponse() { Status = "update tier fail" }); } if (updatedRecord.Contains(0)) { response = (new UpdateCompetitorTierResponse() { Status = "update tier fail" }); } else { response = (new UpdateCompetitorTierResponse() { Status = "update tier success" }); } } return(Task.FromResult(response)); }
public override Task <DeleteCompetitorResponse> DeleteCompetitor(DeleteCompetitorRequest request, ServerCallContext context) { DeleteCompetitorResponse response; using (var priceContext = new pricecompContext()) { var competitorid = request.CompetitorId; var record = priceContext.Competitor1.SingleOrDefault(item => item.Competitorid == competitorid); var status = false; if (record != null) { try { priceContext.Competitor1.Remove(record); priceContext.SaveChanges(); status = true; } catch (Exception e) { status = false; } } else { status = false; } if (status) { response = new DeleteCompetitorResponse() { Status = "succeed to delete" }; } else { response = new DeleteCompetitorResponse() { Status = "fail to delete" }; } } return(Task.FromResult(response)); }
public override Task <UpdateProductDescriptionResponse> UpdateProductDescription(UpdateProductDescriptionRequest request, ServerCallContext context) { UpdateProductDescriptionResponse response; using (var priceContext = new pricecompContext()) { var productCode = request.ProductCode; var updatedKeyWord = request.UpdatedDescription; var record = priceContext.Product.FirstOrDefault(item => item.Productcode == productCode); if (record != null) { record.Keywords = updatedKeyWord; priceContext.Product.Update(record); var dbres = priceContext.SaveChanges(); if (dbres > 0) { response = new UpdateProductDescriptionResponse() { Status = "success" }; } else { response = new UpdateProductDescriptionResponse() { Status = "error" }; } } else { response = new UpdateProductDescriptionResponse() { Status = "error" } ; } } return(Task.FromResult(response)); }
public override Task <DeleteCategoryMarginResponse> DeleteCategoryMargin(DeleteCategoryMarginRequest request, ServerCallContext context) { DeleteCategoryMarginResponse response; using (var priceContext = new pricecompContext()) { var index = request.Id; var record = priceContext.Categorymargin.FirstOrDefault(item => item.Id == index); var status = false; if (record != null) { try { priceContext.Categorymargin.Remove(record); priceContext.SaveChanges(); status = true; }catch (Exception e) { status = false; } } if (status) { response = new DeleteCategoryMarginResponse() { Status = "success" }; } else { response = new DeleteCategoryMarginResponse() { Status = "fail" }; } } return(Task.FromResult(response)); }
public override Task <AddCompetitorResponse> AddCompetitor(AddCompetitorRequest request, ServerCallContext context) { AddCompetitorResponse response; using (var priceContext = new pricecompContext()) { var competitorName = request.Name; var competitorTier = request.Tier; var competitors = priceContext.Competitor1; var index = competitors.OrderByDescending(item => item.Competitorid).FirstOrDefault().Competitorid + 1; var status = false; var competitor = new Competitor1() { Competitorid = index, Keyword = null, Name = competitorName, State = null, Tier = competitorTier, Website = null }; try { competitors.Add(competitor); var res = priceContext.SaveChanges(); if (res != 0) { status = true; } else { status = false; } } catch (Exception e) { status = false; } if (status) { response = new AddCompetitorResponse() { Status = "succedd to add new competitor" }; } else { response = new AddCompetitorResponse() { Status = "fail to add new competitor" }; } } return(Task.FromResult(response)); }