public static ResultData <int> Update(UserProfile user) { try { LogHelpers.LogHandler.Info("Id: " + user.Id); user.Password = Utilities.ToMD5Hash(user.Password.Trim()); user.DateOfBirth = Utilities.ParseToDate(user.DateOfBirthString); var stored = "sp_Users_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, user.GetParameters()); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); } return(result); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <int>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultBOL <int> InsertOrUpdate(ContactBOL contact) { string stored = "sp_Contacts_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, contact.GetParameters()); return(result); }
public static ResultBOL <int> InsertOrUpdate(MenuBOL obj) { string stored = "sp_Menu_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, obj.GetParameters()); return(result); }
public static ResultBOL <int> InsertOrUpdate(OtherTypeBOL BOL) { string stored = "sp_OtherType_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, BOL.GetParameters()); return(result); }
public static ResultBOL <string> UpdateIndex(OtherTypeUpdateIndexBOL[] list) { string stored = "sp_OtherType_Insert_Update"; ResultBOL <string> result = new ResultBOL <string>(); foreach (OtherTypeUpdateIndexBOL obj in list) { var updateResult = DataAccessHelpers.ExecuteStored(stored, obj.GetParameters()); if (updateResult.Code < 0) { if (string.IsNullOrEmpty(result.ErrorMessage)) { result.ErrorMessage = updateResult.ErrorMessage; } else { result.ErrorMessage += "\n" + updateResult.ErrorMessage; } } } if (!string.IsNullOrEmpty(result.ErrorMessage)) { result.Code = -1; } return(result); }
public static ResultData <int> InsertOrUpdate(News news) { LogHelpers.LogHandler.Info("Start"); try { if (news.Id > 0) { news.Content_EN = Utilities.ReplaceImageUri(news.Id, news.Content_EN, ConfigurationManager.AppSettings["UploadFilesDir"]); news.Content_VN = Utilities.ReplaceImageUri(news.Id, news.Content_VN, Utilities.UploadImagesDir()); } string stored = "sp_News_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, news.GetParameters()); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); } else if (news.Id <= 0) { news.Id = result.Code; return(UpdateContent(news)); } return(result); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <int>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultBOL <int> InsertOrUpdate(UserBOL user) { string stored = "sp_Users_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, user.GetParameters()); return(result); }
public static ResultBOL <int> InsertOrUpdate(MenuBOL obj) { //string type = GetType(obj.ParentId); //if (!string.IsNullOrEmpty(type)) //{ // switch (type) // { // case "DichVu": // return NewsDAL.InsertOrUpdate(new NewsBOL() { // Name_EN = obj.Name_EN, // Name_VN = obj.Name_VN, // ImageLink = obj.Image, // Type = type, // ParentId = obj.ParentId // }); // default: // break; // } //} string stored = "sp_Menu_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, obj.GetParameters()); return(result); }
public static ResultBOL <int> UpdatePriorityOrDisable(object obj) { string stored = "sp_News_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, obj); return(result); }
public static ResultData <int> InsertOrUpdate(Menu menu) { LogHelpers.LogHandler.Info("Start."); try { string stored = "sp_Menu_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, menu.GetParameters()); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); } return(result); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <int>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultBOL <int> UpdateSiteVisitors() { string stored = "sp_UpdateSiteVisitors"; var result = DataAccessHelpers.ExecuteStored(stored, null); return(result); }
public static ResultBOL <int> InsertOrUpdate(ProjectBOL BOL) { string imageDir = Utilities.GetDirectory("ImagesDir"); BOL.Content_VN = Utilities.ReplaceImageUri(BOL.Content_VN, imageDir); BOL.Content_EN = Utilities.ReplaceImageUri(BOL.Content_VN, imageDir); string stored = "sp_Peojects_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, BOL.GetParameters()); return(result); }
public static ResultBOL <int> InsertOrUpdate(GalleryBOL obj) { string stored = "sp_Galley_Insert_Update"; ResultBOL <int> result = DataAccessHelpers.ExecuteStored(stored, obj); if (result.Code < 0) { _log.Error(result.ErrorMessage); } else { obj.Id = result.Data; } return(result); }
public static ResultBOL <int> InsertOrUpdate(AboutBOL about) { if (about == null) { return(new ResultBOL <int>() { Code = -20, ErrorMessage = Utilities.GetErrorMessage("NullObject") }); } string stored = "sp_About_Insert_Update"; about.InsertDate = DateTime.Now; about.UpdatedDate = DateTime.Now; var result = DataAccessHelpers.ExecuteStored(stored, about.GetParameters()); return(result); }
private static ResultData <int> UpdateContent(News news) { if (news == null) { return(new ResultData <int>() { Code = -104, ErrorMessage = "Data not found" }); } LogHelpers.LogHandler.Info("NewsId: " + news.Id.ToString()); try { news.Content_EN = Utilities.ReplaceImageUri(news.Id, news.Content_EN, Utilities.UploadImagesDir()); news.Content_VN = Utilities.ReplaceImageUri(news.Id, news.Content_VN, Utilities.UploadImagesDir()); string stored = "sp_News_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, news.GetParameters()); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); } return(result); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <int>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }