public bool EditByTypeId(List <SystemFluidConfiguration> recordList, short typeId)
        {
            try
            {
                using (WanTaiEntities entities = new WanTaiEntities())
                {
                    var records = entities.SystemFluidConfigurations.Where(p => p.ItemType == typeId);
                    foreach (SystemFluidConfiguration record in records)
                    {
                        entities.DeleteObject(record);
                    }

                    foreach (SystemFluidConfiguration record in recordList)
                    {
                        record.ItemID = WanTaiObjectService.NewSequentialGuid();
                        entities.AddToSystemFluidConfigurations(record);
                    }

                    entities.SaveChanges();
                    return(true);
                }
            }
            catch (Exception e)
            {
                string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace;
                LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "." + MethodBase.GetCurrentMethod(), SessionInfo.ExperimentID);
                return(false);
            }
        }
示例#2
0
        public bool Delete(Guid itemId)
        {
            try
            {
                using (WanTaiEntities entities = new WanTaiEntities())
                {
                    var record = entities.ReagentAndSuppliesConfigurations.Where(p => p.ItemID == itemId).FirstOrDefault();
                    entities.DeleteObject(record);

                    entities.SaveChanges();
                    return(true);
                }
            }
            catch (Exception e)
            {
                string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace;
                LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->Delete", SessionInfo.ExperimentID);
                return(false);
            }
        }
        public bool Create(List <RotationInfo> rotationInfoList)
        {
            try
            {
                using (WanTaiEntities entities = new WanTaiEntities())
                {
                    var oldRotations = entities.RotationInfoes.Where(c => c.ExperimentID == SessionInfo.ExperimentID);

                    if (oldRotations.Count() > 0)
                    {
                        foreach (RotationInfo old in oldRotations)
                        {
                            entities.DeleteObject(old);
                        }
                    }

                    foreach (RotationInfo rotationInfo in rotationInfoList)
                    {
                        entities.AddToRotationInfoes(rotationInfo);
                        if (rotationInfo.TubesBatchID != null)
                        {
                            var plates = entities.Plates.Where(P => P.TubesBatchID == rotationInfo.TubesBatchID);
                            foreach (Plate plate in plates)
                            {
                                plate.RotationID = rotationInfo.RotationID;
                            }
                        }
                    }

                    entities.SaveChanges();
                }

                return(true);
            }
            catch (Exception e)
            {
                string errorMessage = e.Message + System.Environment.NewLine + e.StackTrace;
                LogInfoController.AddLogInfo(LogInfoLevelEnum.Error, errorMessage, SessionInfo.LoginName, this.GetType().ToString() + "->" + "Create()", SessionInfo.ExperimentID);
                return(false);
            }
        }