//isSOD: isStartOfDate
//public static void ScanExp(bool isSOD)
//{
//if (!isSOD || !LogBLL.IsLog(Task.TaskX.ScanExp))
//{
// RedBloodDataContext db = new RedBloodDataContext();
// List<Pack.StatusX> statusList = new List<Pack.StatusX> { Pack.StatusX.Product };
// IQueryable<Pack> rs = db.Packs.Where(r => statusList.Contains(r.Status) && r.ExpirationDate < DateTime.Now.Date);
// foreach (Pack r in rs)
// {
// PackStatusHistory h = PackBLL.Update(db, r, Pack.StatusX.Expired, RedBloodSystem.SODActor, "");
// if (h != null) db.PackStatusHistories.InsertOnSubmit(h);
// }
// db.SubmitChanges();
// LogBLL.Add(Task.TaskX.ScanExp);
//}
//}
//isSOD: isStartOfDate
//public static void CloseOrder(bool isSOD)
//{
// //if (!isSOD || !LogBLL.IsLog(Task.TaskX.CloseOrder))
// //{
// // RedBloodDataContext db = new RedBloodDataContext();
// // OrderBLL.CloseOrder(db);
// // db.SubmitChanges();
// // LogBLL.Add(Task.TaskX.CloseOrder);
// //}
//}
//isSOD: isStartOfDate
//public static void LockTestResult()
//{
//if (!isSOD || !LogBLL.IsLog(Task.TaskX.LockEnterTestResult))
//{
// RedBloodDataContext db = new RedBloodDataContext();
// PackBLL.LockEnterTestResult();
// db.SubmitChanges();
// LogBLL.Add(Task.TaskX.LockEnterTestResult);
//}
//}
/// <summary>
/// if true, count remaining packs directly in store
/// else count by sum up the remaining of previous date and total transaction in day
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
//static bool IsCountDirectly(DateTime date)
//{
// RedBloodDataContext db = new RedBloodDataContext();
// bool isCountDirectly = false;
// //new system, no data
// if (db.PackTransactions.Count() == 0)
// isCountDirectly = true;
// else
// {
// if (lastPackTransactionDate == null) throw new Exception("");
// else
// {
// GetLastTransactionDate();
// //All pack transactions were in the previous of the date.
// if (lastPackTransactionDate.Value.Date <= date.Date)
// isCountDirectly = true;
// }
// }
// return isCountDirectly;
//}
public static void Find(HttpResponse Response, TextBox txtCode)
{
if (txtCode == null)
{
return;
}
string key = txtCode.Text.Trim();
if (key.Length == 0)
{
return;
}
string pattern = @"\d+";
Regex regx = new Regex(pattern);
if (BarcodeBLL.IsValidPeopleCode(key))
{
People r = PeopleBLL.GetByCode(key);
if (r != null)
{
Response.Redirect(RedBloodSystem.Url4PeopleDetail + "key=" + r.ID.ToString());
}
}
else if (BarcodeBLL.IsValidDINCode(key))
{
Response.Redirect(RedBloodSystem.Url4DINDetail + "key=" + BarcodeBLL.ParseDIN(key));
}
else if (BarcodeBLL.IsValidCampaignCode(key))
{
Campaign r = CampaignBLL.Get(BarcodeBLL.ParseCampaignID(key));
if (r != null)
{
Response.Redirect(RedBloodSystem.Url4CampaignDetail + "key=" + r.ID.ToString());
}
}
else if (BarcodeBLL.IsValidOrderCode(key))
{
Order r = OrderBLL.Get(BarcodeBLL.ParseOrderID(key));
if (r != null)
{
Response.Redirect(RedBloodSystem.Url4Order4CR + "key=" + r.ID.ToString());
}
}
else if (key.Length > 3 && key.Substring(0, 3) == "/n:")
{
Response.Redirect(RedBloodSystem.Url4FindPeople + "key=" + key.Substring(3).Trim());
}
else if (regx.IsMatch(key) && key.Length >= BarcodeBLL.CMNDLength.ToInt())
{
People r = PeopleBLL.GetByCMND(key);
if (r != null)
{
Response.Redirect(RedBloodSystem.Url4PeopleDetail + "key=" + r.ID.ToString());
}
}
txtCode.Text = "";
}
public static IEnumerable <Donation> Get(int campaignID)
{
return(CampaignBLL.Get(campaignID).Donations);
}
public static List <Donation> GetUnLock(int campaignID)
{
return(CampaignBLL.Get(campaignID).CollectedDonations
.ToList()
.Where(r => !r.IsTRLocked).ToList());
}
public static void Importing()
{
//Validate database before insert
List <string> importedGeo = new List <string>();
RedBloodDataContext importDB;
try
{
importDB = new RedBloodDataContext(ConfigurationManager.ConnectionStrings["ImportingRedBlood_DBConnectionString"].ConnectionString);
//try to load whatever data to test connection
importDB.Sexes.ToList();
}
catch (Exception ex)
{
throw ex;
}
string strImportWithInDays = ConfigurationManager.AppSettings["ImportWithInDays"];
int importWithInDays = 1;
if (!string.IsNullOrEmpty(strImportWithInDays))
{
importWithInDays = strImportWithInDays.ToInt();
}
if (importWithInDays < 1)
{
importWithInDays = 1;
}
List <Donation> importDINList = importDB.Donations
.Where(r => r.CollectedDate.HasValue &&
(DateTime.Now.Date - r.CollectedDate.Value.Date).Days <= importWithInDays - 1 &&
r.PeopleID.HasValue &&
r.CampaignID.HasValue
)
.ToList();
RedBloodDataContext db = new RedBloodDataContext();
foreach (Donation item in importDINList)
{
//Validate DIN
Donation innerDIN = DonationBLL.Get(item.DIN);
if (innerDIN == null ||
innerDIN.CollectedDate.HasValue ||
innerDIN.PeopleID.HasValue
)
{
continue;
}
//Campaign
Campaign innerCam = CampaignBLL.Get(item.CampaignID.Value);
if (innerCam == null)
{
continue;
}
//People
if (item.People == null)
{
continue;
}
Guid?peopleID = ImportPeople(db, item.People);
if (!peopleID.HasValue || peopleID.Value == Guid.Empty)
{
continue;
}
//Import DIN
DonationBLL.Assign(innerDIN.DIN, peopleID.Value, innerCam.ID, item.CollectedDate, item.Actor);
DonationBLL.UpdateCollector(innerDIN.DIN, item.Collector);
if (item.Pack != null)
{
PackBLL.Add(innerDIN.DIN, item.Pack.ProductCode, item.Pack.Volume, packDate: item.Pack.Date);
DonationBLL.Update(innerDIN.DIN, item.BloodGroup, "ImportingFromMDF");
}
}
}