public static void nationalityInsert(NationalityHL nation) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = Common.getConnection(); cmd.CommandText = "Nationality_Insert"; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter sNationalityName = new SqlParameter("@nationalityName", nation.nationalityName); sNationalityName.SqlDbType = System.Data.SqlDbType.NVarChar; cmd.Parameters.Add(sNationalityName); cmd.ExecuteNonQuery(); } }
public static void nationalityDelete(NationalityHL nation) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = Common.getConnection(); cmd.CommandText = "Nationality_Delete"; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter iNationalityId = new SqlParameter("@nationalityId", nation.nationalityId); iNationalityId.SqlDbType = System.Data.SqlDbType.Int; cmd.Parameters.Add(iNationalityId); cmd.ExecuteNonQuery(); } }
public static List <NationalityHL> getNationalityList() { List <NationalityHL> NationalityList = new List <NationalityHL>(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = Common.getConnection(); cmd.CommandText = "Nationality_Select"; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { NationalityHL nation = new NationalityHL(); nation.nationalityName = dt.Rows[i]["nationality"].ToString(); nation.nationalityId = Int32.Parse(dt.Rows[i]["nationalityId"].ToString()); NationalityList.Add(nation); } } return(NationalityList); }