public void EditAgentClass(string AgentName, string Description, int AgentClassId) { AgentClasses obj = ent.AgentClasses.Where(x => x.AgentClassId == AgentClassId).FirstOrDefault(); obj.AgentClassName = AgentName; obj.ClassDescription = Description; ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, obj); ent.SaveChanges(); }
public int DeleteAgentClasses(int AgentClassId) { try { AgentClasses obj = ent.AgentClasses.Where(x => x.AgentClassId == AgentClassId).FirstOrDefault(); ent.DeleteObject(obj); ent.SaveChanges(); } catch (Exception ex) { return(-1); } return(0); }
public int SaveAgentClass(string AgentClassName, string Description) { AgentClasses obj = new AgentClasses(); obj.AgentClassName = AgentClassName; obj.ClassDescription = Description; //obj.ProductId = 1; try { ent.AddToAgentClasses(obj); ent.SaveChanges(); return(obj.AgentClassId); } catch (Exception ex) { return(0); } }
private string MostProfitableAgentClass(int range = 10) { return(AgentClasses.OrderByDescending(p => GetProfitAverage(p.Key, range)).Select(p => p.Key).First()); }