C# RedBloodDataContext.SubmitChanges方法代码示例

        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 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 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 Delete(int ID)
    {
        RedBloodDataContext db = new RedBloodDataContext();
        Campaign e = Get(ID, db);

        db.Campaigns.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 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 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();
        }

        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 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 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 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;
    }