public ActionResult _AddPersonalAttribute(Model.AddPersonalAttributeModel pModel)
{
if (ModelState.IsValid)
{
AttributeTypeDTO attributesTypes = categorieProvider.getAttributeType(pModel.id_typePA).Result;
Regex r = new Regex(attributesTypes.reg_expr);
PersonalAttributeDTO personaAttributeDTO = new PersonalAttributeDTO();
if (attributesTypes.reg_expr == "" || r.Match(pModel.valuePA).Success)
{
personaAttributeDTO.name = pModel.attributePA;
personaAttributeDTO.value = pModel.valuePA;
personaAttributeDTO.type_id = pModel.id_typePA;
personaAttributeDTO.userLog = Request.Cookies["user_id"].Value;
personaAttributeDTO.createdBy = personaAttributeDTO.userLog;
personaAttributeDTO.categorie_id = pModel.categorie_idPA;
if (categorieProvider.postPersonalAttribute(personaAttributeDTO).Result)
{
return(_PersonalAttrList(pModel.categorie_idPA));
}
}
else
{
return(new HttpStatusCodeResult(404, "El campo valor es inválido"));
}
}
return(new HttpStatusCodeResult(404, "Error, no se puede agregar el atributo"));
}
public ActionResult _EditPersonalAttribute(Model.EditPersonalAttributeModel pModel)
{
if (ModelState.IsValid)
{
AttributeTypeDTO attributesType = categorieProvider.getAttributeType(pModel.id_type).Result;
Regex r = new Regex(attributesType.reg_expr);
PersonalAttributeDTO personalAttributeDTO = new PersonalAttributeDTO();
if (attributesType.reg_expr == "" || r.Match(pModel.value).Success)
{
personalAttributeDTO.name = pModel.attribute;
personalAttributeDTO.value = pModel.value;
personalAttributeDTO.type_id = pModel.id_type;
personalAttributeDTO.isEnabled = pModel.isEnabled == "on" ? "true" : "false";
personalAttributeDTO.userLog = Request.Cookies["user_id"].Value;
personalAttributeDTO.id_attribute = pModel.id_attribute;
if (categorieProvider.putPersonalAttribute(personalAttributeDTO).Result)
{
return(new HttpStatusCodeResult(200, "El atributo se ha editado con éxito"));
}
}
else
{
return(new HttpStatusCodeResult(404, "El campo valor es inválido"));
}
}
else
{
return(new HttpStatusCodeResult(404, "Error, debe completar todos los campos"));
}
return(new HttpStatusCodeResult(404, "Error, no se puede agregar el atributo"));
}
public static bool updatePersonalAttribute(PersonalAttributeDTO pGeneralAttributeDTO)
{
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString))
{
SqlCommand command = new SqlCommand("usp_update_personalAttribute", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@id_attribute", SqlDbType.Int);
command.Parameters["@id_attribute"].Value = pGeneralAttributeDTO.id_attribute;
command.Parameters.Add("@name", SqlDbType.NVarChar);
command.Parameters["@name"].Value = pGeneralAttributeDTO.name;
command.Parameters.Add("@type_id", SqlDbType.Int);
command.Parameters["@type_id"].Value = pGeneralAttributeDTO.type_id;
command.Parameters.Add("@value", SqlDbType.NVarChar);
command.Parameters["@value"].Value = pGeneralAttributeDTO.value;
command.Parameters.Add("@isEnabled", SqlDbType.Bit);
command.Parameters["@isEnabled"].Value = pGeneralAttributeDTO.isEnabled;
command.Parameters.Add("@userLog", SqlDbType.Int);
command.Parameters["@userLog"].Value = pGeneralAttributeDTO.userLog;
command.Connection.Open();
int result = command.ExecuteNonQuery();
if (result != 0)
{
return(true);
}
return(false);
};
}
public static PersonalAttributeDTO getPersonalAttribute(string id_attribute)
{
PersonalAttributeDTO personalAttributeDTO = new PersonalAttributeDTO();
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString))
{
SqlCommand command = new SqlCommand("usp_get_personalAttribute", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@id_attribute", SqlDbType.Int);
command.Parameters["@id_attribute"].Value = id_attribute;
command.Connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
personalAttributeDTO.id_attribute = rdr["id_attribute"].ToString();
personalAttributeDTO.categorie_id = rdr["categorie_id"].ToString();
personalAttributeDTO.name = rdr["name"].ToString();
personalAttributeDTO.type_id = rdr["type"].ToString();
personalAttributeDTO.value = rdr["value"].ToString();
personalAttributeDTO.isEnabled = rdr["isEnabled"].ToString();
personalAttributeDTO.createdBy = rdr["createdBy"].ToString();
personalAttributeDTO.createdDate = rdr["createdDate"].ToString();
}
};
return(personalAttributeDTO);
}
public IHttpActionResult putPersonalAtrribute(PersonalAttributeDTO pPersonaAttributeDTO)
{
if (!CategoriesData.updatePersonalAttribute(pPersonaAttributeDTO))
{
return(BadRequest());
}
return(Ok());
}
public ActionResult _DeletePersonalAttribute(string id_attribute)
{
PersonalAttributeDTO personalAttributeDTO = new PersonalAttributeDTO();
personalAttributeDTO.id_attribute = id_attribute;
personalAttributeDTO.userLog = Request.Cookies["user_id"].Value;;
if (categorieProvider.deletePersonalAttribute(personalAttributeDTO).Result)
{
return(new HttpStatusCodeResult(200));
}
return(new HttpStatusCodeResult(404, "Error, el atributo no se puede eliminar"));
}
public async Task <bool> deletePersonalAttribute(PersonalAttributeDTO pPersonalAttributeDTO)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(_BaseAddress);
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken());
HttpResponseMessage response = client.DeleteAsync("api/categories/personalAttr/?id_attribute=" + pPersonalAttributeDTO.id_attribute + "&userLog=" + pPersonalAttributeDTO.userLog).Result;
if (response.IsSuccessStatusCode)
{
return(true);
}
return(false);
}
}
public async Task <bool> putPersonalAttribute(PersonalAttributeDTO pPersonalAttributeDTO)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(_BaseAddress);
var userJson = new JavaScriptSerializer().Serialize(pPersonalAttributeDTO);
HttpContent contentPost = new StringContent(userJson, Encoding.UTF8, "application/json");
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken());
HttpResponseMessage response = client.PutAsync("api/categories/personalAttr", contentPost).Result;
if (response.IsSuccessStatusCode)
{
return(true);
}
return(false);
}
}
public async Task <PersonalAttributeDTO> getPersonalAttribute(string id_attribute)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(_BaseAddress);
PersonalAttributeDTO personalAttributeDTO = new PersonalAttributeDTO();
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken());
HttpResponseMessage response = client.GetAsync("api/categories/personalAttr/?id_attribute=" + id_attribute).Result;
if (response.IsSuccessStatusCode)
{
string result = await response.Content.ReadAsStringAsync();
JavaScriptSerializer serializer = new JavaScriptSerializer();
personalAttributeDTO = serializer.Deserialize <PersonalAttributeDTO>(result);
}
return(personalAttributeDTO);
}
}
public PersonalAttributeDTO getPersonalAttribute(string id_attribute)
{
PersonalAttributeDTO attribute = CategoriesData.getPersonalAttribute(id_attribute);
return(attribute);
}
