コード例 #1
0
ファイル: DALDataLogger.cs プロジェクト: arnabknd4/scs0400915
        public static Boolean CreateDataLogger(DataLogger logger)
        {
            Boolean flag = false;
            if (!(IsExistingDataLogger(logger)))
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    using (var context = new SycousCon())
                    {
                        try
                        {
                            context.DataLoggers.AddObject(logger);
                            context.SaveChanges();
                            scope.Complete();
                            context.AcceptAllChanges();
                            flag = true;
                        }
                        catch (Exception ex)
                        {
                            context.Dispose();
                            throw;
                        }
                    }//
                }// using
            }//if

            return flag;
        }
コード例 #2
0
ファイル: BALDataLogger.cs プロジェクト: arnabknd4/scs2300915
        public bool UpdateRecord(Object loggerobj)
        {
            Boolean flag = false;
            DataLoggerMaster logger = (DataLoggerMaster)loggerobj;
            try
            {
                DataLogger _Logger = new DataLogger();
                _Logger.ID = Convert.ToInt32(logger.ID);
                if (logger.DataCollectorMake != null)
                {
                    _Logger.DataCollectorMake = logger.DataCollectorMake.Trim();
                }
                if (logger.DataCollectorModel != null)
                {
                    _Logger.DataCollectorModel = logger.DataCollectorModel.Trim();
                }
                if (logger.SerialNumber != null)
                {
                    _Logger.SerialNumber = logger.SerialNumber.Trim();
                }

                if (logger.SimNumber != null)
                {
                    _Logger.SimNumber = logger.SimNumber.Trim();
                }
                if (logger.Telephone != null)
                {
                    _Logger.Telephone = logger.Telephone.Trim();
                }
                if (logger.Location != null)
                {
                    _Logger.Location = logger.Location.Trim();
                }
                if (logger.RetrievalID != null)
                {
                    _Logger.RetrievalID = logger.RetrievalID;
                }
                if (logger.IPAddress != null)
                {
                    _Logger.IPAddress = logger.IPAddress.Trim();
                }

                _Logger.ModifyBy = logger.modifyBy;
                _Logger.ModifyDate = DateTime.Now;
                if (_Logger.ID != null)
                {
                    flag = DAL.DALDataLogger.UpdateDataLogger(_Logger);
                }
            }
            catch (Exception ex)
            {
                throw;
            }
            return flag;
        }
コード例 #3
0
ファイル: DALDataLogger.cs プロジェクト: arnabknd4/scs0400915
        public static Boolean UpdateDataLogger(DataLogger logger)
        {
            using (TransactionScope scope = new TransactionScope())
            {
                Boolean bol = false;
                using (var context = new SycousCon())
                {
                    try
                    {
                        var Update = context.DataLoggers.Where(c => c.ID == logger.ID);
                        foreach (DataLogger p in Update)
                        {
                            if (logger.DataCollectorMake != null)
                            {
                                p.DataCollectorMake = logger.DataCollectorMake;
                            }
                            if (logger.DataCollectorModel != null)
                            {
                                p.DataCollectorModel = logger.DataCollectorModel;
                            }
                            if (logger.SerialNumber != null)
                            {
                                p.SerialNumber = logger.SerialNumber;
                            }
                            if (logger.Communication != null)
                            {
                                p.Communication = logger.Communication;
                            }
                            if (logger.SimNumber != null)
                            {
                                p.SimNumber = logger.SimNumber;
                            }
                            if (logger.Telephone != null)
                            {
                                p.Telephone = logger.Telephone;
                            }
                            if (logger.Location != null)
                            {
                                p.Location = logger.Location;
                            }
                            if (logger.RetrievalID != null)
                            {
                                p.RetrievalID = logger.RetrievalID;
                            }
                            if (logger.IPAddress != null)
                            {
                                p.IPAddress = logger.IPAddress;
                            }
                            p.ModifyBy = logger.ModifyBy;
                            p.ModifyBy = logger.ModifyBy;
                        }//
                        context.SaveChanges();
                        context.AcceptAllChanges();
                        scope.Complete();
                        context.Dispose();
                        bol = true;
                    }
                    catch (Exception ex)
                    {
                        context.Dispose();
                        throw;
                    }

                }// using
                return bol;
            } //trans
        }
コード例 #4
0
ファイル: DALDataLogger.cs プロジェクト: arnabknd4/scs0400915
 public static bool IsExistingDataLogger(DataLogger logger)
 {
     using (var context = new SycousCon())
     {
         try
         {
             DataLogger objlogger = context.DataLoggers.SingleOrDefault(p => p.SerialNumber.ToUpper() == logger.SerialNumber.ToUpper());
             if (objlogger != null)
             { return true; }
             else
             {
                 return false;
             }
         }
         catch (Exception ex)
         {
             context.Dispose();
             throw;
         }
     }
 }
コード例 #5
0
ファイル: DALDataLogger.cs プロジェクト: arnabknd4/scs0400915
 public static DataLogger EditDataLogger(Int32 loggerid)
 {
     DataLogger Logger = new DataLogger();
     using (var context = new SycousCon())
     {
         try
         {
             Logger = context.DataLoggers.SingleOrDefault(s => s.ID == loggerid);
         }
         catch (Exception ex)
         {
             context.Dispose();
             throw;
         }
     }
     return Logger;
 }
コード例 #6
0
 /// <summary>
 /// Deprecated Method for adding a new object to the DataLoggers EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToDataLoggers(DataLogger dataLogger)
 {
     base.AddObject("DataLoggers", dataLogger);
 }
コード例 #7
0
 /// <summary>
 /// Create a new DataLogger object.
 /// </summary>
 /// <param name="id">Initial value of the ID property.</param>
 /// <param name="isDeleted">Initial value of the IsDeleted property.</param>
 /// <param name="isActive">Initial value of the IsActive property.</param>
 public static DataLogger CreateDataLogger(global::System.Int32 id, global::System.Int32 isDeleted, global::System.Boolean isActive)
 {
     DataLogger dataLogger = new DataLogger();
     dataLogger.ID = id;
     dataLogger.IsDeleted = isDeleted;
     dataLogger.IsActive = isActive;
     return dataLogger;
 }