public ActionResult EventLists()
{
using (RfContext db = new RfContext())
{
var evt = db.RfEvents;
Console.WriteLine("evt count: " + db.RfEvents.Count());
return(Content(JsonConvert.SerializeObject(evt)));
}
}
public ActionResult SchemeActivate(int schemeId, string[] users)
{
try
{
using (RfContext db = new RfContext())
{
var scheme = db.RfSchemes.FirstOrDefault(r => r.Id == schemeId);
var mktInsert = new List <string>()
{
};
var idcInsert = new List <string>()
{
};
foreach (var u in users)
{
var mkt2 = from m in scheme.UserMarkets.Split(',')
select "('" + u + "', '" + m + "')";
mktInsert.Add(string.Join(",", mkt2.ToArray()));
var idc = from m in scheme.UserIndicators.Split(',')
select "('" + u + "', '" + m + "')";
idcInsert.Add(string.Join(",", idc.ToArray()));
}
var sql = new StringBuilder("Insert Into UserMarkets values ");
sql.Append(string.Join(",", mktInsert));
int ct = db.Database.ExecuteSqlCommand(sql.ToString());
var sql2 = new StringBuilder("Insert Into UserIndicators values ");
sql2.Append(string.Join(",", mktInsert));
int ct2 = db.Database.ExecuteSqlCommand(sql2.ToString());
}
}
catch (Exception ex)
{
Console.WriteLine("Error activating: " + ex.ToString());
}
var obj = new { retValue = true };
return(Content(JsonConvert.SerializeObject(obj)));
}
public ActionResult SchemeLists()
{
try
{
using (RfContext db = new RfContext())
{
var schms = db.RfSchemes;
var obj = JsonConvert.SerializeObject(schms);
var ctnt = this.Content(obj);
return(ctnt);
}
}
catch (Exception ex)
{
Console.WriteLine("scheme lists error:" + ex);
}
return(null);
}
public ActionResult SchemeCreate(RfScheme schm)
{
int retId = 0;
try
{
using (RfContext db = new RfContext())
{
var addedScheme = db.RfSchemes.Add(schm);
db.SaveChanges();
retId = addedScheme.Id;
Console.WriteLine("scheme count: " + db.RfSchemes.Count());
}
}
catch (Exception ex)
{
Console.WriteLine("Error: " + ex.ToString());
}
var obj = new { retValue = retId };
return(Content(JsonConvert.SerializeObject(obj)));
}
public ActionResult EventCreate(RfEvent rf)
{
int retId = 0;
try
{
using (RfContext db = new RfContext())
{
var evt = db.RfEvents.Add(rf);
db.SaveChanges();
retId = evt.Id;
Console.WriteLine("evt count: " + db.RfEvents.Count());
}
}
catch (Exception ex)
{
Console.WriteLine("Error: " + ex.ToString());
}
var obj = new { retValue = retId };
return(Content(JsonConvert.SerializeObject(obj)));
}
public ActionResult SchemeDelete(int schemeId)
{
int count = 0;
try
{
using (RfContext db = new RfContext())
{
var evt = db.RfSchemes.FirstOrDefault(r => r.Id == schemeId);
db.RfSchemes.Remove(evt);
db.SaveChanges();
count = db.RfSchemes.Count();
}
}
catch (Exception ex)
{
Console.WriteLine("Error deleting: " + ex.ToString());
}
var obj = new { schemeCount = count.ToString() };
return(Content(JsonConvert.SerializeObject(obj)));
}
public UserService(RfContext context)
{
_context = context ?? throw new ArgumentNullException(nameof(context));
}
public RfMenuController(ILogger <RfMenuController> logger, RfContext context)
{
_logger = logger;
service = new RFMenuService(context);
}
public UserController(ILogger <UserController> logger, RfContext context)
{
_logger = logger;
service = new UserService(context);
}
