public static List <Management_statusDTO> GetManagement_statusList()
        {
            List <Management_statusDTO> userList = new List <Management_statusDTO>();

            using (SuperGmachEntities db = new SuperGmachEntities())
            {
                foreach (Management_status status in db.ManagementStatuses)
                {
                    userList.Add(Mangagment_status_convert.DALtoDTO(status));
                }
            }
            return(userList);
        }
 public static Management_statusDTO GetByName(string nameStatuse)
 {
     SuperGmachEntities db = new SuperGmachEntities();
     {
         foreach (Management_status status in db.ManagementStatuses)
         {
             if (status.NameManagement_status == nameStatuse)
             {
                 return(Mangagment_status_convert.DALtoDTO(status));
             }
         }
         return(null);
     }
 }
        public static string AddStatus(Management_statusDTO status)
        {
            using (SuperGmachEntities db = new SuperGmachEntities())
            {
                try
                {
                    Management_status s = Mangagment_status_convert.DTOtoDAL(status);
                    Console.WriteLine(s.NameManagement_status + " " + s.Color);
                    db.ManagementStatuses.Add(s);

                    db.SaveChanges();
                }
                catch (Exception e)
                {
                    Console.WriteLine("err on add status: " + e.ToString());
                    return("err on add status: " + e.ToString());
                }
                return("status add Successfully");
            }
        }