public string updateString(string childId, string parameterId, string creator, string type, string value, string order, string status)
{
string response = "";
List <parameterClass> list = new List <parameterClass>();
try
{
if (parameterId == null || parameterId.Length <= 5)
{
// Do Stuff
parametercreate para = new parametercreate();
para.childId = new Guid(childId);
para.creator = new Guid(creator);
para.type = type;
parameterId = create(para);
}
parameterClass parameter = new parameterClass();
parameter.childId = new Guid(childId);
parameter.parameterId = new Guid(parameterId);
parameter.creator = new Guid(creator);
parameter.type = type;
parameter.value = value;
parameter.order = order;
list.Add(parameter);
response = update(list);
}
catch (Exception ex)
{
return(ex.ToString());
}
return(response);
}
public List <parameterClass> read(Guid childId)
{
List <parameterClass> response = new List <parameterClass>();
try
{
SqlConnection con = new SqlConnection(data);
SqlCommand cmd = new SqlCommand("SELECT * FROM courseParameter WHERE childId = @childId ORDER BY parameterOrder ASC", con);
cmd.Parameters.AddWithValue("@childId", childId);
SqlDataReader Dr;
con.Open();
Dr = cmd.ExecuteReader();
while (Dr.Read())
{
parameterClass parameter = new parameterClass();
parameter.creator = new Guid(Dr["creator"].ToString());
parameter.type = Dr["type"].ToString();
parameter.value = Dr["value"].ToString();
parameter.parameterId = new Guid(Dr["parameterId"].ToString());
parameter.childId = childId;
parameter.order = Dr["parameterOrder"].ToString();
parameter.status = Dr["status"].ToString();
parameter.additional_1 = Dr["additional_1"].ToString();
parameter.additional_2 = Dr["additional_2"].ToString();
parameter.additional_3 = Dr["additional_3"].ToString();
parameter.additional_4 = Dr["additional_4"].ToString();
response.Add(parameter);
}
con.Close();
}
catch (SqlException ex)
{
// Log error
parameterClass parameter = new parameterClass();
parameter.value = ex.ToString();
response.Add(parameter);
}
catch (Exception ex)
{
// Log error
parameterClass parameter = new parameterClass();
parameter.value = ex.ToString();
response.Add(parameter);
}
return(response);
}
public List <parameterClass> readString(string childId)
{
if (childId == null || childId.Length <= 0)
{
return(new List <parameterClass>());
}
try
{
List <parameterClass> response = read(new Guid(childId));
return(response);
}
catch (Exception ex)
{
List <parameterClass> response = read(new Guid(childId));
parameterClass parameter = new parameterClass();
parameter.value = ex.ToString();
response.Add(parameter);
return(response);
}
}