public BaseResponse Update_State_Reserve(EntityReserve reserve)
{
var returnEntity = new BaseResponse();
try
{
using (var db = GetSqlConnection())
{
const string sql = "udp_state_reserve";
var p = new DynamicParameters();
p.Add(name: "@id", value: reserve.id, dbType: DbType.Int32, direction: ParameterDirection.Input);
p.Add(name: "@stateReserve ", value: reserve.stateReserve, dbType: DbType.String, direction: ParameterDirection.Input);
db.Query <EntityReserveProduct>(sql, param: p, commandType: CommandType.StoredProcedure).FirstOrDefault();
returnEntity.isSuccess = true;
returnEntity.errorCode = "0000";
returnEntity.errorMessage = string.Empty;
returnEntity.data = null;
}
}
catch (Exception ex)
{
returnEntity.isSuccess = false;
returnEntity.errorCode = "0001";
returnEntity.errorMessage = ex.Message;
returnEntity.data = null;
}
return(returnEntity);
}
public BaseResponse Insert(EntityReserve reserve)
{
var returnEntity = new BaseResponse();
try
{
using (var db = GetSqlConnection())
{
/* const string sql = @"usp_InsertarProyecto";
*
* var p = new DynamicParameters();
* p.Add(name: "@IDPROYECTO", dbType: DbType.Int32, direction: ParameterDirection.Output);
* p.Add(name: "@NOMBRE", value: reserve.Nombre, dbType: DbType.String, direction: ParameterDirection.Input);
* p.Add(name: "@PRECIO", value: reserve.Precio, dbType: DbType.Decimal, direction: ParameterDirection.Input);
* p.Add(name: "@DIRECCION", value: reserve.Direccion, dbType: DbType.String, direction: ParameterDirection.Input);
* p.Add(name: "@UBICACION", value: reserve.Ubicacion, dbType: DbType.String, direction: ParameterDirection.Input);
* p.Add(name: "@USUARIOCREA", value: reserve.UsuarioCrea, dbType: DbType.Int32, direction: ParameterDirection.Input);
*
* db.Query<EntityReserve>(sql, param: p, commandType: CommandType.StoredProcedure).FirstOrDefault();
*
* int idReserve = p.Get<int>("@IDPROYECTO");
*
* if (idReserve > 0)
* {
* returnEntity.isSuccess = true;
* returnEntity.errorCode = "0000";
* returnEntity.errorMessage = string.Empty;
* returnEntity.data = new
* {
* id = idReserve,
* nombre = reserve.Nombre,
* precio = reserve.Precio
* };
* }
* else
* {
* returnEntity.isSuccess = false;
* returnEntity.errorCode = "0000";
* returnEntity.errorMessage = string.Empty;
* returnEntity.data = null;
* }
*/
}
}
catch (Exception ex)
{
returnEntity.isSuccess = false;
returnEntity.errorCode = "0001";
returnEntity.errorMessage = ex.Message;
returnEntity.data = null;
}
return(returnEntity);
}
public ActionResult Insert(EntityReserve reserve)
{
var identity = User.Identity as ClaimsIdentity;
IEnumerable <Claim> claims = identity.Claims;
var usuarioId = claims.Where(p => p.Type == "client_codigo_usuario").FirstOrDefault().Value;
var usuarioDoc = claims.Where(p => p.Type == "client_numero_documento").FirstOrDefault().Value;
reserve.UsuarioCrea = int.Parse(usuarioId);
var ret = _ReserveRepository.Insert(reserve);
if (ret == null)
{
return(StatusCode(401));
}
return(Json(ret));
}
public BaseResponse GetReserve(int id)
{
var returnEntity = new BaseResponse();
var entityReserve = new EntityReserve();
try
{
using (var db = GetSqlConnection())
{
const string sql = @"usp_ObtenerProyecto";
var p = new DynamicParameters();
p.Add(name: "@IDPROYECTO", value: id, dbType: DbType.Int32, direction: ParameterDirection.Input);
entityReserve = db.Query <EntityReserve>(sql, param: p, commandType: CommandType.StoredProcedure).FirstOrDefault();
if (entityReserve != null)
{
returnEntity.isSuccess = true;
returnEntity.errorCode = "0000";
returnEntity.errorMessage = string.Empty;
returnEntity.data = entityReserve;
}
else
{
returnEntity.isSuccess = false;
returnEntity.errorCode = "0000";
returnEntity.errorMessage = string.Empty;
returnEntity.data = null;
}
}
}
catch (Exception ex)
{
returnEntity.isSuccess = false;
returnEntity.errorCode = "0001";
returnEntity.errorMessage = ex.Message;
returnEntity.data = null;
}
return(returnEntity);
}
public ActionResult Update_State_Reserve(EntityReserve reserve)
{
var ret = _ReserveRepository.Update_State_Reserve(reserve);
return(Json(ret));
}