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