public Employee GetByLoginname(string loginname, PcsEmployeeSO search) { Employee result = null; try { bool valid = true; valid = valid && IsNotNullOrEmpty(loginname); if (valid) { using (var ctx = new Base.AppContext()) { var query = ctx.Employees.AsQueryable().Where(p => p.Loginname == loginname); if (search.listEmployeeExpression != null && search.listEmployeeExpression.Count > 0) { foreach (var item in search.listEmployeeExpression) { query = query.Where(item); } } result = query.SingleOrDefault(); } } } catch (Exception ex) { Logging(LogUtil.TraceData("loginname", loginname) + LogUtil.TraceData("search", search), LogType.Error); LogSystem.Error(ex); result = null; } return(result); }
public Project GetById(long id, PcsProjectSO search) { Project result = null; try { bool valid = true; valid = valid && IsGreaterThanZero(id); if (valid) { using (var ctx = new Base.AppContext()) { var query = ctx.Projects.AsQueryable().Where(p => p.Id == id); if (search.listProjectExpression != null && search.listProjectExpression.Count > 0) { foreach (var item in search.listProjectExpression) { query = query.Where(item); } } result = query.SingleOrDefault(); } } } catch (Exception ex) { Logging(LogUtil.TraceData("id", id) + LogUtil.TraceData("search", search), LogType.Error); LogSystem.Error(ex); result = null; } return(result); }
public Project GetByCode(string code, PcsProjectSO search) { Project result = null; try { bool valid = true; valid = valid && IsNotNullOrEmpty(code); if (valid) { using (var ctx = new Base.AppContext()) { var query = ctx.Projects.AsQueryable().Where(p => p.ProjectCode == code); if (search.listProjectExpression != null && search.listProjectExpression.Count > 0) { foreach (var item in search.listProjectExpression) { query = query.Where(item); } } result = query.SingleOrDefault(); } } } catch (Exception ex) { Logging(LogUtil.TraceData("code", code) + LogUtil.TraceData("search", search), LogType.Error); LogSystem.Error(ex); result = null; } return(result); }
public List <Project> Get(PcsProjectSO search, CommonParam param) { List <Project> list = new List <Project>(); try { bool valid = true; valid = valid && IsNotNull(param); if (valid) { using (var ctx = new Base.AppContext()) { var query = ctx.Projects.AsQueryable(); if (search.listProjectExpression != null && search.listProjectExpression.Count > 0) { foreach (var item in search.listProjectExpression) { query = query.Where(item); } } if (!string.IsNullOrWhiteSpace(search.OrderField) && !string.IsNullOrWhiteSpace(search.OrderDirection)) { if (!param.Start.HasValue || !param.Limit.HasValue) { list = query.OrderByProperty(search.OrderField, search.OrderDirection).ToList(); } else { param.Count = (from r in query select r).Count(); query = query.OrderByProperty(search.OrderField, search.OrderDirection); if (param.Count <= param.Limit.Value && param.Start.Value == 0) { list = query.ToList(); } else { list = query.Skip(param.Start.Value).Take(param.Limit.Value).ToList(); } } } else { list = query.ToList(); } } } } catch (Exception ex) { Logging(LogUtil.TraceData("search", search) + LogUtil.TraceData("param", param), LogType.Error); LogSystem.Error(ex); list.Clear(); } return(list); }
public bool ExistsCode(string code, long?id) { bool result = false; try { code = (code == null ? "" : code); id = id.HasValue ? id.Value : -1; long count = 0; using (var ctx = new Base.AppContext()) { count = ctx.Roles.AsQueryable().Where(p => p.RoleCode.Equals(code) && p.Id != id).Count(); } result = (count > 0); } catch (Exception) { Logging(LogUtil.TraceData("code", code) + LogUtil.TraceData("id", id), LogType.Error); throw; } return(result); }
public List <RAW> GetSql <RAW>(string sql, params object[] parameters) { List <RAW> result = null; try { if (!String.IsNullOrEmpty(sql)) { using (var ctx = new Base.AppContext()) { result = ctx.Database.SqlQuery <RAW>(sql, parameters).ToList(); } } } catch (Exception ex) { LogSystem.Error(ex); LogSystem.Error("sql: " + sql + LogUtil.TraceData("parameters:", parameters)); result = null; } return(result); }
public bool Execute(List <string> sqls) { bool result = false; string sql = ""; try { if (sqls != null && sqls.Count > 0) { StringBuilder sqlBuilder = new StringBuilder(); foreach (string s in sqls) { if (!string.IsNullOrWhiteSpace(s)) { sqlBuilder.Append(string.Format("{0};", s)); } } string tmp = sqlBuilder.ToString(); if (!string.IsNullOrWhiteSpace(tmp)) { sql = string.Format("BEGIN {0} END;", tmp); using (var ctx = new Base.AppContext()) { ctx.Database.ExecuteSqlCommand(sql); result = true; } } } } catch (Exception ex) { LogSystem.Error(ex); LogSystem.Error("sql: " + sql); result = false; } return(result); }
public RAW GetSqlSingle <RAW>(string sql, params object[] parameters) { RAW result = default(RAW); try { if (!String.IsNullOrEmpty(sql)) { using (var ctx = new Base.AppContext()) { result = ctx.Database.SqlQuery <RAW>(sql, parameters).FirstOrDefault(); } } } catch (Exception ex) { LogSystem.Error("sql: " + sql + LogUtil.TraceData("parameters:", parameters)); LogSystem.Error(ex); result = default(RAW); } return(result); }
public bool Execute(string sql, params object[] parameters) { bool result = false; try { if (!String.IsNullOrEmpty(sql)) { using (var ctx = new Base.AppContext()) { ctx.Database.ExecuteSqlCommand(sql, parameters); result = true; } } } catch (Exception ex) { LogSystem.Error(ex); LogSystem.Error("sql: " + sql + LogUtil.TraceData("parameters:", parameters)); result = false; } return(result); }