public ServiceResponse <Oneness> Save(Oneness _oneness, long IdUser)
{
ServiceResponse <Oneness> Response = new ServiceResponse <Oneness>();
try
{
using (Conn)
{
Conn.Open();
using (SqlCommand cmd = new SqlCommand("SP_IU_Oneness", Conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", System.Data.SqlDbType.BigInt, 64).Direction = System.Data.ParameterDirection.InputOutput;
cmd.Parameters["@Id"].Value = _oneness.Id;
cmd.Parameters.AddWithValue("@Name", _oneness.Name);
cmd.Parameters.AddWithValue("@Owner", _oneness.Owner);
cmd.Parameters.AddWithValue("@IdCompany", _oneness.IdCompany);
cmd.Parameters.AddWithValue("@IdUser", IdUser);
cmd.Parameters.AddWithValue("@Lat", _oneness.Lat);
cmd.Parameters.AddWithValue("@Lng", _oneness.Lng);
cmd.ExecuteNonQuery();
Response.ObjectResult = cmd.Parameters["@Id"].Value;
}
}
}
catch (Exception ex)
{
Response.Error = true;
Response.Message = ex.Message;
}
return(Response);
}
// PUT api/oneness/5
public long Put([FromBody] Oneness _Oneness, long idUser)
{
ServiceResponse <Oneness> Response = new ServiceResponse <Oneness>();
Response = _Repository.Update(_Oneness, idUser);
if (Response.Error)
{
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, Response.Message));
}
return((long)Response.ObjectResult);
}
public ServiceResponse <Oneness> Update(Oneness _oneness, long IdUser)
{
ServiceResponse <Oneness> Response = new ServiceResponse <Oneness>();
try
{
if (_oneness == null)
{
throw new Exception("El Objeto 'Unidad' esta vacio o error de formato");
}
if (IdUser == null || IdUser == 0)
{
throw new Exception("Id de Usuario Valido Es necesario");
}
if (_oneness.IdCompany == null || _oneness.IdCompany != 0)
{
throw new Exception("Id de Compañia Invalido o Vacio");
}
if (_oneness.Id == null || _oneness.Id == 0)
{
throw new Exception("Id incorrecto debe ser nulo o 0 para un nuevo registro");
}
if (string.IsNullOrWhiteSpace(_oneness.Name))
{
throw new Exception("El Nombre de la Unidad es Requerido");
}
Response = _repository.Save(_oneness, IdUser);
if (Response.Error)
{
throw new Exception(Response.Message);
}
}
catch (Exception ex)
{
Response.Error = true;
Response.Message = ex.Message;
}
return(Response);
}
