public static List<District> SelectAll() { List<District> list = new List<District>(); string spSelectAll = "spGetAllDistrict"; SqlDataReader rd = DataProvider.ExecuteQueryWithDataReader(spSelectAll, CommandType.StoredProcedure); if (rd.HasRows) { while (rd.Read()) { District r = new District() { DistrictID = rd.GetInt32(0), NameOfDistrict = rd.GetString(1) }; list.Add(r); } } return list.OrderBy(p => p.DistrictID).ToList(); }
private void btnOk_Click(object sender, RoutedEventArgs e) { try { District dis = new District(); dis.DistrictID = (DistrictBLL.GetCurrentIden() + 1); dis.NameOfDistrict = txtNameOfDistrict.Text; DistrictBLL.AddDistrict(dis); System.Windows.Forms.MessageBox.Show("Successfully"); if (AddFinshed != null) { AddFinshed(dis); } } catch (Exception g) { System.Windows.Forms.MessageBox.Show("Error: " + g.Message); } finally { this.Close(); } }
private void updateTable(District dis) { dt.Rows.Add(dis.DistrictID,dis.NameOfDistrict); }
public static bool AddDistrict(District dis) { return DistrictData.InsertDistrict(dis); }
public static bool InsertDistrict(District dis) { string sql = "spAddDistrict"; SqlParameter NameOfDistrict = new SqlParameter("Name", dis.NameOfDistrict); return DataProvider.ExecuteNonQuery(sql, System.Data.CommandType.StoredProcedure, NameOfDistrict); }