public static long add(Branch branch) { long id = 0; using (SqlConnection con = new SqlConnection(Database.connection_string)) { con.Open(); SqlCommand com = new SqlCommand("Branch", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@center_id", branch.center_id); com.Parameters.AddWithValue("@name", branch.name); com.Parameters.AddWithValue("@address", branch.address); com.Parameters.AddWithValue("@Action", "Insert"); SQL_Utility.Stored_Procedure(ref com); SqlDataReader rdr = com.ExecuteReader(); if (rdr.Read()) { id = Convert.ToInt64(rdr[0]); } PhoneNumber_crud.add(PhonesTableType.Branch, id, branch.phoneno, PhonesTypes.Mobile); } return(id); }
public static long add(Center center) { long id = 0; using (SqlConnection con = new SqlConnection(Database.connection_string)) { con.Open(); SqlCommand com = new SqlCommand("Center", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@name", center.name); com.Parameters.AddWithValue("@about", center.about); com.Parameters.AddWithValue("@about_ar", center.about_ar); com.Parameters.AddWithValue("@email", center.email); com.Parameters.AddWithValue("@website", center.website); com.Parameters.AddWithValue("@Action", "InsertPrimary"); SQL_Utility.Stored_Procedure(ref com); SqlDataReader rdr = com.ExecuteReader(); if (rdr.Read()) { id = Convert.ToInt64(rdr[0]); } PhoneNumber_crud.add(PhonesTableType.Center, id, center.phoneno, PhonesTypes.Mobile); } return(id); }