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 string create(parametercreate use)
{
Guid parameterId = Guid.NewGuid();
string response = parameterId.ToString();
SqlConnection con = new SqlConnection(data);
SqlCommand cmd = new SqlCommand("INSERT INTO courseParameter(childId, parameterId, type, creator) VALUES (@childId, @parameterId, @type, @creator)", con);
cmd.Parameters.AddWithValue("@childId", use.childId);
cmd.Parameters.AddWithValue("@parameterId", parameterId);
cmd.Parameters.AddWithValue("@type", use.type);
cmd.Parameters.AddWithValue("@creator", use.creator);
con.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
response = ex.ToString();
}
catch (Exception ex)
{
response = ex.ToString();
}
con.Close();
return(response);
}
public string createString(string type, string childId, string creator)
{
parametercreate para = new parametercreate();
string response = "";
try
{
para.type = type;
para.childId = new Guid(childId);
para.creator = new Guid(creator);
response = create(para);
}
catch (Exception ex)
{
response = "Error:" + ex.ToString();
}
return(response);
}
public string update(List <parameterClass> use)
{
string response = "";
if (use.Count() <= 0)
{
return("UpdateNull");
}
SqlConnection con = new SqlConnection(data);
SqlCommand cmd = new SqlCommand("UPDATE courseParameter SET parameterOrder = @order, value = @value WHERE childId = @childId AND parameterId = @parameterId", con);
con.Open();
for (int i = 0; i < use.Count(); i++)
{
if (use[i].parameterId == null)
{
// Do Stuff
parametercreate para = new parametercreate();
para.childId = use[i].childId;
para.creator = use[i].creator;
para.type = use[i].type;
use[i].parameterId = new Guid(create(para));
}
if (use[i].value == null || use[i].value.Length <= 0)
{
continue;
}
// Check if the status of the parameter is delete
// if the status is del or delete script will call delete function
// else it will just update
if (use[i].status.Contains("del") || use[i].status.Contains("Del"))
{
parameterDelete del = new parameterDelete();
del.creator = use[i].creator;
del.parameterId = use[i].parameterId;
response += delete(del) + " /n ";
}
else
{
try
{
cmd.Parameters.AddWithValue("@value", use[i].value);
cmd.Parameters.AddWithValue("@order", Convert.ToInt32(use[i].order));
cmd.Parameters.AddWithValue("@childId", use[i].childId);
cmd.Parameters.AddWithValue("@parameterId", use[i].parameterId);
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
response += ex.ToString() + " /n ";
}
catch (Exception ex)
{
response += ex.ToString() + " /n ";
}
}
}
con.Close();
return(response);
}
