public static bool deleteSource(Models.Source source)
{
bool result = false;
try
{
using (var _db = new Models.BleacherDb())
{
_db.MCSImports.RemoveRange(_db.MCSImports.Where(x => x.SourceId == source.Id).Select(x => x));
int rowsAff = _db.SaveChanges();
if (rowsAff > 0)
{
_db.Sources.Remove(_db.Sources.Where(x => x.Id == source.Id).Select(x => x).Take(1).FirstOrDefault());
_db.SaveChanges();
result = true;
}
}
} catch (Exception e)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(e);
}
return(result);
}
public static bool editSource(Models.SourceCrud source)
{
bool result = false;
try
{
using (var _db = new Models.BleacherDb())
{
var sourceObj = (from x in _db.Sources where x.Id == source.Id select x).FirstOrDefault();
if (sourceObj != null)
{
sourceObj.Name = source.Name;
sourceObj.Active = source.Active;
int aff = _db.SaveChanges();
if (aff > 0)
{
result = true;
}
}
}
} catch (Exception e)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(e);
}
return(result);
}
public static async Task <Models.IndexViewModel> getImportRecords(DateTime fromdate, DateTime todate)
{
List <Models.FileImportview> records = null;
Models.IndexViewModel viewObject = new Models.IndexViewModel();
viewObject.datefrom = DateTime.Now.AddDays(-14);
viewObject.dateto = DateTime.Now.AddDays(1);
using (var _db = new Models.BleacherDb())
{
_db.Configuration.ProxyCreationEnabled = false;
var query = from x in _db.MCSImports
join s in _db.Sources on x.SourceId equals s.Id
select new Models.FileImportview {
id = x.id, LineBlob = x.LineBlob, DocNumber = (int)x.DocNumber, Location = x.Location, Timestamp = (DateTime)x.Timestamp, Source = s.Name
};
records = await query.ToListAsync();
if (records != null && records.Count > 0)
{
viewObject.FileImportview = records;
}
}
return(viewObject);
}
private static void addEvent(int sourceId, string location, int rows)
{
using (var _db = new Models.BleacherDb())
{
Models.eventLog record = new Models.eventLog();
record.SourceId = sourceId;
record.Action = "Add To Import";
record.Description = rows.ToString() + " rows";
record.Timestamp = DateTime.Now;
_db.eventLogs.Add(record);
_db.SaveChanges();
}
}
public static async Task <List <Models.select2> > getSelectSources()
{
List <Models.select2> selects = new List <Models.select2>();
using (var _db = new Models.BleacherDb())
{
selects = await(from x in _db.Sources select new Models.select2 {
id = x.Id, text = x.Name
}).ToListAsync();
}
selects.Add(new Models.select2 {
id = 0, text = "ALL"
});
selects = (from x in selects orderby x.id descending select x).ToList();
return(selects);
}
public static bool deleteSourceAsync(Models.Source source)
{
bool result = false;
if (source.Id != 1 || source.MachineName != "UNKNOWN")
{
using (var _db = new Models.BleacherDb())
{
deleteSourceInCache(source);
result = true;
}
}
Task.Run(() => deleteSource(source));
return(result);
}
public static int AddLineBlobs(List <MCS.Models.MCSImport> records, int sourceId, string location)
{
int rowsAff = 0;
if (records != null && records.Count() > 0)
{
using (var _db = new Models.BleacherDb())
{
_db.MCSImports.AddRange(records);
rowsAff = _db.SaveChanges();
}
try
{
addEvent(sourceId, location, rowsAff);
} catch (Exception e)
{
}
}
return(rowsAff);
}
public HttpResponseMessage Get(int SourceId)
{
int sourceint = Convert.ToInt32(SourceId);
JavaScriptSerializer jser = new JavaScriptSerializer();
Models.sourceDocInfo docInfo = new Models.sourceDocInfo();
HttpResponseMessage response = ControllerContext.Request.CreateResponse(System.Net.HttpStatusCode.Created, "true");
if (sourceint > 0)
{
try
{
int newDocNumber = -1;
using (var _db = new Models.BleacherDb())
{
var importRecord = (from x in _db.MCSImports where x.SourceId == sourceint orderby x.id descending select x).Take(1);
if (importRecord != null && importRecord.Count() > 0)
{
newDocNumber = importRecord.ToArray()[0].DocNumber + 1 ?? 1;
docInfo.LastPath = importRecord.ToArray()[0].Location;
}
else
{
newDocNumber = 1;
docInfo.LastPath = "";
}
docInfo.DocNumber = newDocNumber;
}
}
catch (Exception e)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(e);
}
}
response.Content = new StringContent(jser.Serialize(docInfo));
return(response);
}
public static async Task <Models.SourceViewModel> getAllSources()
{
Models.SourceViewModel viewObject = new Models.SourceViewModel();
var cachedSource = (List <Models.Source>)HttpContext.Current.Cache["FileSources." + MCS.Controllers.HomeController.cachedSessionId];
if (cachedSource != null)
{
viewObject.Sources = cachedSource;
}
else
{
using (var _db = new Models.BleacherDb())
{
_db.Configuration.ProxyCreationEnabled = false;
var query = from x in _db.Sources
select x;
viewObject.Sources = await query.ToListAsync();
}
}
return(viewObject);
}
