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); }