public bool merge(DisabilityDTO entity)
{
try
{
var addObj = (from p in ctx.Disabilities
where p.userName == @entity.userName && p.disabilityType == @entity.disabilityType
select p).Single();
model.Disability obj = (Disability)addObj;
/*Update*/
obj.userName = entity.userName;
obj.disabilityType = entity.disabilityType;
obj.description = entity.description;
ctx.SubmitChanges();
return true;
}
catch (Exception e)
{
model.Log log = new Log();
log.message = "Disability Merge: " + " ["+entity.userName+" , "+entity.disabilityType+"] " + e.Message;
ctx.SubmitChanges();
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public DisabilityDTO getDisabilityDto()
{
DisabilityDTO disabilityDto = new DisabilityDTO();
disabilityDto.description = view.getDescription();
disabilityDto.disabilityType = view.getDisabilityType();
disabilityDto.userName = view.getUsername();
return disabilityDto;
}
public DisabilityDTO find(string userName, string disabilityType)
{
var obj = (from p in ctx.Disabilities
where p.userName == @userName && p.disabilityType == @disabilityType
select p).Single();
DisabilityDTO add = new DisabilityDTO();
add.userName = obj.userName;
add.disabilityType = obj.disabilityType;
add.description = obj.description;
return add;
}
public static DisabilityEN Convert(DisabilityDTO dto)
{
DisabilityEN newinstance = null;
try
{
if (dto != null)
{
newinstance = new DisabilityEN();
if (dto.Patient_oid != -1)
{
MoSIoTGenNHibernate.CAD.MosIoT.IPatientProfileCAD patientProfileCAD = new MoSIoTGenNHibernate.CAD.MosIoT.PatientProfileCAD();
newinstance.Patient = patientProfileCAD.ReadOIDDefault(dto.Patient_oid);
}
newinstance.Id = dto.Id;
newinstance.Name = dto.Name;
newinstance.Type = dto.Type;
newinstance.Severity = dto.Severity;
if (dto.Origin_oid != -1)
{
MoSIoTGenNHibernate.CAD.MosIoT.IConditionCAD conditionCAD = new MoSIoTGenNHibernate.CAD.MosIoT.ConditionCAD();
newinstance.Origin = conditionCAD.ReadOIDDefault(dto.Origin_oid);
}
if (dto.AccessMode_oid != null)
{
MoSIoTGenNHibernate.CAD.MosIoT.IAccessModeCAD accessModeCAD = new MoSIoTGenNHibernate.CAD.MosIoT.AccessModeCAD();
newinstance.AccessMode = new System.Collections.Generic.List <MoSIoTGenNHibernate.EN.MosIoT.AccessModeEN>();
foreach (int entry in dto.AccessMode_oid)
{
newinstance.AccessMode.Add(accessModeCAD.ReadOIDDefault(entry));
}
}
newinstance.Description = dto.Description;
}
}
catch (Exception ex)
{
throw ex;
}
return(newinstance);
}
public DisabilityDTO find(string userName, string disabilityType)
{
DisabilityDTO info = new DisabilityDTO();
SqlConnection oConn = new SqlConnection();
SqlCommand sqlCmd = null;
try
{
oConn.ConnectionString = ConfigurationManager.AppSettings["conn"];
oConn.Open();
sqlCmd = oConn.CreateCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "select * from Disability where userName = '******' AND disabilityType = '" + disabilityType + "'";
SqlDataReader rdr = sqlCmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
info.userName = rdr["userName"].ToString();
info.disabilityType = rdr["disabilityType"].ToString();
info.description = rdr["description"].ToString();
}
}
}
catch
{ }
finally
{
if (sqlCmd != null)
{
sqlCmd = null;
}
if (oConn != null)
{
if (oConn.State.Equals(ConnectionState.Open))
{
oConn.Close();
}
oConn = null;
}
}
return info;
}
public List<DisabilityDTO> findAll()
{
var objs = (from p in ctx.Disabilities
select p);
DisabilityDTO add = null;
List<DisabilityDTO> addList = new List<DisabilityDTO>();
foreach (Disability obj in objs)
{
add = new DisabilityDTO();
add.userName = obj.userName;
add.disabilityType = obj.disabilityType;
add.description = obj.description;
addList.Add(add);
}
return addList;
}
public void Disability_Test()
{
/*Context*/
DisabilityDAO disability_context = new DisabilityDAO();
AccountDAO account_context = new AccountDAO();
/*Insert*/
AccountDTO account = new AccountDTO();
account.userName = "******";
account.status = "active";
account.password = "******";
account.accountType = "admin";
account_context.presist(account);
DisabilityDTO disability = new DisabilityDTO();
disability.disabilityType = "hearing";
disability.description = "loss of hearing";
disability.userName = "******";
disability_context.presist(disability);
bool expected = true;
bool actual;
actual = disability_context.isFound("griddy", "hearing");
Assert.AreEqual(expected, actual);
/*Update*/
disability.description = "no hearing";
disability_context.merge(disability);
string expectedUpdate = "no hearing";
DisabilityDTO contUpd = disability_context.find("griddy", "hearing");
Assert.AreEqual(expectedUpdate, contUpd.description);
/*Delete*/
disability_context.removeByUserId("griddy", "hearing");
bool expectedDelete = false;
bool actualDelete = disability_context.isFound("griddy", "hearing");
Assert.AreEqual(expectedDelete, actualDelete);
account_context.removeByUserId("griddy");
}
public void setDisabilityDto(DisabilityDTO disabilityDto)
{
view.setDescription(disabilityDto.description);
view.setDisabilityType(disabilityDto.disabilityType);
view.setUsername(disabilityDto.userName);
}
public HttpResponseMessage Modify(int idDisability, [FromBody] DisabilityDTO dto)
{
// CAD, CEN, returnValue
DisabilityRESTCAD disabilityRESTCAD = null;
DisabilityCEN disabilityCEN = null;
DisabilityDTOA returnValue = null;
// HTTP response
HttpResponseMessage response = null;
string uri = null;
try
{
SessionInitializeTransaction();
disabilityRESTCAD = new DisabilityRESTCAD(session);
disabilityCEN = new DisabilityCEN(disabilityRESTCAD);
// Modify
disabilityCEN.Modify(idDisability,
dto.Name
,
dto.Type
,
dto.Severity
,
dto.Description
);
// Return modified object
returnValue = DisabilityAssembler.Convert(disabilityRESTCAD.ReadOIDDefault(idDisability), session);
SessionCommit();
}
catch (Exception e)
{
SessionRollBack();
if (e.GetType() == typeof(HttpResponseException))
{
throw e;
}
else if (e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.ModelException) && e.Message.Equals("El token es incorrecto"))
{
throw new HttpResponseException(HttpStatusCode.Forbidden);
}
else if (e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.ModelException) || e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.DataLayerException))
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
else
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
finally
{
SessionClose();
}
// Return 404 - Not found
if (returnValue == null)
{
return(this.Request.CreateResponse(HttpStatusCode.NotFound));
}
// Return 200 - OK
else
{
response = this.Request.CreateResponse(HttpStatusCode.OK, returnValue);
return(response);
}
}
public HttpResponseMessage New_([FromBody] DisabilityDTO dto)
{
// CAD, CEN, returnValue, returnOID
DisabilityRESTCAD disabilityRESTCAD = null;
DisabilityCEN disabilityCEN = null;
DisabilityDTOA returnValue = null;
int returnOID = -1;
// HTTP response
HttpResponseMessage response = null;
string uri = null;
try
{
SessionInitializeTransaction();
disabilityRESTCAD = new DisabilityRESTCAD(session);
disabilityCEN = new DisabilityCEN(disabilityRESTCAD);
// Create
returnOID = disabilityCEN.New_(
//Atributo OID: p_patient
// attr.estaRelacionado: true
dto.Patient_oid // association role
, dto.Name //Atributo Primitivo: p_name
, dto.Type //Atributo Primitivo: p_type
, dto.Severity //Atributo Primitivo: p_severity
, dto.Description //Atributo Primitivo: p_description
);
SessionCommit();
// Convert return
returnValue = DisabilityAssembler.Convert(disabilityRESTCAD.ReadOIDDefault(returnOID), session);
}
catch (Exception e)
{
SessionRollBack();
if (e.GetType() == typeof(HttpResponseException))
{
throw e;
}
else if (e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.ModelException) && e.Message.Equals("El token es incorrecto"))
{
throw new HttpResponseException(HttpStatusCode.Forbidden);
}
else if (e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.ModelException) || e.GetType() == typeof(MoSIoTGenNHibernate.Exceptions.DataLayerException))
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
else
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
finally
{
SessionClose();
}
// Return 201 - Created
response = this.Request.CreateResponse(HttpStatusCode.Created, returnValue);
// Location Header
/*
* Dictionary<string, object> routeValues = new Dictionary<string, object>();
*
* // TODO: y rolPaths
* routeValues.Add("id", returnOID);
*
* uri = Url.Link("GetOIDDisability", routeValues);
* response.Headers.Location = new Uri(uri);
*/
return(response);
}
public bool remove(DisabilityDTO entity)
{
return this.removeByUserId(entity.userName, entity.disabilityType);
}
public bool presist(DisabilityDTO entity)
{
bool success = false;
SqlConnection oConn = new SqlConnection();
SqlCommand sqlCmd = null;
try
{
oConn.ConnectionString = ConfigurationManager.AppSettings["conn"];
oConn.Open();
sqlCmd = oConn.CreateCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "insertDisability";
sqlCmd.Parameters.Add(new SqlParameter("userName", entity.userName));
sqlCmd.Parameters.Add(new SqlParameter("disabilityType", entity.disabilityType));
sqlCmd.Parameters.Add(new SqlParameter("description", entity.description));
SqlDataReader rdr = sqlCmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{ } //Read all
}
rdr.Close();
if (rdr.RecordsAffected > 0)
success = true;
}
catch { }
finally
{
if (sqlCmd != null)
{
sqlCmd = null;
}
if (oConn != null)
{
if (oConn.State.Equals(ConnectionState.Open))
{
oConn.Close();
}
oConn = null;
}
}
return success;
}
public bool presist(DisabilityDTO entity)
{
try
{
model.Disability obj = new Disability();
obj.userName = entity.userName;
obj.disabilityType = entity.disabilityType;
obj.description = entity.description;
ctx.Disabilities.InsertOnSubmit(obj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
