Exemplo n.º 1
0
        public static void Update(BRStatusView bRStatusView, int ID)
        {
            const string ServerName = @"WIN-3QNLGCNIT6M\SHAREPOINT";
            string       connection = Common.GetSQLonnectionString("ReferenceData");

            ULSLoggingService.LogMessage(string.Format("server name is {0}", ServerName));
            ULSLoggingService.LogMessage(string.Format("secure store connection string is {0}", connection));
            ReferenceDataClasses1DataContext dataContext = new ReferenceDataClasses1DataContext
                                                               (connection);
            Recl_BRstatus BRStatus = (from Recl_BRstatus in dataContext.Recl_BRstatus.AsEnumerable().Take(20)
                                      where Recl_BRstatus.ID == ID
                                      select Recl_BRstatus).Single();

            if (BRStatus != null)
            {
                //BRStatus.ID = bRStatusView.ID;
                BRStatus.BlockID       = bRStatusView.BlockID;
                BRStatus.Phase         = bRStatusView.Phase;
                BRStatus.BRstatus      = bRStatusView.BRStatus;
                BRStatus.DateInitiated = bRStatusView.DateInitiated;
                BRStatus.DateApproved  = bRStatusView.DateApproved;
                BRStatus.Notes         = bRStatusView.Notes;
            }

            dataContext.SubmitChanges();
        }
Exemplo n.º 2
0
        public static BRStatusView Create(BRStatusView newBRStatusView)
        {
            const string ServerName = @"WIN-3QNLGCNIT6M\SHAREPOINT";
            string       connection = Common.GetSQLonnectionString("ReferenceData");

            ULSLoggingService.LogMessage(string.Format("server name is {0}", ServerName));
            ULSLoggingService.LogMessage(string.Format("secure store connection string is {0}", connection));
            ReferenceDataClasses1DataContext dataContext = new ReferenceDataClasses1DataContext
                                                               (connection);
            Recl_BRstatus BRStatus = new Recl_BRstatus();

            BRStatus.ID            = newBRStatusView.ID;
            BRStatus.Notes         = newBRStatusView.Notes;
            BRStatus.Phase         = newBRStatusView.Phase;
            BRStatus.BlockID       = newBRStatusView.BlockID;
            BRStatus.BRstatus      = newBRStatusView.BRStatus;
            BRStatus.DateApproved  = newBRStatusView.DateApproved;
            BRStatus.DateInitiated = newBRStatusView.DateApproved;
            dataContext.Recl_BRstatus.InsertOnSubmit(BRStatus);
            dataContext.SubmitChanges();

            string connection1 = Common.GetSQLonnectionString("TWCC");

            ULSLoggingService.LogMessage(string.Format("server name is {0}", connection1));
            TWCCClasses1DataContext dataContentTWCC = new TWCCClasses1DataContext
                                                          (connection1);
            SmallBlock smallBlock = new SmallBlock();

            smallBlock.MineArea = newBRStatusView.MineArea;
            smallBlock.SmallAC  = newBRStatusView.SmallAC;
            dataContentTWCC.SmallBlocks.InsertOnSubmit(smallBlock);
            dataContentTWCC.SubmitChanges();

            return(newBRStatusView);
        }
Exemplo n.º 3
0
        public static BRStatusView ReadItem(int iD, string smallBlock)
        {
            const string ServerName = @"WIN-3QNLGCNIT6M\SHAREPOINT";
            string       connection = Common.GetSQLonnectionString("ReferenceData");

            ULSLoggingService.LogMessage(string.Format("server name is {0}", ServerName));
            ULSLoggingService.LogMessage(string.Format("secure store connection string is {0}", connection));
            ReferenceDataClasses1DataContext dataContext = new ReferenceDataClasses1DataContext
                                                               (connection);
            Recl_BRstatus BRStatus = (from Recl_BRstatus in dataContext.Recl_BRstatus.AsEnumerable().Take(20)
                                      where Recl_BRstatus.ID == iD
                                      select Recl_BRstatus).Single();

            string connection1 = Common.GetSQLonnectionString("TWCC");

            ULSLoggingService.LogMessage(string.Format("server name is {0}", connection1));
            TWCCClasses1DataContext dataContentTWCC = new TWCCClasses1DataContext
                                                          (connection1);
            SmallBlock smallBlockentity = (from SmallBlock in dataContentTWCC.SmallBlocks.AsEnumerable().Take(20)
                                           where SmallBlock.SmallBlock1 == BRStatus.BlockID
                                           select SmallBlock).Single();
            BRStatusView view = new BRStatusView();

            if (BRStatus != null)
            {
                view.ID            = BRStatus.ID;
                view.BlockID       = BRStatus.BlockID;
                view.Phase         = BRStatus.Phase;
                view.BRStatus      = BRStatus.BRstatus;
                view.DateInitiated = BRStatus.DateInitiated;
                view.DateApproved  = BRStatus.DateApproved;
                view.Notes         = BRStatus.Notes;
            }

            if (smallBlockentity != null)
            {
                view.SmallAC  = smallBlockentity.SmallAC;
                view.MineArea = smallBlockentity.MineArea;
            }

            return(view);
        }
