Exemple #1
0
        public static bool AddCdu(Cdu.Info cdu)
        {
            try
            {
                using (var ctx = new LocalDB())
                {
                    Database.LocalDB.Model.CDU newcdu = new Database.LocalDB.Model.CDU()
                    {
                        No = cdu.cduNo,
                        Name = cdu.cduName,
                        Extendable = cdu.isExtended,
                        IpAddress = cdu.ip,
                        Enabled = cdu.isUsing,
                        InstallAt = cdu.installDate,
                    };

                    using (var trx = new TransactionScope())
                    {
                        ctx.Cdu.Add(newcdu);
                        ctx.SaveChanges();
                        trx.Complete();
                    }
                }
                return true;
            }
            catch (Exception e)
            {
                Console.WriteLine($"AddCdu : {e.ToString()}");
                return false;
            }
        }
Exemple #2
0
        public static bool SetCdu(Cdu.Info cdu)
        {
            try
            {
                using (var ctx = new LocalDB())
                {
                    var existCdu =
                        (from c in ctx.Cdu where c.Idx == cdu.cduIdx select c).DefaultIfEmpty(null).First();
                    if (existCdu == null)
                        return false;

                    //existCdu.GroupNo = cdu.
                    existCdu.No = cdu.cduNo;
                    existCdu.Name = cdu.cduName;
                    existCdu.Extendable = cdu.isExtended;
                    existCdu.IpAddress = cdu.ip;
                    existCdu.Enabled = cdu.isUsing;
                    existCdu.InstallAt = cdu.installDate;
                    //existCdu.Description = cdu.

                    using (var trx = new TransactionScope())
                    {
                        ctx.SaveChanges();
                        trx.Complete();
                    }
                }
                return true;
            }
            catch (Exception e)
            {
                Console.WriteLine($"SetCdu : {e.ToString()}");
                return false;
            }
        }