public int Save <T>(T entity) where T : Entity.Entity { int result; using (var session = Factory.OpenSession()) { using (var tran = session.BeginTransaction()) { try { session.Save(entity); tran.Commit(); result = entity.Id; } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения процедуры Save<" + typeof(T) + "> : " + ex.Message, MonitorLog.typelog.Error, true); tran.Rollback(); result = 0; } } } return(result); }
public static MailUserModel GetUser(HttpRequestBase request) { var model = new MailUserModel { IsAutharization = false }; try { var userCookie = request.Cookies["mail_token"]; if (userCookie != null) { var stream = HttpTools.PostStream(InfoUrl, string.Format("oauth_token={0}&client_id={1}&format=json&method=users.getInfo&sig={2}", userCookie.Value, SiteId, "")); model = SerializeTools.Deserialize <MailUserModel>(stream); model.IsAutharization = true; } } catch (Exception ex) { MonitorLog.WriteLog(ex.InnerException + ex.Message, MonitorLog.typelog.Error, true); model.IsAutharization = false; } return(model); }
public T Get <T>(int id) where T : Entity.Entity { using (var session = Factory.OpenSession()) { try { return(session.Get <T>(id)); } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения процедуры Get<" + typeof(T) + "> : " + ex.Message, MonitorLog.typelog.Error, true); throw; } } }
public T GetMessage <T>(int msgId) { T result; using (var session = Factory.OpenSession()) { try { result = session.Get <T>(msgId); } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения процедуры GetMessage : " + ex.Message, MonitorLog.typelog.Error, true); throw; } } return(result); }
public T SingleOrDefault <T>(Expression <Func <T, bool> > expression) where T : Entity.Entity { T result; using (var session = Factory.OpenSession()) { try { var query = session.QueryOver <T>().Where(expression).SingleOrDefault(); result = query; } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения процедуры SingleOrDefault<" + typeof(T) + "> : " + ex.Message, MonitorLog.typelog.Error, true); throw; } } return(result); }
private IEnumerable <string> GetFilesFrom(string searchFolder) { var directory = new DirectoryInfo(searchFolder); var files = new List <string>(); try { var filters = new[] { "jpg", "jpeg", "png", "gif", "tiff", "bmp", "svg" }; foreach (var filter in filters) { files.AddRange(directory.GetFiles($"*.{filter}", SearchOption.TopDirectoryOnly).Select(f => f.Name)); } return(files); } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения CarouselViewModel : " + ex.Message, MonitorLog.typelog.Error, true); return(new string[1]); } }
private ISessionFactory CreatePostgreSessionFactory(string connectionString) { try { var factory = Fluently.Configure() .Database(PostgreSQLConfiguration.PostgreSQL82 .ConnectionString(connectionString)) .ExposeConfiguration(c => c.Properties.Add("current_session_context_class", typeof(CallSessionContext).FullName)) .Mappings(x => x.FluentMappings.AddFromAssemblyOf <NewsMap>()) .BuildSessionFactory(); return(factory); } catch (Exception ex) { var msg = string.Format("{0} [InnerException]: {1}", ex.Message, ex.InnerException); MonitorLog.WriteLog(msg, MonitorLog.typelog.Error, true); throw new Exception(); } }
private ISessionFactory CreateSqLiteSessionFactory(string connectionString) { try { var str = string.Format("Data Source={0}{1};Version=3;", AppDomain.CurrentDomain.BaseDirectory.Replace("\\", "/"), connectionString); var factory = Fluently.Configure() .Database(SQLiteConfiguration.Standard.ConnectionString(str)) .ExposeConfiguration(c => c.Properties.Add("current_session_context_class", typeof(CallSessionContext).FullName)) .Mappings(x => x.FluentMappings.AddFromAssemblyOf <NewsMap>()) .BuildSessionFactory(); return(factory); } catch (Exception ex) { var msg = string.Format("{0} [InnerException]: {1}", ex.Message, ex.InnerException); MonitorLog.WriteLog(msg, MonitorLog.typelog.Error, true); return(null); } }
public List <T> Where <T>(Expression <Func <T, bool> > expression) where T : Entity.Entity { List <T> result; using (var session = Factory.OpenSession()) { try { var query = session.QueryOver <T>().Where(expression); result = (List <T>)query .OrderBy(p => p.Id).Asc .List <T>(); } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения процедуры Where<" + typeof(T) + "> : " + ex.Message, MonitorLog.typelog.Error, true); throw; } } return(result); }
public void SaveList <T>(List <T> list) where T : Entity.Entity { using (var session = Factory.OpenSession()) { using (var tran = session.BeginTransaction()) { try { foreach (var entity in list) { session.SaveOrUpdate(entity); } tran.Commit(); } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения процедуры SaveList<" + typeof(T) + "> : " + ex.Message, MonitorLog.typelog.Error, true); tran.Rollback(); } } } }
/// <summary> /// Создание карусели из папки с фото /// </summary> /// <param name="folder">Папка с фото</param> /// <param name="path">Путь</param> /// <param name="header">Заголовок карусели</param> /// <param name="interval">Интервал листания</param> public CarouselViewModel(string folder, string path, string header, string interval = "5000") { var directory = new DirectoryInfo(path); IEnumerable <string> files; try { files = directory.GetFiles().Select(f => f.Name); } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения CarouselViewModel : " + ex.Message, MonitorLog.typelog.Error, true); files = new string[1]; } Header = header; Files = files.Select(f => new NodeViewModel { Path = folder + f, Description = "" }); Folder = folder; Interval = interval; CarouselId = Guid.NewGuid().ToString(); }
public static YandexUserModel GetUser(HttpRequestBase request) { var model = new YandexUserModel { IsAutharization = false }; try { var userCookie = request.Cookies["yandex_token"]; if (userCookie != null) { var stream = HttpTools.PostStream(InfoUrl, string.Format("oauth_token={0}", userCookie.Value)); model = SerializeTools.Deserialize <YandexUserModel>(stream); model.IsAutharization = true; } } catch (Exception ex) { MonitorLog.WriteLog(ex.InnerException + ex.Message, MonitorLog.typelog.Error, true); model.IsAutharization = false; } return(model); }
/// <summary> /// Получить ИД предыдущего сообщения /// </summary> /// <typeparam name="T">Тип сообщения</typeparam> /// <param name="messageId">ИД сообщения</param> /// <returns></returns> public int GetPrevMessageId <T>(int messageId) where T : Entity.Entity { List <int> result; using (var session = Factory.OpenSession()) { try { result = (List <int>)session.QueryOver <T>() .Where(p => p.Id < messageId) .Select(p => p.Id) .OrderBy(p => p.Id).Desc .Take(1) .List <int>(); } catch (Exception ex) { MonitorLog.WriteLog("Ошибка выполнения процедуры GetPrevMessageId : " + ex.Message, MonitorLog.typelog.Error, true); throw; } } return(!result.Any() ? 0 : result.First()); }