/// <summary> /// /// </summary> /// <param name="idPosition"></param> /// <param name="positionName"></param> /// <param name="idSalary"></param> /// <returns></returns> public static bool UpdatePositionById(string idPosition, string positionName, string idSalary) { try { string[] position = new string[] { idPosition, positionName }; if (ValidateData.VerifyFields(position)) { PositionModel positionModel = new PositionModel() { IdSalary = int.Parse(idSalary), IdPosition = int.Parse(idPosition), PositionName = positionName }; return(DBPosition.UpdatePosition(positionModel)); } else { return(false); } } catch (Exception ex) { //Log4Net return(false); } }
/// <summary> /// /// </summary> /// <returns></returns> public static List <PositionModel> SelectAllPositions() { try { return(DBPosition.SelectPositionAll()); } catch (Exception ex) { //Log4Net return(null); } }
public Result Add(Request req) { /* * Request request = new Request * { * RequestIdent = "1231231", * Data = "werwerwe" * }; * * string str = JsonConvert.SerializeObject(request); * * string str2 = JsonConvert.DeserializeObject<string>(request.ToString()); */ return(DBPosition.Add(req.Data.ToString())); }
protected string GetConnectionString(DBPosition dbPosition, string defaultConnectionName = "ConnectionString") { string connectionName = string.Empty; if (dbPosition == DBPosition.Manual) { if (!string.IsNullOrEmpty(defaultConnectionName)) { connectionName = defaultConnectionName; } } else { connectionName = StringUtils.GetEnumDescription(dbPosition); } if (string.IsNullOrEmpty(connectionName)) { connectionName = "ConnectionString"; } return(AppSettings.Instance.GetConnection(connectionName)); }
/// <summary> /// /// </summary> /// <param name="idPosition"></param> /// <returns></returns> public static bool DeletePositionById(string idPosition) { try { string[] position = new string[] { idPosition }; if (ValidateData.VerifyFields(position)) { PositionModel positionModel = new PositionModel() { IdPosition = int.Parse(idPosition) }; return(DBPosition.DeletePosition(positionModel)); } else { return(false); } } catch (Exception ex) { //Log4Net return(false); } }
public Result GetAll(Request req) { return(DBPosition.GetAll()); }
protected IDbContext Context(DBPosition dbPosition, string manualConnection = "") { return(new DbContext().ConnectionString(GetConnectionString(dbPosition, manualConnection), new SqlServerProvider())); }