public bool Delete() { try { MonamurDBDataSetTableAdapters.ClientsTableAdapter t_clientsTableAdap = new MonamurDBDataSetTableAdapters.ClientsTableAdapter(); t_clientsTableAdap.DeleteClient(ID); return(true); } catch (System.Data.SqlClient.SqlException ex) { return(false); } }
public void GetClient(Clients client) { MonamurDBDataSetTableAdapters.ClientsTableAdapter t_clientsTableAdap = new MonamurDBDataSetTableAdapters.ClientsTableAdapter(); MonamurDBDataSet.ClientsDataTable t_clientsDataTable = new MonamurDBDataSet.ClientsDataTable(); t_clientsTableAdap.FillByID(t_clientsDataTable, client.ID); client.Fio = t_clientsDataTable.Rows[0]["fio"].ToString(); client.Character = Convert.ToInt32(t_clientsDataTable.Rows[0]["character"]); client.Phone = t_clientsDataTable.Rows[0]["phone"].ToString(); client.Social = t_clientsDataTable.Rows[0]["social"].ToString(); client.About = t_clientsDataTable.Rows[0]["about"].ToString(); client.Bonus = Convert.ToInt32(t_clientsDataTable.Rows[0]["bonus"]); }
public bool UpdateClient() { try { MonamurDBDataSetTableAdapters.ClientsTableAdapter t_clientsTableAdap = new MonamurDBDataSetTableAdapters.ClientsTableAdapter(); t_clientsTableAdap.UpdateClient(Fio, Character, Phone, Social, About, Bonus, Sms, ID); return(true); } catch { return(false); } }
public void GetInfo() { MonamurDBDataSetTableAdapters.ClientsTableAdapter t_clientsTableAdap = new MonamurDBDataSetTableAdapters.ClientsTableAdapter(); MonamurDBDataSet.ClientsDataTable t_clientsDataTable = new MonamurDBDataSet.ClientsDataTable(); t_clientsTableAdap.FillByID(t_clientsDataTable, ID); Fio = t_clientsDataTable.Rows[0]["fio"].ToString(); Character = Convert.ToInt32(t_clientsDataTable.Rows[0]["character"]); Phone = t_clientsDataTable.Rows[0]["phone"].ToString(); Social = t_clientsDataTable.Rows[0]["social"].ToString(); About = t_clientsDataTable.Rows[0]["about"].ToString(); Bonus = Convert.ToInt32(t_clientsDataTable.Rows[0]["bonus"]); Sms = (bool)t_clientsDataTable.Rows[0]["sms"]; }
public bool AddClient() { try { MonamurDBDataSetTableAdapters.ClientsTableAdapter t_clientsTableAdap = new MonamurDBDataSetTableAdapters.ClientsTableAdapter(); t_clientsTableAdap.InsertClient(Fio, Character, Phone, Social, About, Bonus, Sms); MonamurDBDataSet.ClientsDataTable t_clientsDT = new MonamurDBDataSet.ClientsDataTable(); t_clientsTableAdap.FillByFio(t_clientsDT, Fio); ID = Convert.ToInt32(t_clientsDT.Rows[0]["id"]); return(true); } catch { return(false); } }