public static int InsertOptions(MProfileOptions ent) { using (SqlConnection con = new SqlConnection(ConnectionDB.GetConnectionString())) { try { SqlCommand cmd = new SqlCommand("sp_ProfileOptions_Ins", con); cmd.CommandTimeout = 0; cmd.Parameters.Add("@IProfileId", SqlDbType.VarChar).Value = ent.ProfileId; cmd.Parameters.Add("@IOptionId", SqlDbType.VarChar).Value = ent.OptionId; cmd.CommandType = CommandType.StoredProcedure; con.Open(); cmd.ExecuteNonQuery(); con.Close(); return(0); } catch (Exception ex) { return(2); } } }
public static List <MProfileOptions> SelOptions(MProfile ent, ref int Val) { List <MProfileOptions> lisQuery = new List <MProfileOptions>(); using (SqlConnection con = new SqlConnection(ConnectionDB.GetConnectionString())) { try { SqlCommand cmd = new SqlCommand("sp_ProfileOptions_Sel", con); cmd.Parameters.Add("@IProfileId", SqlDbType.VarChar).Value = ent.ProfileId; cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; con.Open(); Val = 1; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { MProfileOptions entRow = new MProfileOptions(); entRow.ProfileId = Convert.ToInt32(reader["ProfileId"]); entRow.OptionId = Convert.ToInt32(reader["OptionId"]); lisQuery.Add(entRow); Val = 0; } } con.Close(); } catch (Exception ex) { Val = 2; } } return(lisQuery); }