public override JustGronkIT()
{
using (_db = new MDBDataContext("myconnectstring"))
{
//do stuff with SQL
//Note that I am using a using block and connections to SQL are properly disposed of when the using block ends
}
}
/// <summary>
/// Constructor
/// </summary>
public BaseDAL()
{
mdbDataContext = new MDBDataContext(DatabaseConnection.DatabaseConnectionString);
//To avoid Error : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
mdbDataContext.CommandTimeout = !String.IsNullOrEmpty(DatabaseConnection.DataContextCommandTimeout.ToString()) ?
Convert.ToInt32(DatabaseConnection.DataContextCommandTimeout) :
mdbDataContext.CommandTimeout;
}
/// <summary>
/// Run recalculation process
/// </summary>
/// <param name="mdbConnectionString"></param>
/// <param name="logFilePath"></param>
private void Run(string mdbConnectionString, string logFilePath)
{
Recalculation recalculation = new Recalculation();
//recalculation.RecalculateMilestones();
MDBDataContext arbsDataContext = new MDBDataContext(mdbConnectionString);
List <Library.DataAccess.LINQ.Recalculation> recalculations = arbsDataContext.Recalculations.Where(r => !r.IsDeleted &&
r.Status == Convert.ToInt32(Library.Common.Constants.RecalculationStatus.PENDING) ||
r.Status == Convert.ToInt32(Library.Common.Constants.RecalculationStatus.IN_PROGRESS)).ToList();
if (recalculations.Count > 0)
{
bool isRecalculationInProgress = recalculations.Any(r => r.Status == Convert.ToInt32(Library.Common.Constants.RecalculationStatus.IN_PROGRESS));
// IF recalculation not in running
if (!isRecalculationInProgress)
{
RecalculationVO recalculationVO = new RecalculationVO(recalculations.FirstOrDefault(r => r.Status == Convert.ToInt32(Library.Common.Constants.RecalculationStatus.PENDING)));
//if (recalculationVO != null)
//{
// List<int> indexIds = new List<int>();
// if (recalculationVO.IndexIds.Contains(";"))
// {
// string[] ids = recalculationVO.IndexIds.Split(';');
// indexIds.AddRange(ids.Select(id => Convert.ToInt32(id)));
// }
// else
// {
// indexIds.Add(Convert.ToInt32(recalculationVO.IndexIds));
// }
//}
recalculation.RecalculateMilestone(recalculationVO, 1);
}
}
}
