public string create(childCreate use) { Guid childId = Guid.NewGuid(); try { SqlConnection con = new SqlConnection(data); SqlCommand cmd = new SqlCommand("INSERT INTO courseChild (childId, parentId, name, creator) VALUES (@childId, @parentId, @name, @creator)", con); cmd.Parameters.AddWithValue("@childId", childId); cmd.Parameters.AddWithValue("@parentId", use.parentId); cmd.Parameters.AddWithValue("@name", use.name); cmd.Parameters.AddWithValue("@creator", use.userId); con.Open(); cmd.ExecuteNonQuery(); con.Close(); createOptions(childId, use.userId); } catch (SqlException ex) { return(ex.ToString()); } catch (Exception ex) { return("ErrorChild : " + ex.ToString()); } return(childId.ToString()); }
public string createString(string parentId, string name, string user) { if (parentId.Length <= 0 || parentId == null) { return("parentNull"); } if (name.Length <= 0 || name == null) { return("nameNull"); } if (user.Length <= 0 || user == null) { return("userNull"); } string childId = "ErrorInChild"; try { childCreate creator = new childCreate(); creator.parentId = new Guid(parentId); creator.name = name; creator.userId = new Guid(user); childId = create(creator); } catch (Exception ex) { return("ErrorChildString : " + ex.ToString()); } return(childId); }