private void button3_Click(object sender, EventArgs e)
{
int index = dataGridView1.CurrentRow.Index;
dataGridView1.Columns["MATHUCHIENYEUCAU"].Visible = true;
string key;
key = dataGridView1.Rows[index].Cells[9].Value.ToString();
dataGridView1.Columns["MATHUCHIENYEUCAU"].Visible = false;
THYCDTO thdto = new THYCDTO();
THYCBUS thbus = new THYCBUS();
thdto = thbus.collect_update(key);
THYCKH_3T frthyc = new THYCKH_3T(thdto);
frthyc.ShowDialog();
dataGridView1.Refresh();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
List <THYCDTO> lsth = thbus.select_THYC();
Load_Datagridview1(lsth);
dataGridView1.Columns["TINH"].Visible = false;
dataGridView1.Columns["HUYEN"].Visible = false;
dataGridView1.Columns["XA"].Visible = false;
dataGridView1.Columns["EMAIL"].Visible = false;
dataGridView1.Columns["DUONG"].Visible = false;
dataGridView1.Columns["SONHA"].Visible = false;
dataGridView1.Columns["LAU"].Visible = false;
dataGridView1.Columns["PHONG"].Visible = false;
dataGridView1.Columns["WEBSITE"].Visible = false;
dataGridView1.Columns["SDTBAN1"].Visible = false;
dataGridView1.Columns["SDTBAN2"].Visible = false;
dataGridView1.Columns["PHONGBAN"].Visible = false;
dataGridView1.Columns["GHICHU"].Visible = false;
dataGridView1.Columns["MAPTGUIHANG"].Visible = false;
dataGridView1.Columns["KHUCAOOC"].Visible = false;
dataGridView1.Columns["THOIGIANKHDAPUNG"].Visible = false;
dataGridView1.Columns["YEUCAU"].Visible = false;
dataGridView1.Columns["GIATRIPO"].Visible = false;
dataGridView1.Columns["NHANDINHTHUCTRANG"].Visible = false;
dataGridView1.Columns["QUATRINHXULY"].Visible = false;
dataGridView1.Columns["MATHUCHIENYEUCAU"].Visible = false;
dataGridView1.Columns["mst"].Visible = false;
dataGridView1.Columns["sdt"].Visible = false;
}
private void btLuu_Sua_Click(object sender, EventArgs e)
{
THYCDTO thuchien = new THYCDTO();
var checkedButton = tabPage2.Controls.OfType <RadioButton>()
.FirstOrDefault(r => r.Checked);
thuchien.MATHUCHIENYEUCAU = IDtemp;
thuchien.mst = txtMST.Text;
thuchien.sdt = txtMobile.Text;
thuchien.TENCOQUAN = txtCoQuan.Text;
thuchien.LAU = int.Parse(txtLau.Text);
thuchien.HOVATEN = txtNguoiLienHe.Text;
thuchien.SONHA = txtSoNha.Text;
thuchien.PHONGBAN = txtPhongBan.Text;
thuchien.SDTBAN1 = txtTel1.Text;
thuchien.SDTBAN2 = txtTel2.Text;
thuchien.EMAIL = txtEmail.Text;
thuchien.WEBSITE = txtWebsite.Text;
thuchien.GHICHU = txtGhiChu.Text;
thuchien.KHUCAOOC = txtKhuCaoOc.Text;
thuchien.PHONG = txtPhong.Text;
thuchien.DUONG = txtDuong.Text;
thuchien.XA = cbXa.Text;
thuchien.HUYEN = cbHuyen.Text;
thuchien.TINH = cbTinh.Text;
if (checkedButton.Text == "Fax")
{
thuchien.MAPTGUIHANG = "001";
}
else if (checkedButton.Text == "Email")
{
thuchien.MAPTGUIHANG = "002";
}
else if (checkedButton.Text == "Mail")
{
thuchien.MAPTGUIHANG = "003";
}
else if (checkedButton.Text == "Trực tiếp")
{
thuchien.MAPTGUIHANG = "004";
}
thuchien.MANHANVIENGHINHAN = this.cbNVGhiNhan.GetItemText(this.cbNVGhiNhan.SelectedItem);
if (thuchien.MANHANVIENGHINHAN == "Anh")
{
thuchien.MANHANVIENGHINHAN = "001";
}
if (thuchien.MANHANVIENGHINHAN == "Long")
{
thuchien.MANHANVIENGHINHAN = "002";
}
if (thuchien.MANHANVIENGHINHAN == "Tuấn")
{
thuchien.MANHANVIENGHINHAN = "003";
}
if (thuchien.MANHANVIENGHINHAN == "Văn")
{
thuchien.MANHANVIENGHINHAN = "004";
}
thuchien.YEUCAU = txtYeuCau.Text;
thuchien.THOIGIANKHDAPUNG = dateTimePicker1.Value;
thuchien.MANHANVIENTHUCHIEN = this.cbNVThucHien.GetItemText(this.cbNVThucHien.SelectedItem);
if (thuchien.MANHANVIENTHUCHIEN == "Anh")
{
thuchien.MANHANVIENTHUCHIEN = "001";
}
if (thuchien.MANHANVIENTHUCHIEN == "Long")
{
thuchien.MANHANVIENTHUCHIEN = "002";
}
if (thuchien.MANHANVIENTHUCHIEN == "Tuấn")
{
thuchien.MANHANVIENTHUCHIEN = "003";
}
if (thuchien.MANHANVIENTHUCHIEN == "Văn")
{
thuchien.MANHANVIENTHUCHIEN = "004";
}
thuchien.KETQUA = this.cbKetQua.GetItemText(this.cbKetQua.SelectedItem);
thuchien.QUATRINHXULY = txtGhiNhan.Text;
thuchien.NHANDINHTHUCTRANG = txtNhanDinh.Text;
thuchien.GIATRIPO = int.Parse(txtGiaTriPO.Text);
THYCBUS thbus = new THYCBUS();
thbus.luu_sua(thuchien);
this.Close();
}
public THYCKH_3T(THYCDTO thuchien)
{
InitializeComponent();
btLuu.Hide();
IDtemp = thuchien.MATHUCHIENYEUCAU;
txtCoQuan.Text = thuchien.TENCOQUAN;
txtMST.Text = thuchien.mst;
txtNguoiLienHe.Text = thuchien.HOVATEN;
txtPhongBan.Text = thuchien.PHONGBAN;
txtEmail.Text = thuchien.EMAIL;
txtWebsite.Text = thuchien.WEBSITE;
txtGhiChu.Text = thuchien.GHICHU;
txtLau.Text = thuchien.LAU.ToString();
txtSoNha.Text = thuchien.SONHA;
txtTel1.Text = thuchien.SDTBAN1;
txtTel2.Text = thuchien.SDTBAN2;
txtMobile.Text = thuchien.sdt;
txtKhuCaoOc.Text = thuchien.KHUCAOOC;
txtPhong.Text = thuchien.PHONG;
txtDuong.Text = thuchien.DUONG;
cbTinh.Text = thuchien.TINH;
cbHuyen.Text = thuchien.HUYEN;
cbXa.Text = thuchien.XA;
dateTimePicker1.Value = thuchien.THOIGIANKHDAPUNG;
txtYeuCau.Text = thuchien.YEUCAU;
txtGiaTriPO.Text = thuchien.GIATRIPO.ToString();
cbKetQua.Text = thuchien.KETQUA;
txtNhanDinh.Text = thuchien.NHANDINHTHUCTRANG;
txtGhiNhan.Text = thuchien.QUATRINHXULY;
string temp = thuchien.MANHANVIENGHINHAN;
if (temp.Trim() == "001")
{
cbNVGhiNhan.SelectedIndex = 0;
}
else if (temp.Trim() == "002")
{
cbNVGhiNhan.Text = "Long";
}
else if (temp.Trim() == "003")
{
//cbNVGhiNhan.SelectedIndex = 3;
cbNVGhiNhan.SelectedItem = "Tuấn";
}
else if (temp.Trim() == "004")
{
cbNVGhiNhan.Text = "Văn";
}
string temp2 = thuchien.MANHANVIENTHUCHIEN;
if (temp2.Trim() == "001")
{
cbNVThucHien.Text = "Anh";
}
else if (temp2.Trim() == "002")
{
cbNVThucHien.Text = "Long";
}
else if (temp2.Trim() == "003")
{
cbNVThucHien.Text = "Tuấn";
}
else if (temp2.Trim() == "004")
{
cbNVThucHien.Text = "Văn";
}
if (thuchien.MAPTGUIHANG.Trim() == "001")
{
rdFax.Checked = true;
}
else if (thuchien.MAPTGUIHANG.Trim() == "002")
{
rdEmail.Checked = true;
}
else if (thuchien.MAPTGUIHANG.Trim() == "003")
{
rdMail.Checked = true;
}
else if (thuchien.MAPTGUIHANG.Trim() == "004")
{
rdTrucTiep.Checked = true;
}
}
public bool luu_sua(THYCDTO thuchien)
{
bool kq = thdal.luu_sua(thuchien);
return(kq);
}
public bool luu(THYCDTO thyc)
{
bool kq = thdal.luu(thyc);
return(kq);
}
