public static void Update(string DIN, string bloodGroup, string note) { RedBloodDataContext db = new RedBloodDataContext(); Donation e = DonationBLL.Get(db, DIN); if (e == null) { throw new Exception(DonationErrEnum.NonExist.Message); } if (!CanUpdateTestResult(e)) { throw new Exception(DonationErrEnum.TRLocked.Message); } if (bloodGroup.Trim() != e.BloodGroup) { e.BloodGroup = bloodGroup; DonationTestLogBLL.Insert(db, e, PropertyName.For <Donation>(r => r.BloodGroup), note); } //Have to save before updaye TestResult Status db.SubmitChanges(); UpdateTestResultStatus(e); db.SubmitChanges(); }
protected void btnSave_Click(object sender, EventArgs e) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = DonationBLL.Get(db, DIN); if (d == null) { Clear(); } else { //TODO: Check to see too late to update // Code check will be here d.Collector = txtCollector.Text.Trim(); if (d.Pack != null) { d.Pack.Volume = txtVolume.Text.ToInt(); d.Pack.Note = txtNote.Text.Trim(); } d.Note = txtNote.Text.Trim(); db.SubmitChanges(); this.Alert("Lưu thành công."); } }
public static PackTransaction Add(Guid packID, Pack.StatusX fromStatus, Pack.StatusX toStatus, PackTransaction.TypeX type, string note) { //Always run SOD before new transaction RedBloodSystemBLL.SOD(); RedBloodDataContext db = new RedBloodDataContext(); if (fromStatus == toStatus) { throw new Exception("Can not add pack transaction if not change pack status."); } PackTransaction e = new PackTransaction(); e.FromStatus = fromStatus; e.ToStatus = toStatus; e.PackID = packID; e.Type = type; e.Actor = RedBloodSystem.CurrentActor; e.Note = note.Trim(); db.PackTransactions.InsertOnSubmit(e); db.SubmitChanges(); return(e); }
public static void Backup(DateTime date) { Validate(date); string err = "Process for day: " + date.Date.ToShortDateString() + ". "; RedBloodDataContext db = new RedBloodDataContext(); if (db.PackRemainDailies.Where(r => r.Date.Value.Date == date.Date).Count() > 0) { LogBLL.LogsFailAndThrow(err + "Existing data."); } IQueryable<Pack> rows = db.Packs.Where(r => r.Status == Pack.StatusX.Product); //Insert foreach (Pack item in rows) { PackRemainDaily r = new PackRemainDaily(); r.PackID = item.ID; r.Status = item.Status; r.Date = date; r.Note = "Process on: " + DateTime.Now.ToString(); db.PackRemainDailies.InsertOnSubmit(r); } db.SubmitChanges(); LogBLL.Logs(); }
public static void Backup(DateTime date) { Validate(date); string err = "Process for day: " + date.Date.ToShortDateString() + ". "; RedBloodDataContext db = new RedBloodDataContext(); if (db.PackRemainDailies.Where(r => r.Date.Value.Date == date.Date).Count() > 0) { LogBLL.LogsFailAndThrow(err + "Existing data."); } IQueryable <Pack> rows = db.Packs.Where(r => r.Status == Pack.StatusX.Product); //Insert foreach (Pack item in rows) { PackRemainDaily r = new PackRemainDaily(); r.PackID = item.ID; r.Status = item.Status; r.Date = date; r.Note = "Process on: " + DateTime.Now.ToString(); db.PackRemainDailies.InsertOnSubmit(r); } db.SubmitChanges(); LogBLL.Logs(); }
public static void Add(int orderID, string DIN, string productCode) { //using (TransactionScope scope = new TransactionScope()) //{ // scope.Complete(); //} RedBloodDataContext db = new RedBloodDataContext(); Order r = OrderBLL.Get4Add(orderID); Pack p = PackBLL.Get4Order(DIN, productCode); var check_po = db.PackOrders.FirstOrDefault(r1 => r1.PackID == p.ID && r1.OrderID == r.ID && r1.ReturnID == null); if (check_po == null) { PackOrder po = new PackOrder(); po.OrderID = r.ID; po.PackID = p.ID; db.PackOrders.InsertOnSubmit(po); db.SubmitChanges(); PackTransaction.TypeX transType = r.Type == Order.TypeX.ForCR ? PackTransaction.TypeX.Out_Order4CR : r.Type == Order.TypeX.ForOrg ? PackTransaction.TypeX.Out_Order4Org : PackTransaction.TypeX.Out_OrderGen; PackBLL.ChangeStatus(p.ID, Pack.StatusX.Delivered, transType, "PackOrderID = " + po.ID.ToString()); } else { throw new Exception("Túi máu đã có trong đợt cấp phát này."); } }
public string Delete(int ID) { RedBloodDataContext db = new RedBloodDataContext(); TestDef c = (from i in db.TestDefs where i.ID == ID select i).First(); if (c == null) { return(""); } Delete_Route(c, db); try { db.SubmitChanges(); return(""); } catch (Exception) { return("Dữ liệu đã được sử dụng. Không thể xóa."); } }
public static DonationErr Assign(string DIN, Guid peopleID, int campaignID, DateTime?collectedDate, string actor) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = (from c in db.Donations where c.DIN == DIN && c.PeopleID == null && c.CampaignID == null select c).FirstOrDefault(); if (d == null) { return(DonationErrEnum.NonExist); } try { d.PeopleID = peopleID; d.CollectedDate = collectedDate; d.CampaignID = campaignID; d.Actor = actor; UpdateStatus(db, d, Donation.StatusX.Assigned, "Assign peopleID=" + peopleID.ToString() + "&CampaignID=" + campaignID.ToString()); db.SubmitChanges(); CampaignBLL.SetStatus(campaignID); } catch (Exception ex) { return(new DonationErr(ex.Message)); } return(DonationErrEnum.Non); }
//Only pack has status 0 can be remove, to re-assign to another people. public static Pack RemovePeople(int autonum) { if (autonum == 0) { return(null); } RedBloodDataContext db = new RedBloodDataContext(); //Pack p = Get(db, autonum, Pack.StatusX.Collected); Pack p = new Pack(); //if (p == null && p.PeopleID != null) return p; //if (p.TestResultStatus != Pack.TestResultStatusX.Non) return p; ////remove people //p.PeopleID = null; //p.CollectedDate = null; //p.CampaignID = null; //PackStatusHistory h = ChangeStatus(db, p, Pack.StatusX.Init, "Remove peopleID=" + p.PeopleID.ToString() + "&CampaignID=" + p.CampaignID.ToString()); //db.PackStatusHistories.InsertOnSubmit(h); db.SubmitChanges(); return(p); }
public static DonationErr Assign(string DIN, Guid peopleID, int campaignID, DateTime? collectedDate, string actor) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = (from c in db.Donations where c.DIN == DIN && c.PeopleID == null && c.CampaignID == null select c).FirstOrDefault(); if (d == null) { return DonationErrEnum.NonExist; } try { d.PeopleID = peopleID; d.CollectedDate = collectedDate; d.CampaignID = campaignID; d.Actor = actor; UpdateStatus(db, d, Donation.StatusX.Assigned, "Assign peopleID=" + peopleID.ToString() + "&CampaignID=" + campaignID.ToString()); db.SubmitChanges(); CampaignBLL.SetStatus(campaignID); } catch (Exception ex) { return new DonationErr(ex.Message); } return DonationErrEnum.Non; }
public void NewProfile(string username, string fullname, string phone) { RedBloodDataContext db = new RedBloodDataContext(); var users = from u in db.aspnet_Users where u.UserName == username select u; if (users.Count() != 1) { return; } aspnet_User user = users.First(); aspnet_UserProfile user_profile = new aspnet_UserProfile(); user_profile.UserID = user.UserId; user_profile.Fullname = fullname; user_profile.Phone = phone; if (user.aspnet_UserProfile == null) { db.aspnet_UserProfiles.InsertOnSubmit(user_profile); db.SubmitChanges(); } }
static public void Delete(int ID) { RedBloodDataContext db = new RedBloodDataContext(); Campaign e = Get(ID, db); db.Campaigns.DeleteOnSubmit(e); db.SubmitChanges(); }
public static void Delete(int ID) { RedBloodDataContext db = new RedBloodDataContext(); Campaign e = Get(ID, db); db.Campaigns.DeleteOnSubmit(e); db.SubmitChanges(); }
private static Guid?ImportPeople(RedBloodDataContext db, People outerP) { //Importing people if (outerP == null || db == null) { return(null); } People innerP = PeopleBLL.GetByID(outerP.ID); if (innerP == null) { People newP = new People(); newP.Name = outerP.Name; newP.DOB = outerP.DOB; newP.DOBYear = outerP.DOBYear; newP.CMND = outerP.CMND; newP.SexID = outerP.SexID; GeoBLL.Insert( outerP.ResidentGeo1 != null ? outerP.ResidentGeo1.Name : "" , outerP.ResidentGeo2 != null ? outerP.ResidentGeo2.Name : "" , outerP.ResidentGeo3 != null ? outerP.ResidentGeo3.Name : ""); newP.ResidentAddress = outerP.ResidentAddress; newP.SetResidentGeo3(outerP.FullResidentalGeo); if (outerP.EnableMailingAddress.HasValue && outerP.EnableMailingAddress.Value) { GeoBLL.Insert( outerP.MailingGeo1 != null ? outerP.MailingGeo1.Name : "" , outerP.MailingGeo2 != null ? outerP.MailingGeo2.Name : "" , outerP.MailingGeo3 != null ? outerP.MailingGeo3.Name : ""); newP.MailingAddress = outerP.MailingAddress; newP.SetMailingGeo3(outerP.FullMaillingGeo); newP.EnableMailingAddress = outerP.EnableMailingAddress; } newP.Job = outerP.Job; newP.Email = outerP.Email; newP.Phone = outerP.Phone; newP.Note = outerP.Note; db.Peoples.InsertOnSubmit(newP); db.SubmitChanges(); return(newP.ID); } else { return(innerP.ID); } }
public static List <Donation> New(int count) { RedBloodDataContext db = new RedBloodDataContext(); List <Donation> l = New(db, count); db.SubmitChanges(); return(l); }
public static void Delete(Guid ID) { RedBloodDataContext db = new RedBloodDataContext(); Receipt e = Get(ID, db); db.Receipts.DeleteOnSubmit(e); db.SubmitChanges(); }
public static void Delete(Guid ID) { RedBloodDataContext db = new RedBloodDataContext(); Receipt e = Get(ID, db); db.Receipts.DeleteOnSubmit(e); db.SubmitChanges(); }
public static DonationErr Update(string DIN, string HIV, string HCV_Ab, string HBs_Ag, string Syphilis, string Malaria, string note, bool updateIfAllNon = false) { RedBloodDataContext db = new RedBloodDataContext(); Donation e = DonationBLL.Get(db, DIN); if (e == null || !CanUpdateTestResult(e)) { return(DonationErrEnum.TRLocked); } string old = e.InfectiousMarkers; if (!updateIfAllNon || (updateIfAllNon && e.Markers.IsAllNon) ) { // Warning: As CR user requirement, value for both test result are always the same. e.InfectiousMarkers = Infection.HIV_Ab.Encode(e.InfectiousMarkers, HIV); e.InfectiousMarkers = Infection.HIV_Ag.Encode(e.InfectiousMarkers, HIV); e.InfectiousMarkers = Infection.HCV_Ab.Encode(e.InfectiousMarkers, HCV_Ab); e.InfectiousMarkers = Infection.HBs_Ag.Encode(e.InfectiousMarkers, HBs_Ag); e.InfectiousMarkers = Infection.Syphilis.Encode(e.InfectiousMarkers, Syphilis); e.InfectiousMarkers = Infection.Malaria.Encode(e.InfectiousMarkers, Malaria); if (old != e.InfectiousMarkers) { DonationTestLogBLL.Insert(db, e, PropertyName.For <Donation>(r => r.Markers), note); } //Have to save before update TestResult Status db.SubmitChanges(); UpdateTestResultStatus(e); db.SubmitChanges(); } return(DonationErrEnum.Non); }
public Guid Insert(string name) { RedBloodDataContext db = new RedBloodDataContext(); Sex e = new Sex(); e.Name = name; db.Sexes.InsertOnSubmit(e); db.SubmitChanges(); return e.ID; }
public Guid Insert(string name) { RedBloodDataContext db = new RedBloodDataContext(); Sex e = new Sex(); e.Name = name; db.Sexes.InsertOnSubmit(e); db.SubmitChanges(); return(e.ID); }
public ActionResult ChangeProduct(string DIN, string oldProductCode, string newProductCode) { RedBloodDataContext db = new RedBloodDataContext(); var v = db.Packs.First(r => r.ProductCode == oldProductCode && r.DIN == DIN); v.ProductCode = newProductCode; db.SubmitChanges(); return View("About"); }
public static void Delete(int deleteID, Guid packID, string note) { RedBloodDataContext db = new RedBloodDataContext(); Pack p = Get4Delete(db, packID); p.DeleteID = deleteID; db.SubmitChanges(); PackBLL.ChangeStatus(p.ID, Pack.StatusX.Delete, PackTransaction.TypeX.Out_Delete, note); }
public static Donation SetOriginalPack(string DIN, Guid packID) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = Get4CreateOriginal(db, DIN); d.OrgPackID = packID; db.SubmitChanges(); return(d); }
static void Logs(Log.StatusX status, string method, string note) { Log e = new Log(); e.Status = status; e.Method = method; e.Actor = RedBloodSystem.CurrentActor; e.Note = note; RedBloodDataContext db = new RedBloodDataContext(); db.Logs.InsertOnSubmit(e); db.SubmitChanges(); }
public static void Return(int returnID, int packOrderID, string note) { RedBloodDataContext db = new RedBloodDataContext(); PackOrder po = Get4Return(db, packOrderID); po.ReturnID = returnID; db.SubmitChanges(); PackBLL.ChangeStatus(po.Pack.ID, Pack.StatusX.Product, PackTransaction.TypeX.In_Return, note); }
public static void Clear(DateTime date) { Validate(date); RedBloodDataContext db = new RedBloodDataContext(); var v = db.PackRemainDailies.Where(r => r.Date == date.Date); db.PackRemainDailies.DeleteAllOnSubmit(v); db.SubmitChanges(); LogBLL.Logs(); }
public Guid InsertOrUpdate(Guid ID, Func <Receipt, Receipt> loadFromGUI) { RedBloodDataContext db = new RedBloodDataContext(); Receipt r; if (ID == Guid.Empty) { r = new Receipt(); db.Receipts.InsertOnSubmit(r); } else { r = ReceiptBLL.Get(ID, db); } loadFromGUI(r); //Product In IEnumerable <ReceiptProduct> existingProductCodeInList = r.ReceiptProducts.Where(r1 => r1.Type == ReceiptProduct.TypeX.In); db.ReceiptProducts.DeleteAllOnSubmit( existingProductCodeInList.Where(r1 => !ProductCodeInList.Contains(r1.ProductCode)) ); r.ReceiptProducts.AddRange( ProductCodeInList .Except(existingProductCodeInList.Select(r1 => r1.ProductCode)) .Select(r1 => new ReceiptProduct() { ProductCode = r1, Type = ReceiptProduct.TypeX.In }) ); //Product Out IEnumerable <ReceiptProduct> existingProductCodeOutList = r.ReceiptProducts.Where(r1 => r1.Type == ReceiptProduct.TypeX.Out); db.ReceiptProducts.DeleteAllOnSubmit( existingProductCodeOutList.Where(r1 => !ProductCodeOutList.Contains(r1.ProductCode)) ); r.ReceiptProducts.AddRange( ProductCodeOutList .Except(existingProductCodeOutList.Select(r1 => r1.ProductCode)) .Select(r1 => new ReceiptProduct() { Product = ProductBLL.Get(db, r1), Type = ReceiptProduct.TypeX.Out }) ); db.SubmitChanges(); return(r.ID); }
public static void Clear(DateTime date) { Validate(date); RedBloodDataContext db = new RedBloodDataContext(); var v = db.PackRemainDailies.Where(r => r.Date == date.Date); db.PackRemainDailies.DeleteAllOnSubmit(v); db.SubmitChanges(); LogBLL.Logs(); }
public static void Add(string DIN, string productCode, int?volume, bool isOriginal) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = null; if (isOriginal) { d = DonationBLL.Get4CreateOriginal(db, DIN); } else { d = DonationBLL.Get(DIN); } Product product = ProductBLL.Get(productCode); if (IsExist(DIN, productCode)) { throw new Exception(PackErrEnum.Existed.Message); } //TODO: Check to see valid product code in collection //Code will be here //TODO: Check to see if the pack is collector too late //Code check will be here. Pack pack = new Pack(); pack.DIN = DIN; pack.ProductCode = productCode; pack.Status = Pack.StatusX.Product; pack.Actor = RedBloodSystem.CurrentActor; //pack.Volume = product.OriginalVolume.HasValue ? product.OriginalVolume : defaultVolume; pack.Volume = volume; pack.ExpirationDate = DateTime.Now.Add(product.Duration.Value - RedBloodSystem.RootTime); db.Packs.InsertOnSubmit(pack); db.SubmitChanges(); PackTransactionBLL.Add(pack.ID, Pack.StatusX.Non, Pack.StatusX.Product, isOriginal ? PackTransaction.TypeX.In_Collect : PackTransaction.TypeX.In_Product); if (isOriginal) { DonationBLL.SetOriginalPack(DIN, pack.ID); } }
protected void btnUpdate_Click(object sender, EventArgs e) { //Thread.Sleep(5000); if (PeopleID == Guid.Empty) { RedBloodDataContext db = new RedBloodDataContext(); People p = new People(); if (LoadFromGUI(p)) { db.Peoples.InsertOnSubmit(p); db.SubmitChanges(); PeopleID = p.ID; } else { return; } } else { RedBloodDataContext db = new RedBloodDataContext(); var p = (from c in db.Peoples where c.ID == PeopleID select c).First(); if (p == null) { return; } if (LoadFromGUI(p)) { db.SubmitChanges(); PeopleID = p.ID; } else { return; } } //txtName.Focus(); Page.Alert("Lưu thành công."); if (Page.Master is MasterPage) { ((MasterPage)Page.Master).TextBoxCode.Focus(); } }
public static void ResetCounting() { RedBloodDataContext db = new RedBloodDataContext(); Facility f = GetFirst(db); string YY = DateTime.Now.Year.ToString().Substring(2, 2); if (f.CountingYY != YY) { f.CountingYY = YY; f.CountingNumber = 0; } db.SubmitChanges(); }
public static void UpdateFullname() { RedBloodDataContext db = new RedBloodDataContext(); var r = from e in db.SideEffects select e; foreach (SideEffect e in r) { SetFullname(e); } db.SubmitChanges(); }
public static void UpdateCollector(string DIN, string collector) { RedBloodDataContext db = new RedBloodDataContext(); Donation e = Get(db, DIN); if (e != null && string.IsNullOrEmpty(e.Collector) && !string.IsNullOrEmpty(collector) && !string.IsNullOrEmpty(collector.Trim())) { e.Collector = collector.Trim(); db.SubmitChanges(); } }
static void Logs(Log.StatusX status, string method, string note) { Log e = new Log(); e.Status = status; e.Method = method; e.Actor = RedBloodSystem.CurrentActor; e.Note = note; RedBloodDataContext db = new RedBloodDataContext(); db.Logs.InsertOnSubmit(e); db.SubmitChanges(); }
public static void ResetCounting() { RedBloodDataContext db = new RedBloodDataContext(); Facility f = GetFirst(db); string YY = DateTime.Now.Year.ToString().Substring(2, 2); if (f.CountingYY != YY) { f.CountingYY = YY; f.CountingNumber = 0; } db.SubmitChanges(); }
public static DonationErr Assign(string DIN, Guid peopleID, int campaignID, DateTime? collectedDate, string actor) { RedBloodDataContext db = new RedBloodDataContext(); //Donation d = (from c in db.Donations // where c.DIN == DIN && c.PeopleID == null && c.CampaignID == null // select c).FirstOrDefault(); var re = DonationErrEnum.Non; var existingPeople = db.Donations .FirstOrDefault(r => r.PeopleID == peopleID && r.CampaignID == campaignID); if (existingPeople == null) { var d = db.Donations .FirstOrDefault(r => r.DIN == DIN && r.PeopleID == null && r.CampaignID == null); if (d == null) { re = DonationErrEnum.NonExist; } else { try { d.PeopleID = peopleID; d.CollectedDate = collectedDate; d.CampaignID = campaignID; d.Actor = actor; DonationDAL.UpdateStatus(db, d.DIN, Donation.StatusX.Assigned, "Assign peopleID=" + peopleID.ToString() + "&CampaignID=" + campaignID.ToString()); db.SubmitChanges(); } catch (Exception ex) { re = new DonationErr(ex.Message); } } } else { re = DonationErrEnum.PeopleCollected; } return re; }
//public static void Add(int ID, string DIN, string productCode) //{ // Order r = OrderBLL.Get(ID); // if (r.Status == Order.StatusX.Done) // throw new Exception("Đợt cấp phát này đã kết thúc."); // Pack p = PackBLL.Get4Order(DIN, productCode); // PackOrder po = new PackOrder(); // po.OrderID = r.ID; // po.PackID = p.ID; // po.Status = PackOrder.StatusX.Order; // RedBloodDataContext db = new RedBloodDataContext(); // db.PackOrders.InsertOnSubmit(po); // db.SubmitChanges(); // string fullNote = "Add to Order: " + po.OrderID.Value.ToString() + "."; // PackBLL.Update(db, po.Pack, Pack.StatusX.Delivered, fullNote); // PackTransaction.TypeX transType = r.Type == Order.TypeX.ForCR ? PackTransaction.TypeX.Out_Order4CR // : r.Type == Order.TypeX.ForOrg ? PackTransaction.TypeX.Out_Order4Org // : PackTransaction.TypeX.Out_OrderGen; // PackTransactionBLL.Add(p.ID, // transType, // fullNote); //} //public static void Remove(int packOrderID, string note) //{ // RedBloodDataContext db = new RedBloodDataContext(); // PackOrder po = db.PackOrders.Where(r => r.ID == packOrderID).FirstOrDefault(); // if (po == null // || po.Pack == null // || po.Order == null) return; // string fullNote = DateTime.Now.ToStringVNLong() + ". " + RedBloodSystem.CurrentActor + ". Remove from Order: " + po.OrderID.Value.ToString() + ". " + note; // PackBLL.Update(db, po.Pack, Pack.StatusX.Product, fullNote); // po.Status = PackOrder.StatusX.Return; // po.Note = fullNote; // db.SubmitChanges(); // PackTransactionBLL.Add(po.Pack.ID, PackTransaction.TypeX.In_Return, fullNote); //} public static void CloseOrder() { RedBloodDataContext db = new RedBloodDataContext(); var v = db.Orders.Where(r => r.Status == Order.StatusX.Init && r.Date.Value.Date < DateTime.Now.Date).ToList(); foreach (var item in v) { item.Status = Order.StatusX.Done; } db.SubmitChanges(); LogBLL.Logs(); }
public static void ChangeStatus(Guid ID, Pack.StatusX toStatus, PackTransaction.TypeX transType, string note) { RedBloodDataContext db = new RedBloodDataContext(); Pack p = Get(db, ID); if (p.Status == toStatus) { throw new Exception("Can not change statuses which are the same."); } PackTransactionBLL.Add(ID, p.Status, toStatus, transType, note); p.Status = toStatus; db.SubmitChanges(); }
//public static void Add(int ID, string DIN, string productCode) //{ // Order r = OrderBLL.Get(ID); // if (r.Status == Order.StatusX.Done) // throw new Exception("Đợt cấp phát này đã kết thúc."); // Pack p = PackBLL.Get4Order(DIN, productCode); // PackOrder po = new PackOrder(); // po.OrderID = r.ID; // po.PackID = p.ID; // po.Status = PackOrder.StatusX.Order; // RedBloodDataContext db = new RedBloodDataContext(); // db.PackOrders.InsertOnSubmit(po); // db.SubmitChanges(); // string fullNote = "Add to Order: " + po.OrderID.Value.ToString() + "."; // PackBLL.Update(db, po.Pack, Pack.StatusX.Delivered, fullNote); // PackTransaction.TypeX transType = r.Type == Order.TypeX.ForCR ? PackTransaction.TypeX.Out_Order4CR // : r.Type == Order.TypeX.ForOrg ? PackTransaction.TypeX.Out_Order4Org // : PackTransaction.TypeX.Out_OrderGen; // PackTransactionBLL.Add(p.ID, // transType, // fullNote); //} //public static void Remove(int packOrderID, string note) //{ // RedBloodDataContext db = new RedBloodDataContext(); // PackOrder po = db.PackOrders.Where(r => r.ID == packOrderID).FirstOrDefault(); // if (po == null // || po.Pack == null // || po.Order == null) return; // string fullNote = DateTime.Now.ToStringVNLong() + ". " + RedBloodSystem.CurrentActor + ". Remove from Order: " + po.OrderID.Value.ToString() + ". " + note; // PackBLL.Update(db, po.Pack, Pack.StatusX.Product, fullNote); // po.Status = PackOrder.StatusX.Return; // po.Note = fullNote; // db.SubmitChanges(); // PackTransactionBLL.Add(po.Pack.ID, PackTransaction.TypeX.In_Return, fullNote); //} public static void CloseOrder() { RedBloodDataContext db = new RedBloodDataContext(); var v = db.Orders.Where(r => r.Status == Order.StatusX.Init && r.Date.Value.Date < DateTime.Now.Date).ToList(); foreach (var item in v) { item.Status = Order.StatusX.Done; } db.SubmitChanges(); LogBLL.Logs(); }
public void Update(int ID, string name) { RedBloodDataContext db = new RedBloodDataContext(); TestDef c = (from i in db.TestDefs where i.ID == ID select i).First(); if (c == null) { return; } c.Name = name; db.SubmitChanges(); }
public static void ChangeStatus(Guid ID, Pack.StatusX toStatus, PackTransaction.TypeX transType, string note) { RedBloodDataContext db = new RedBloodDataContext(); Pack p = Get(db, ID); if (p.Status == toStatus) { throw new Exception("Can not change statuses which are the same."); } PackTransactionBLL.Add(ID, p.Status, toStatus, transType, note); p.Status = toStatus; db.SubmitChanges(); }
public static void Add(string DIN, string productCode, int? volume, bool isOriginal) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = null; if (isOriginal) { d = DonationBLL.Get4CreateOriginal(db, DIN); } else { d = DonationBLL.Get(DIN); } Product product = ProductBLL.Get(productCode); if (IsExist(DIN, productCode)) throw new Exception(PackErrEnum.Existed.Message); //TODO: Check to see valid product code in collection //Code will be here //TODO: Check to see if the pack is collector too late //Code check will be here. Pack pack = new Pack(); pack.DIN = DIN; pack.ProductCode = productCode; pack.Status = Pack.StatusX.Product; pack.Actor = RedBloodSystem.CurrentActor; //pack.Volume = product.OriginalVolume.HasValue ? product.OriginalVolume : defaultVolume; pack.Volume = volume; pack.ExpirationDate = DateTime.Now.Add(product.Duration.Value - RedBloodSystem.RootTime); db.Packs.InsertOnSubmit(pack); db.SubmitChanges(); PackTransactionBLL.Add(pack.ID, Pack.StatusX.Non, Pack.StatusX.Product, isOriginal ? PackTransaction.TypeX.In_Collect : PackTransaction.TypeX.In_Product); if (isOriginal) { DonationBLL.SetOriginalPack(DIN, pack.ID); } }
//public object GetTSIn(bool isLongRun) //{ // RedBloodDataContext db = new RedBloodDataContext(); // if (isLongRun) // { // var rs = from r in db.Campaigns // let total = (r.Packs.Count(p => p.Status == Pack.StatusX.CommitReceived)) // where total > 0 && r.Type == Campaign.TypeX.Long_run // select new { r.ID, r.Name, SourceName = r.Source.Name, r.Note, total }; // return rs; // } // else // { // var rs = from r in db.Campaigns // let total = (r.Packs.Count(p => p.Status == Pack.StatusX.CommitReceived)) // where r.Type == Campaign.TypeX.Short_run && r.Status == Campaign.StatusX.Assign // select new { r.ID, r.Name, SourceName = r.Source.Name, r.Date, r.Note, total }; // return rs; // } //} static public void New(Campaign e) { RedBloodDataContext db = new RedBloodDataContext(); if (e.Type == Campaign.TypeX.Long_run) { e.Status = Campaign.StatusX.Assign; } if (e.Type == Campaign.TypeX.Short_run) { e.Status = Campaign.StatusX.Init; } db.Campaigns.InsertOnSubmit(e); db.SubmitChanges(); }
public static void RemoveOriginalPack(string DIN) { RedBloodDataContext db = new RedBloodDataContext(); Donation d = Get(db, DIN); if (d.CanRemoveOriginalPack) { Pack p = d.Pack; d.Pack = null; db.PackTransactions.DeleteAllOnSubmit(p.PackTransactions); db.PackRemainDailies.DeleteAllOnSubmit(p.PackRemainDailies); db.Packs.DeleteOnSubmit(p); db.SubmitChanges(); } }
public static int Add(List<int> packOrderIDList, string note) { RedBloodDataContext db = new RedBloodDataContext(); List<PackOrder> poL = PackOrderBLL.Get4Return(db, packOrderIDList); Return re = new Return(); re.Note = note; db.Returns.InsertOnSubmit(re); db.SubmitChanges(); foreach (var item in packOrderIDList) { PackOrderBLL.Return(re.ID, item, note); } return re.ID; }
public static int Add(List<Guid> packIDList, string note) { RedBloodDataContext db = new RedBloodDataContext(); List<Pack> poL = PackBLL.Get4Delete(db, packIDList); Delete re = new Delete(); re.Note = note; db.Deletes.InsertOnSubmit(re); db.SubmitChanges(); foreach (var item in packIDList) { PackBLL.Delete(re.ID, item, note); } return re.ID; }
public static int Add(DateTime date, PackTransaction.TypeX type, int count) { if (Get(date, type) != null) { LogBLL.LogsFailAndThrow("Existing datat."); } RedBloodDataContext db = new RedBloodDataContext(); StoreFinalize s = new StoreFinalize(); s.Date = date; s.Type = type; s.Count = count; s.Note = "Process on: " + DateTime.Now.ToString(); db.StoreFinalizes.InsertOnSubmit(s); db.SubmitChanges(); return 1; }
public void UpdateProfile(string username, string fullname, string phone) { RedBloodDataContext db = new RedBloodDataContext(); var users = from u in db.aspnet_Users where u.UserName == username select u; if (users.Count() != 1) return; aspnet_User user = users.First(); if (user.aspnet_UserProfile != null) { user.aspnet_UserProfile.Fullname = fullname; user.aspnet_UserProfile.Phone = phone; db.SubmitChanges(); } }
public static void Add(int orderID, string DIN, string productCode) { RedBloodDataContext db = new RedBloodDataContext(); Order r = OrderBLL.Get4Add(orderID); Pack p = PackBLL.Get4Order(DIN, productCode); PackOrder po = new PackOrder(); po.OrderID = r.ID; po.PackID = p.ID; db.PackOrders.InsertOnSubmit(po); db.SubmitChanges(); PackTransaction.TypeX transType = r.Type == Order.TypeX.ForCR ? PackTransaction.TypeX.Out_Order4CR : r.Type == Order.TypeX.ForOrg ? PackTransaction.TypeX.Out_Order4Org : PackTransaction.TypeX.Out_OrderGen; PackBLL.ChangeStatus(p.ID, Pack.StatusX.Delivered, transType, "PackOrderID = " + po.ID.ToString()); }
public static void Clear(DateTime date) { string err = "Process for day: " + date.Date.ToShortDateString() + ". "; if (date.Date > DateTime.Now.Date) { LogBLL.LogsFailAndThrow(err + "Date is in future."); } RedBloodDataContext db = new RedBloodDataContext(); if (db.StoreFinalizes.Where(r => r.Date.Value.Date > date.Date).Count() > 0) { LogBLL.LogsFailAndThrow(err + "Existing newer data."); } var v = db.StoreFinalizes.Where(r => r.Date == date.Date); db.StoreFinalizes.DeleteAllOnSubmit(v); db.SubmitChanges(); LogBLL.Logs(); }
public string Delete(int ID) { RedBloodDataContext db = new RedBloodDataContext(); TestDef c = (from i in db.TestDefs where i.ID == ID select i).First(); if (c == null) return ""; Delete_Route(c, db); try { db.SubmitChanges(); return ""; } catch (Exception) { return "Dữ liệu đã được sử dụng. Không thể xóa."; } }
public static int Add(List<Guid> packIDList, string note) { RedBloodDataContext db = new RedBloodDataContext(); List<Pack> poL = PackBLL.Get4Delete(db, packIDList); if (poL.Count == 0) throw new Exception("Không có túi máu để hủy."); Delete re = new Delete(); re.Note = note; re.Actor = RedBloodSystem.CurrentActor; db.Deletes.InsertOnSubmit(re); db.SubmitChanges(); foreach (var item in poL) { PackDeleteBLL.Add(re.ID, item.ID); } return re.ID; }
public static void Add(string DIN, string productCode, string fullSideEffects, string note) { Pack p = PackBLL.Get4ReportSideEffects(DIN, productCode); if (string.IsNullOrEmpty(fullSideEffects)) throw new Exception("Phản ứng phụ trống."); PackSideEffect se = new PackSideEffect(); se.PackID = p.ID; se.SetSideEffect(fullSideEffects); se.Actor = RedBloodSystem.CurrentActor; se.Date = DateTime.Now; se.Note = note; RedBloodDataContext db = new RedBloodDataContext(); db.PackSideEffects.InsertOnSubmit(se); db.SubmitChanges(); }
public static string Insert(string name, int level, Guid? parentID) { RedBloodDataContext db = new RedBloodDataContext(); SideEffect geo = new SideEffect(); geo.Name = name.Trim(); geo.Level = level; geo.ParentID = parentID; db.SideEffects.InsertOnSubmit(geo); try { db.SubmitChanges(); } catch (Exception ex) { return ex.Message; } return geo.ID.ToString(); }
static void LoadData(Type type) { RedBloodDataContext db = new RedBloodDataContext(); List<PrintSetting> list = db.PrintSettings.Where(r => r.Type == type.Name).ToList(); var l = type .GetMembers(BindingFlags.Public | BindingFlags.Static | BindingFlags.GetProperty) .Where(r => r is PropertyInfo) .Select(r => r as PropertyInfo) .Where(r => r.PropertyType == typeof(PrintSetting)); foreach (var item in l) { item.SetValue(type, list.Where(r => r.Name == item.Name).FirstOrDefault(), null); } bool needReload = false; foreach (var item in l) { var v = item.GetValue(type, null); if (v == null) { PrintSetting e = new PrintSetting(); e.Type = type.Name; e.Name = item.Name; e.Note = item.Name; db.PrintSettings.InsertOnSubmit(e); db.SubmitChanges(); needReload = true; } } if (needReload) { LoadData(type); } }
public static string Insert(string name, int level, Guid? parentID) { RedBloodDataContext db = new RedBloodDataContext(); Department geo = new Department(); geo.Name = name.Trim(); geo.Level = level; geo.ParentID = parentID; geo.HospitalID = HospitalBLL.GetFirst().ID; db.Departments.InsertOnSubmit(geo); try { db.SubmitChanges(); } catch (Exception ex) { return ex.Message; } return geo.ID.ToString(); }
public void NewProfile(string username, string fullname, string phone) { RedBloodDataContext db = new RedBloodDataContext(); var users = from u in db.aspnet_Users where u.UserName == username select u; if (users.Count() != 1) return; aspnet_User user = users.First(); aspnet_UserProfile user_profile = new aspnet_UserProfile(); user_profile.UserID = user.UserId; user_profile.Fullname = fullname; user_profile.Phone = phone; if (user.aspnet_UserProfile == null) { db.aspnet_UserProfiles.InsertOnSubmit(user_profile); db.SubmitChanges(); } }
public static void Add(int deleteID, Guid packID) { //using (TransactionScope scope = new TransactionScope()) //{ // scope.Complete(); //} RedBloodDataContext db = new RedBloodDataContext(); Delete r = DeleteBLL.Get(deleteID); Pack p = PackBLL.Get4Delete(db, packID); PackDelete po = new PackDelete(); po.DeleteID = r.ID; po.PackID = p.ID; po.Note = p.Donation.Description4Pos; db.PackDeletes.InsertOnSubmit(po); db.SubmitChanges(); PackTransaction.TypeX transType = PackTransaction.TypeX.Out_Delete; PackBLL.ChangeStatus(p.ID, Pack.StatusX.Delete, transType, "PackDeleteID = " + po.ID.ToString()); }
public static PackTransaction Add(Guid packID, Pack.StatusX fromStatus, Pack.StatusX toStatus, PackTransaction.TypeX type, string note) { //Always run SOD before new transaction RedBloodSystemBLL.SOD(); RedBloodDataContext db = new RedBloodDataContext(); if (fromStatus == toStatus) throw new Exception("Can not add pack transaction if not change pack status."); PackTransaction e = new PackTransaction(); e.FromStatus = fromStatus; e.ToStatus = toStatus; e.PackID = packID; e.Type = type; e.Actor = RedBloodSystem.CurrentActor; e.Note = note.Trim(); db.PackTransactions.InsertOnSubmit(e); db.SubmitChanges(); return e; }
protected void btnUpdate_Click(object sender, EventArgs e) { //Thread.Sleep(5000); if (PeopleID == Guid.Empty) { RedBloodDataContext db = new RedBloodDataContext(); People p = new People(); if (LoadFromGUI(p)) { db.Peoples.InsertOnSubmit(p); db.SubmitChanges(); PeopleID = p.ID; } else return; } else { RedBloodDataContext db = new RedBloodDataContext(); var p = (from c in db.Peoples where c.ID == PeopleID select c).First(); if (p == null) return; if (LoadFromGUI(p)) { db.SubmitChanges(); PeopleID = p.ID; } else return; } //txtName.Focus(); Page.Alert("Lưu thành công."); if (Page.Master is MasterPage) { ((MasterPage)Page.Master).TextBoxCode.Focus(); } }