//*********************************************************************
///
/// <summary>
///
/// </summary>
/// <param name="tagId"></param>
///
//*********************************************************************
public void DeleteRequestByTagId(int tagId)
{
var outList = new List <Models.Request>();
try
{
using (var db = new Models.AzureFileTransferContext())
{
db.Database.Connection.ConnectionString = _ConnectionString;
var foundReqList = from rb in db.Requests
where rb.TagID == tagId
select rb;
foreach (var req in foundReqList)
{
db.Requests.Remove(req);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("Exception in AftsDb.DeleteRequestByTagId() : "
+ Utilities.UnwindExceptionMessages(ex));
}
}
//*********************************************************************
///
/// <summary>
///
/// </summary>
/// <param name="transferRequest"></param>
/// <param name="db"></param>
///
//*********************************************************************
public void InsertTransferRequest(Models.Request transferRequest,
Models.AzureFileTransferContext db)
{
try
{
db.Database.Connection.ConnectionString = _ConnectionString;
db.Requests.Add(transferRequest);
db.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("Exception in AftsDb.InsertTransferRequest() : "
+ Utilities.UnwindExceptionMessages(ex));
}
}
//*********************************************************************
///
/// <summary>
///
/// </summary>
/// <param name="reqId"></param>
/// <returns></returns>
///
//*********************************************************************
public Models.Request FetchRequest(int reqId)
{
try
{
using (var db = new Models.AzureFileTransferContext())
{
db.Database.Connection.ConnectionString = _ConnectionString;
var foundReq = (from rb in db.Requests
where rb.RequestID == reqId
select rb).First();
return(foundReq);
}
}
catch (Exception ex)
{
throw new Exception("Exception in AftsDb.FetchRequest() : "
+ Utilities.UnwindExceptionMessages(ex));
}
}
//*********************************************************************
///
/// <summary>
///
/// </summary>
/// <param name="transferRequest"></param>
/// <param name="db"></param>
///
//*********************************************************************
public void ResubmitTransferRequest(Models.Request transferRequest,
Models.AzureFileTransferContext db)
{
try
{
db.Database.Connection.ConnectionString = _ConnectionString;
var foundReq = (from rb in db.Requests
where rb.RequestID == transferRequest.RequestID
select rb).First();
foundReq.ResultStatusCode = "Submitted";
foundReq.AgentName = null;
db.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("Exception in AftsDb.ResubmitTransferRequest() : "
+ Utilities.UnwindExceptionMessages(ex));
}
}
//*********************************************************************
///
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
///
//*********************************************************************
public int FetchMaxRequestId(Models.AzureFileTransferContext db)
{
try
{
db.Database.Connection.ConnectionString = _ConnectionString;
var maxId = (from rb in db.Requests
select rb.RequestID).Max();
return(maxId);
}
catch (InvalidOperationException)
{
return(0);
}
catch (Exception ex)
{
return(0);
//throw new Exception("Exception in AftsDb.FetchMaxRequestID() : "
// + Utilities.UnwindExceptionMessages(ex));
}
}
//*********************************************************************
///
/// <summary>
///
/// </summary>
/// <param name="tagId"></param>
/// <returns></returns>
///
//*********************************************************************
public List <Models.Request> FetchRequestByTagId(int tagId)
{
var outList = new List <Models.Request>();
try
{
using (var db = new Models.AzureFileTransferContext())
{
db.Database.Connection.ConnectionString = _ConnectionString;
var foundReqList = (from rb in db.Requests
where rb.TagID == tagId
select rb);
outList.AddRange(foundReqList);
return(outList);
}
}
catch (Exception ex)
{
throw new Exception("Exception in AftsDb.FetchRequestByTagID() : "
+ Utilities.UnwindExceptionMessages(ex));
}
}