public string update(parentUpdate parent)
{
string response = "";
try
{
SqlConnection con = new SqlConnection(data);
SqlCommand cmd = new SqlCommand("UPDATE courseParent SET name = @name WHERE parentId = @parentId AND courseId = @courseId", con);
cmd.Parameters.AddWithValue("@name", parent.name);
cmd.Parameters.AddWithValue("@parentId", parent.parentId);
cmd.Parameters.AddWithValue("@courseId", parent.courseId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
response = "Success";
}
catch (SqlException ex)
{
response = ex.ToString();
}
catch
{
}
return(response);
}
public string updateString(string parentId, string name, string user, string courseId)
{
string response = "Error";
try
{
if (parentId == null || parentId.Length <= 0)
{
return("parentId Null");
}
if (name == null || name.Length <= 0)
{
return("name Null");
}
if (user == null || user.Length <= 0)
{
return("userId Null");
}
if (courseId == null || courseId.Length <= 0)
{
return("courseId Null");
}
parentUpdate par = new parentUpdate();
par.parentId = new Guid(parentId);
par.name = name;
par.user = new Guid(user);
par.courseId = new Guid(courseId);
response = update(par);
}
catch
{
response = "Error";
}
return(response);
}
