// Login

var userData = DB.GetUser(loginData);
                if (userData.Id > 0)
                {
                    Session[SessionNames.User] = userData;
                    return RedirectToAction("index", "Dashboard");
                }
                else
                {
                    loginData.ErrorMessage = "That account doesn't exist";
                    return View(loginData);
                }




//Core
//نص الاتصال بمخدم قواعد البيانات
  readonly static string connectionStrin = "Data Source = 198.71.226.11;Initial Catalog=projectsdb;User id=muhzain;Password=!@#;";

        //SQLتنفيذ جمل ال
        // وجلب الناتج على شكل جدول
        public static DataTable GetData(string sqlStatement)
        {
            return DataBase.GetData(sqlStatement, connectionStrin);
        }
   public static User GetUser(UserLogin user)
        {

            var result = new User();
            var queryStatement =
                string.Format(@"select id,[user_name],[password],first_name,last_name,email,notes,role,ceo,company_id from users
								where [USER_NAME] like '{0}' and [password] like '{1}'", user.UserName, Cryptography.generateMD5(user.Password));

            DataTable tbResult = GetData(queryStatement);
            if (tbResult.Rows.Count == 1)
            {
                DataRow dataResult = tbResult.Rows[0];
                result.Id = dataResult["id"].ToString().ToInt();
                result.UserName = dataResult["user_name"].ToString();
                result.FirstName = dataResult["first_name"].ToString();
                result.LastName = dataResult["last_name"].ToString();
                result.Email = dataResult["email"].ToString();
                result.Notes = dataResult["email"].ToString();
                result.Role = (UserRole)dataResult["role"].ToString().ToInt();
                result.CEO = Convert.ToBoolean(dataResult["ceo"].ToString());
                result.CompanyId = dataResult["company_id"].ToString().ToInt();
            }

            return result;
        }