public List <clsAssessmentModel> GetDetailsByAssessmentId(int assessmentId)
{
List <clsAssessmentModel> result = new List <clsAssessmentModel>();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetAssessementDetailsByAssessmentId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@assess", assessmentId));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow item in dataTable.Rows)
{
clsAssessmentModel data = new clsAssessmentModel()
{
AssessmentDetailsId = Convert.ToInt32(item[0]),
AssessementId = Convert.ToInt32(item[1]),
};
ProcessJointPartType(data, item);
result.Add(data);
}
}
return(result);
}
private void ProcessJointPartType(clsAssessmentModel data, DataRow item)
{
switch (Convert.ToInt32(item[2]))
{
case (int)JointPartType.UpperJoint:
data.UpperJoint = new clsUpperJointModel
{
JointPartType = JointPartType.UpperJoint
};
ProcessJointType(data, item);
break;
case (int)JointPartType.LowerJoint:
data.LowerJoint = new clsLowerJointModel
{
JointPartType = JointPartType.LowerJoint
};
ProcessJointType(data, item);
break;
case (int)JointPartType.OtherAssessment:
data.OtherAssessment = new clsOtherAssessmentModel
{
JointPartType = JointPartType.OtherAssessment,
OtherAssessment = item[7].ToString()
};
break;
default:
break;
}
}
private void SaveAssessmentDetails(int assessmentId, clsAssessmentModel item)
{
SaveUpperJoint(assessmentId, item.UpperJoint);
SaveLowerJoint(assessmentId, item.LowerJoint);
SaveOtherAssessment(assessmentId, item.OtherAssessment);
}
private void ProcessJointType(clsAssessmentModel data, DataRow item)
{
switch (Convert.ToInt32(item[3]))
{
case (int)JointType.Shoulder:
data.UpperJoint.Shoulder = new clsShoulderModel()
{
JointType = JointType.Shoulder,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.ElbowForarm:
data.UpperJoint.ElbowAndForemarm = new clsElbowAndForemarmModel()
{
JointType = JointType.ElbowForarm,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.Wrist:
data.UpperJoint.Wrist = new clsWristModel()
{
JointType = JointType.Wrist,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.Thumb:
data.UpperJoint.Thumb = new clsThumbModel()
{
JointType = JointType.Thumb,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.IndexFinger:
data.UpperJoint.IndexFinger = new clsIndexFingerModel()
{
JointType = JointType.IndexFinger,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.MiddleFinger:
data.UpperJoint.MiddleFinger = new clsMiddleFingerModel()
{
JointType = JointType.MiddleFinger,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.RingFinger:
data.UpperJoint.RingFinger = new clsRingFingerModel()
{
JointType = JointType.RingFinger,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.LittleFinger:
data.UpperJoint.LittleFinger = new clsLittleFingerModel()
{
JointType = JointType.LittleFinger,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.Hip:
data.LowerJoint.Hip = new clsHipModel()
{
JointType = JointType.Hip,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.Knee:
data.LowerJoint.Knee = new clsKneeModel()
{
JointType = JointType.Knee,
MotionValue = ProcessMotionType(item)
};
break;
case (int)JointType.Ankle:
data.LowerJoint.Ankle = new clsAnkleModel()
{
JointType = JointType.Ankle,
MotionValue = ProcessMotionType(item)
};
break;
default:
break;
}
}
