public DataSet dataTTTV(string Address, DateTime FromDate, DateTime ToDate, string type)
{
DataSet ds = new DataSet();
ServiceReference1.pisClient proxy = new ServiceReference1.pisClient();
TTTVService.TranferRecord[] result = proxy.ListPersonByDate(Address, FromDate, ToDate,type);
ds = CreateData();
DataRow dr;
for (int i = 0; i < result.Length; i++)
{
dr = ds.Tables["tamtrutamvang"].NewRow();
//dr["Id"] = result[i].Id;
dr["FullName"] = result[i].FullName;
dr["PhoneNumber"] = result[i].PhoneNumber;
dr["Email"] = result[i].Email;
dr["Birthday"] = result[i].Birthday.ToString("dd/MM/yyyy");
dr["Sex"] = result[i].Sex;
dr["OriginalAddress"] = result[i].OriginalAddress;
dr["IDNumber"] = result[i].IDNumber;
dr["Occupation"] = result[i].Occupation;
dr["CurrentAddress"] = result[i].CurrentAddress;
dr["FromDate"] = result[i].FromDate.ToString("dd/MM/yyyy");
dr["ToDate"] = result[i].ToDate.ToString("dd/MM/yyyy");
dr["Reason"] = result[i].Reason;
dr["Description"] = result[i].Description;
//dr["Type"] = result[i].Type;
// add row to table
ds.Tables["tamtrutamvang"].Rows.Add(dr);
}
return ds;
}
private void Thongtinnhom_Load(object sender, EventArgs e)
{
try
{
ServiceReference1.pisClient proxy = new ServiceReference1.pisClient();
label1.Text = proxy.GetAuthorInfo();
}
catch
{
MessageBox.Show("Lỗi kết nối");
}
}
public DataSet dataTTTV(string Address, string type)
{
DataSet ds = new DataSet();
ServiceReference1.pisClient proxy = new ServiceReference1.pisClient();
TTTVService.TranferRecord[] result = proxy.CountSexByAddress(Address, type);
ds = CreateData();
DataRow dr;
for (int i = 0; i < result.Length; i++)
{
dr = ds.Tables["tamtrutamvang"].NewRow();
dr["Sex"] = result[i].Sex;
dr["Total"] = result[i].Total;
// add row to table
ds.Tables["tamtrutamvang"].Rows.Add(dr);
}
return ds;
}
private void button3_Click(object sender, EventArgs e)
{
try
{
ServiceReference1.pisClient proxy = new ServiceReference1.pisClient();
TTTVService.TranferRecord param = new TTTVService.TranferRecord();
param.Id = int.Parse(textBox12.Text.Trim());
// delete infromation
proxy.DeleteInformation(param.Id);
MessageBox.Show("Xóa dữ liệu thành công!!");
// xoa du lieu textbox
clearData();
// load data again
DataSet myDs = new DataSet();
myDs = dataTTTV();
dataGridView1.DataSource = myDs.Tables[0].DefaultView;
}
catch (FaultException exp)
{
MessageBox.Show(exp.Reason.ToString());
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
ServiceReference1.pisClient proxy = new ServiceReference1.pisClient();
TTTVService.TranferRecord param = new TTTVService.TranferRecord();
param.FullName = textBox1.Text.Trim();
param.PhoneNumber = textBox2.Text.Trim();
param.Email = textBox3.Text.Trim();
param.Birthday = dateTimePicker1.Value;
param.Sex = textBox5.Text.Trim();
param.OriginalAddress = textBox4.Text.Trim();
param.IDNumber = textBox6.Text.Trim();
param.Occupation = textBox7.Text.Trim();
param.CurrentAddress = textBox8.Text.Trim();
param.FromDate = dateTimePicker2.Value;
param.ToDate = dateTimePicker3.Value;
param.Reason = textBox9.Text.Trim();
param.Description = textBox10.Text;
param.Type = textBox11.Text.Trim();
param.Id = int.Parse(textBox12.Text.Trim());
// update infromation
proxy.UpdatInformation(param.Id, param);
MessageBox.Show("Cập nhật dữ liệu thành công!!");
// xoa du lieu textbox
clearData();
// load data again
DataSet myDs = new DataSet();
myDs = dataTTTV();
dataGridView1.DataSource = myDs.Tables[0].DefaultView;
}
catch (FaultException exp)
{
MessageBox.Show(exp.Reason.ToString());
}
}
