partial void DeleteNonComplaintUser(NonComplaintUser instance);
partial void InsertNonComplaintUser(NonComplaintUser instance);
partial void UpdateNonComplaintUser(NonComplaintUser instance);
/// <summary>
/// ProcessNonComplaintUsers
/// </summary>
public void ProcessNonComplaintUsers()
{
try
{
IList<NonComplaintUser> ncuList = new List<NonComplaintUser>();
var recyclerScanInfos = context.RecyclerScanInfos.Where(@w => @w.Processed == null);
if (recyclerScanInfos != null && recyclerScanInfos.Count() > 0)
{
foreach (var recyclerScan in recyclerScanInfos)
{
var garbage = context.Garbages.Where(@w => @w.Tag == recyclerScan.Tag).First();
var bin = context.Bins.Where(@w => @w.Id == garbage.BinId).First();
var recycler = context.Recyclers.Where(@w => @w.Id == recyclerScan.RecyclerId).First();
var ward = context.Wards.Where(@w => @w.Id == recycler.WardId).First();
NonComplaintUser ncu = new NonComplaintUser
{
Id = Guid.NewGuid(),
UserId = bin.UserId,
WardId = ward.Id,
CreatedDateTime = DateTime.Now
};
ncuList.Add(ncu);
recyclerScan.Processed = true;
}
context.NonComplaintUsers.InsertAllOnSubmit(ncuList.AsEnumerable());
var ncus = context.NonComplaintUsers.Where(@w => @w.Processed == null &&
DateTime.Compare(@w.CreatedDateTime, DateTime.Today.AddDays(-7)) > 1 &&
@w.Accepted == true);
if (ncus != null && ncus.Count() > 0)
{
foreach (var ncu in ncus)
{
ncu.Processed = true;
}
}
SubmitData();
}
}
catch (Exception ex)
{
using (StreamWriter sw = File.AppendText(@"C:\IWMSLog.txt"))
{
Log(ex.Message, sw);
}
}
}