public bool UpdateReconTracking2(Recon_Tracking model)
{
try
{
using (SimplyPaymentCardDataContext db = new SimplyPaymentCardDataContext(ConnectionStringIntranet))
{
var trackingData = db.Recon_Trackings.Where(t => t.TrackingNo == model.TrackingNo);
if (trackingData.Count() > 1)
{
var data = trackingData.Where(s => s.FileName == model.FileName);
if (data.Count() == 0)
{
var query = trackingData.Where(s => s.Flag == false);
if (query.Count() > 0)
{
query.First().FileName = model.FileName;
}
else
{
trackingData.First().FileName = model.FileName;
}
db.SubmitChanges();
}
}
}
return(true);
}
catch (Exception ex)
{
logger.Info("failed to update tracking data. Tracking number:" + model.TrackingNo + ex.Message);
return(false);
}
}
public bool UpdateReconTracking(Recon_Tracking model)
{
try
{
using (SimplyPaymentCardDataContext db = new SimplyPaymentCardDataContext(ConnectionStringIntranet))
{
var trackingData = db.Recon_Trackings.Where(t => t.TrackingNo == model.TrackingNo);
if (trackingData.Count() > 0)
{
foreach (var record in trackingData)
{
record.AddressLine1 = model.AddressLine1.Truncate(60);
record.AddressLine2 = model.AddressLine2.Truncate(60);
record.AddressLine3 = model.AddressLine3.Truncate(60);
record.Subub = model.Subub.Truncate(30);
record.State = model.State.Truncate(3);
record.Postcode = model.Postcode.Truncate(4);
record.FileName = model.FileName;
}
db.SubmitChanges();
}
}
return(true);
}
catch (Exception ex)
{
logger.Info("failed to update tracking data. Tracking number:" + model.TrackingNo + ex.Message);
return(false);
}
}
public Recon_Tracking GetReconTracking(string fileName, ref bool expired)
{
try
{
var result = new Recon_Tracking();
using (SimplyPaymentCardDataContext db = new SimplyPaymentCardDataContext(ConnectionStringIntranet))
{
result = db.Recon_Trackings.Where(s => s.FileName.Equals(fileName)).OrderByDescending(o => o.DR_UID).FirstOrDefault();
if (result == null)
{
return(null);
}
var dataReceived = db.Recon_DataReceiveds.Where(dr => dr.DR_UID == result.DR_UID).SingleOrDefault();
if (dataReceived == null)
{
logger.Info(string.Format("Could not find record in [Recon_DataReceiveds]. DR_UID: {0}, Tracking Number: {1}", result.DR_UID, result.TrackingNo));
return(null);
}
DateTime expiryDate = dataReceived.DR_Datetime.Value.AddMonths(3);
if (expiryDate < DateTime.Now)
{
expired = true;
}
}
return(result);
}
catch (Exception ex)
{
logger.Info(string.Format("FileName:{0}. Error:{1}", fileName, ex.Message));
return(null);
}
}
public bool UpdateReconWithConfirmCSVOld(Recon_Tracking model)
{
try
{
using (SimplyPaymentCardDataContext db = new SimplyPaymentCardDataContext(ConnectionStringIntranet))
{
var trackingData = db.Recon_Trackings.Where(t => t.TrackingNo == model.TrackingNo);
if (trackingData.Count() == 0)
{
logger.Info("Tracking No " + model.TrackingNo + " not exist in Recon_Tracking");
return(false);
}
if (trackingData.Count() > 1)
{
logger.Info("Tracking No " + model.TrackingNo + " has more than 1 record in Recon_Tracking");
return(false);
}
//check if the record is received within 3 month
//If within 3 months, update the Recon_Tracking and Recon_DataProcessed table
int druid = trackingData.SingleOrDefault().DR_UID;
var dataReceived = db.Recon_DataReceiveds.Where(dr => dr.DR_UID == druid).SingleOrDefault();
if (dataReceived == null)
{
return(false);
}
DateTime expiryDate = dataReceived.DR_Datetime.Value.AddMonths(3);
if (expiryDate > DateTime.Now)
{
// Update data in Recon_Tracking
trackingData.SingleOrDefault().Flag = model.Flag;
// Update data in Recon_DataProcessed
int dpuid = dataReceived.DR_DPUID.Value;
var dataProcessed = db.Recon_DataProcesseds.Where(dp => dp.DP_UID == dpuid).SingleOrDefault();
if (dataProcessed == null)
{
logger.Info("Tracking Record " + model.TrackingNo + " not exist in Recon_DataProcessed");
return(false);
}
//If the result for the tracking number is true, then increase DP_ArchSets by 1
if (model.Flag == true)
{
dataProcessed.DP_ArchSets = dataProcessed.DP_ArchSets + 1;
}
db.SubmitChanges();
}
}
return(true);
}
catch (Exception ex)
{
logger.Info(MethodBase.GetCurrentMethod().Name + ex.Message);
return(false);
}
}
public bool UpdateReconTracking(Recon_Tracking model, ref HashSet <int> druidUpdateList)
{
try
{
using (SimplyPaymentCardDataContext db = new SimplyPaymentCardDataContext(ConnectionStringIntranet))
{
var trackingData = db.Recon_Trackings.Where(t => t.TrackingNo == model.TrackingNo);
if (trackingData.Count() > 0)
{
foreach (var record in trackingData)
{
//check if the record is received within 3 month
//If within 3 months, update the Recon_Tracking and Recon_DataProcessed table
int druid = record.DR_UID;
var dataReceived = db.Recon_DataReceiveds.Where(dr => dr.DR_UID == druid).SingleOrDefault();
if (dataReceived == null)
{
return(false);
}
DateTime expiryDate = dataReceived.DR_Datetime.Value.AddMonths(3);
if (expiryDate > DateTime.Now)
{
record.Flag = model.Flag;
}
druidUpdateList.Add(record.DR_UID);
}
db.SubmitChanges();
}
}
return(true);
}
catch (Exception ex)
{
logger.Info(MethodBase.GetCurrentMethod().Name + ex.Message);
return(false);
}
}
