public static ResultData <int> DeleteAll(string listId) { LogHelpers.LogHandler.Info("Start"); try { string stored = "sp_News_Delete"; object obj = new { ListId = listId.Trim() }; var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); } return(new ResultData <int>() { Code = result.Code, ErrorMessage = result.ErrorMessage }); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <int>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultBOL <DataSet> GetAllFromParent(int projectId) { string stored = "sp_Projects_GetAll_In_Menu"; object obj = new { Id = projectId }; var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); return(result); }
public static ResultBOL <DataSet> Login(string username, string password) { string stored = "sp_Users_Login"; Object obj = new { Username = username, Password = Utilities.EncryptPassword(password) }; var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); return(result); }
public static ResultData <List <News> > GetAll(int menuId) { LogHelpers.LogHandler.Info("Start"); try { string stored = "sp_News_GetAll"; object obj = new { MenuId = menuId }; var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); return(new ResultData <List <News> >() { Code = result.Code, ErrorMessage = result.ErrorMessage }); } ResultData <List <News> > rs = new ResultData <List <News> >() { Code = 0, Data = new List <News>() }; if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0) { return(rs); } foreach (DataRow row in result.Data.Tables[0].Rows) { News news = new News(row); news.Content_VN = Utilities.CreateImagesUrl(news.Id, news.Content_VN, ConfigurationManager.AppSettings["UploadImagesUrl"]); news.Content_EN = Utilities.CreateImagesUrl(news.Id, news.Content_EN, ConfigurationManager.AppSettings["UploadImagesUrl"]); rs.Data.Add(news); } return(rs); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <List <News> >() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultData <UserProfile> Login(string username, string passowrd) { try { LogHelpers.LogHandler.Info(string.Format("username: {0}, password: {1}", username, passowrd)); var stored = "sp_Users_Login"; object obj = new { Username = username.Trim(), Password = Utilities.ToMD5Hash(passowrd.Trim()) }; var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); if (result.Code < 0) { return(new ResultData <UserProfile>() { Code = result.Code, ErrorMessage = result.ErrorMessage }); } if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0) { return(new ResultData <UserProfile>() { Code = -104, ErrorMessage = "Wrong username or password" }); } UserProfile user = new UserProfile(result.Data.Tables[0].Rows[0]); HttpContext.Current.Session["LoggedUser"] = user; return(new ResultData <UserProfile>() { Code = 0, Data = user }); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <UserProfile>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultBOL <DataSet> GetPageItems(int menuId, DateTime scanTime, string type) { string tag = "[ProjectsDAL][GetPageItems]"; if (scanTime == null) { return(new ResultBOL <DataSet> { Code = -1, ErrorMessage = Utilities.GetErrorMessage("NullObject") }); } try { int itemsCount; if (type == "Home") { itemsCount = int.Parse(Utilities.GetApplicationSettingsValue("HomeProject-Items")); } else { itemsCount = int.Parse(Utilities.GetApplicationSettingsValue("Project-Items")); } object obj = new { MenuId = menuId, ScanTime = scanTime, ItemsCount = itemsCount }; string stored = "sp_Projects_GetAll_PageItems"; var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); return(result); } catch (Exception ex) { LogHelpers.WriteException(tag, ex.ToString()); //-- return(new ResultBOL <DataSet>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultData <UserProfile> Get(int userId) { try { LogHelpers.LogHandler.Info("userId: " + userId); string stored = "sp_Users_Get"; object obj = new { Id = userId }; var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); return(new ResultData <UserProfile>() { Code = result.Code, ErrorMessage = result.ErrorMessage }); } if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0) { return(new ResultData <UserProfile>() { Code = -104, ErrorMessage = "Not found" }); } return(new ResultData <UserProfile>() { Code = 0, Data = new UserProfile(result.Data.Tables[0].Rows[0]) }); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <UserProfile>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultData <SiteSetting> Get(int id, string type) { try { LogHelpers.LogHandler.Info(string.Format("id: {0}, type: {1}", id, type)); string stored = "sp_Settings_Get"; object obj = new { Id = id, Type = type }; var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); return(new ResultData <SiteSetting>() { Code = result.Code, ErrorMessage = result.ErrorMessage }); } ResultData <SiteSetting> rs = new ResultData <SiteSetting>(); if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0) { rs.Data = new SiteSetting(); } else { rs.Data = new SiteSetting(result.Data.Tables[0].Rows[0]); } return(rs); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <SiteSetting>() { Code = ex.HResult, ErrorMessage = ex.Message, Data = new SiteSetting() }); } }
public static ResultBOL <DataSet> DeleteAll(string listId) { string stored = "sp_Projects_Delete"; Object obj = new { Id = listId }; if (listId.Contains(",")) { obj = new { listId = listId }; stored = "sp_Projects_Multiple_Delete"; } var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); return(result); }
public static ResultBOL <DataSet> DeleteAll(string listId) { string stored = "sp_Menu_Delete"; object obj = new { Id = listId }; if (listId.Contains(",")) { stored = "sp_Menu_Multiple_Delete"; obj = new { ListId = listId }; } var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); if (result.Code == -1) { result.ErrorMessage = Utilities.GetErrorMessage("TableUsed"); } return(result); }