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 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);
}
}
