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