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