private void btnOK_Click(object sender, EventArgs e) { listSite = siteBus.getData(); foreach (SITES site in listSite) { if (site.SiteName == txtSiteName.Text) { MessageBox.Show("Site name already exists!", "Cortek RBI"); return; } } SITES s = new SITES(); s.SiteName = txtSiteName.Text; if (IsFormEditName) { s.SiteID = siteID; siteBus.edit(s); } else { siteBus.add(s); } ButtonOKClicked = true; this.Close(); }
public SITES getData() { SITES site = new SITES(); site.SiteName = txtSiteName.Text; return(site); }
private Website getSite(SITES site) { switch (site) { case SITES.FurAffinity: return(FA); case SITES.InkBunny: return(IB); } return(null); }
// dung file get data // dung file get list( data source) public List <SITES> getDataSource() { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <SITES> list = new List <SITES>(); SITES obj = null; String sql = "Use [rbi]" + "SELECT [SiteID]" + ",[SiteName]" + " FROM [rbi].[dbo].[SITES]"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new SITES(); obj.SiteID = reader.GetInt32(0); obj.SiteName = reader.GetString(1); list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(list); }
public void delete(SITES obj) { DAL.delete(obj.SiteID); }
public void edit(SITES obj) { DAL.edit(obj.SiteID, obj.SiteName); }
public void add(SITES obj) { DAL.add(obj.SiteName); }