Exemple #1
0
        public Boolean InsertUpdateCSDirection(CSDirection direction)
        {
            InitDB();
            //Screen newScreen = new Screen();
            CSDirection newDirection = new CSDirection();

            try
            {
                newDirection.Query.Where(
                    newDirection.Query.Directionalscreenname.IsNotNull() &&
                    newDirection.Query.Meetingroomname.IsNotNull() &&
                    newDirection.Query.Directionalscreenname.ToLower().Equal(direction.Directionalscreenname.ToLower()) &&
                    newDirection.Query.Meetingroomname.ToLower().Equal(direction.Meetingroomname.ToLower()));

            }
            catch (Exception)
            {

            }

            Boolean functionResult = false;
            try
            {
                if (newDirection.Query.Load()) //Do update
                {
                    Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+"Updating Directional Information");
                    try
                    {
                        newDirection.Directionimageblob = direction.Directionimageblob;
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+ex.Message);
                        newDirection.Directionimageblob = null;
                    }

                    newDirection.Directionimagefile = direction.Directionimagefile;
                    newDirection.Directiontext = direction.Directiontext;
                    newDirection.Save();
                    functionResult = true;
                    Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+"Updating Directional Information OK");
                }
                else                         //Do update
                {
                    Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+"Inserting New Directional Information");
                    newDirection = new CSDirection();
                    try
                    {
                        newDirection.Directionimageblob = direction.Directionimageblob;
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+ex.Message);
                        newDirection.Directionimageblob = null;
                    }
                    newDirection.Directionimagefile = direction.Directionimagefile;
                    newDirection.Directiontext = direction.Directiontext;
                    newDirection.Meetingroomname = direction.Meetingroomname;
                    newDirection.Directionalscreenname = direction.Directionalscreenname;
                    newDirection.Save();
                    functionResult = true;
                    Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+"Inserting New Directional Information OK");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+"Error during Directional Information insert/update:");
                Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+"Message: "+ex.Message);
                functionResult = false;
            }

            return functionResult;
        }
Exemple #2
0
 public Boolean RemoveCSDirection(CSDirection direction)
 {
     InitDB();
     try
     {
         direction.MarkAsDeleted();
         direction.Save();
         Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+"Direction deleted ok");
     }
     catch (Exception ex)
     {
         Console.WriteLine(DateTime.Now.ToShortTimeString()+"  "+"Error deleting direction");
         return false;
     }
     return true;
 }