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