Exemplo n.º 4
0
        public static BRStatusView ReadItem(int iD)
        {
            const string ServerName = @"WIN-3QNLGCNIT6M\SHAREPOINT";


            ReferenceDataClasses1DataContext dataContext = new ReferenceDataClasses1DataContext
                                                               ("Data Source=" + ServerName + ";" +
                                                               "Initial Catalog=ReferenceData;Integrated Security=True");
            Recl_BRstatus BRStatus = (from Recl_BRstatus in dataContext.Recl_BRstatus.AsEnumerable().Take(20)
                                      where Recl_BRstatus.ID == iD
                                      select Recl_BRstatus).Single();
            TWCCClasses1DataContext dataContentTWCC = new TWCCClasses1DataContext
                                                          ("Data Source=" + ServerName + ";" +
                                                          "Initial Catalog=TWCC;Integrated Security=True");
            SmallBlock smallBlock = (from SmallBlock in dataContentTWCC.SmallBlocks.AsEnumerable().Take(20)
                                     where SmallBlock.SmallBlock1 == BRStatus.BlockID
                                     select SmallBlock).Single();
            BRStatusView view = new BRStatusView();

            if (BRStatus != null)
            {
                view.ID      = BRStatus.ID;
                view.BlockID = BRStatus.BlockID;

                /* view.Phase = BRStatus.Phase;
                 * view.BRStatus = BRStatus.BRstatus;
                 * view.DateInitiated = BRStatus.DateInitiated;
                 * view.DateApproved = BRStatus.DateApproved;
                 * view.Notes = BRStatus.Notes;*/
            }

            if (smallBlock != null)
            {
                // view.SmallAC = smallBlock.SmallAC;
                view.MineArea = smallBlock.MineArea;
            }

            return(view);
        }
Exemplo n.º 5
0
        public static IEnumerable <BRStatusView> ReadList()
        {
            const string ServerName = @"WIN-3QNLGCNIT6M\SHAREPOINT";
            string       connection = Common.GetSQLonnectionString("ReferenceData");

            ULSLoggingService.LogMessage(string.Format("server name is {0}", ServerName));
            ULSLoggingService.LogMessage(string.Format("secure store connection string is {0}", connection));
            ReferenceDataClasses1DataContext dataContext = new ReferenceDataClasses1DataContext
                                                               (connection);

            IEnumerable <Recl_BRstatus> cust = from Recl_BRstatus in dataContext.Recl_BRstatus.Take(20)

                                               select Recl_BRstatus;

            ULSLoggingService.LogMessage(string.Format("found one item from brstatuts"));

            List <BRStatusView> lbrstatusview = new List <BRStatusView>();
            SmallBlock          smallBlock    = null;

            foreach (Recl_BRstatus stat in cust)
            {
                try
                {
                    TWCCClasses1DataContext dataContentTWCC = new TWCCClasses1DataContext
                                                                  ("Data Source=" + ServerName + ";" +
                                                                  "Initial Catalog=TWCC;Integrated Security=True");
                    smallBlock = (from SmallBlock in dataContentTWCC.SmallBlocks.AsEnumerable().Take(20)
                                  where SmallBlock.SmallBlock1 == stat.BlockID
                                  select SmallBlock).Single();
                    ULSLoggingService.LogMessage(string.Format("found one item from smallblocks {0}", stat.ID));
                }
                catch (Exception ex)
                {
                    ULSLoggingService.LogUIException(string.Format("error in read list bdc {0}", ex.Message), ex);
                }

                BRStatusView view = new BRStatusView();
                if (stat != null)
                {
                    view.ID            = stat.ID;
                    view.BlockID       = stat.BlockID;
                    view.Phase         = stat.Phase;
                    view.BRStatus      = stat.BRstatus;
                    view.DateInitiated = stat.DateInitiated;
                    view.DateApproved  = stat.DateApproved;
                    view.Notes         = stat.Notes;
                }

                if (smallBlock != null)
                {
                    view.SmallAC  = smallBlock.SmallAC;
                    view.MineArea = smallBlock.MineArea;
                }
                lbrstatusview.Add(view);
            }



            ULSLoggingService.LogMessage("finished readlist");

            return(lbrstatusview);
        }
Exemplo n.º 6
0
 public static void Update(BRStatusView bRStatus)
 {
     throw new System.NotImplementedException();
 }
Exemplo n.º 7
0
 public static Recl_BRstatus Create(BRStatusView newBRStatus)
 {
     throw new System.NotImplementedException();
 }