/// <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()));
}
