public void PhieuGiaCong_Upd(PhieuGiaCong_DTO pbh)
{
var obj = vbdq.PHIEUGIACONGs.Single(x => x.SoPhieuGiaCong == pbh.SoPhieuGiaCong);
obj.NgayLap = DateTime.Parse(pbh.NgayLap.ToString());
obj.TongTien = Decimal.Parse(pbh.TongTien.ToString());
vbdq.SubmitChanges();
}
public FormPhieuGiaCong_AddUpd(PhieuGiaCong_DTO phieugc)
{
InitializeComponent();
txtSoPhieuGiaCong.Text = phieugc.SoPhieuGiaCong.ToString();
dtPicker_NgayLap.Value = DateTime.Parse(phieugc.NgayLap.ToString());
txtTongTien.Text = phieugc.TongTien.ToString();
btnThem.Enabled = false;
}
public void PhieuGiaCong_Add(PhieuGiaCong_DTO pbh)
{
PHIEUGIACONG obj = new PHIEUGIACONG();
obj.SoPhieuGiaCong = pbh.SoPhieuGiaCong;
obj.NgayLap = DateTime.Parse(pbh.NgayLap.ToString());
obj.TongTien = Decimal.Parse(pbh.TongTien.ToString());
vbdq.PHIEUGIACONGs.InsertOnSubmit(obj);
vbdq.SubmitChanges();
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
PhieuGiaCong_DTO phieugc = new PhieuGiaCong_DTO();
phieugc.SoPhieuGiaCong = Int16.Parse(txtSoPhieuGiaCong.Text);
phieugc.NgayLap = dtPicker_NgayLap.Value.ToShortDateString();
phieugc.TongTien = Decimal.Parse(txtTongTien.Text);
phieugc_bus.PhieuGiaCong_Upd(phieugc);
this.Close();
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtSoPhieugc.Text.CompareTo("") == 0)
{
MessageBox.Show("Vui lòng chọn dòng dữ liệu muốn Sửa !");
}
else
{
PhieuGiaCong_DTO phieugc = new PhieuGiaCong_DTO();
phieugc.SoPhieuGiaCong = Int16.Parse(txtSoPhieugc.Text);
phieugc.NgayLap = txtNgayLap.Text;
phieugc.TongTien = Decimal.Parse(txtTongTien.Text);
FormPhieuGiaCong_AddUpd form = new FormPhieuGiaCong_AddUpd(phieugc);
DialogResult dr = form.ShowDialog();
dataGridView.DataSource = phieugc_bus.LayTatCa();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (KT_Ngay(txtNgayLap.Text))
{
TextBox_readonly_false();
try
{
PhieuGiaCong_DTO phieudv = new PhieuGiaCong_DTO();
if (txtSoPhieugc.Text.CompareTo("") != 0)
{
phieudv.SoPhieuGiaCong = Int16.Parse(txtSoPhieugc.Text);
}
else
{
phieudv.SoPhieuGiaCong = 0;
}
if (txtNgayLap.Text.CompareTo("") != 0)
{
phieudv.NgayLap = txtNgayLap.Text;
}
else
{
phieudv.NgayLap = " ";
}
if (txtTongTien.Text.CompareTo("") != 0)
{
phieudv.TongTien = Decimal.Parse(txtTongTien.Text);
}
else
{
phieudv.TongTien = 0;
}
dataGridView.DataSource = phieugc_bus.Search(phieudv);
}
catch (FormatException ex) { }
//catch (Exception ex2) { }
}
else
{
MessageBox.Show("Nhập ngày sai. Vui lòng nhập theo dạng : 2016/5/31");
}
}
public List <PhieuGiaCong_DTO> Search(PhieuGiaCong_DTO phieu)
{
//DateTime t1 = phieugc.NgayLap;
DateTime t1;
DateTime.TryParse(phieu.NgayLap, out t1);
var list = (from phieugc in vbdq.PHIEUGIACONGs
where (phieugc.SoPhieuGiaCong == phieu.SoPhieuGiaCong || phieu.SoPhieuGiaCong == 0) &&
(phieu.NgayLap.Contains(" ") || phieugc.NgayLap == t1) &&
(phieugc.TongTien == phieu.TongTien || phieu.TongTien == 0)
select new PhieuGiaCong_DTO
{
SoPhieuGiaCong = phieugc.SoPhieuGiaCong,
NgayLap = phieugc.NgayLap.ToString(),
TongTien = Decimal.Parse(phieugc.TongTien.ToString())
});
return(list.ToList());
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
TextBox_readonly_false();
try
{
PhieuGiaCong_DTO phieudv = new PhieuGiaCong_DTO();
if (txtSoPhieugc.Text.CompareTo("") != 0)
{
phieudv.SoPhieuGiaCong = Int16.Parse(txtSoPhieugc.Text);
}
else
{
phieudv.SoPhieuGiaCong = 0;
}
if (txtNgayLap.Text.CompareTo("") != 0)
{
phieudv.NgayLap = txtNgayLap.Text;
}
else
{
phieudv.NgayLap = " ";
}
if (txtTongTien.Text.CompareTo("") != 0)
{
phieudv.TongTien = Decimal.Parse(txtTongTien.Text);
}
else
{
phieudv.TongTien = 0;
}
dataGridView.DataSource = phieugc_bus.Search(phieudv);
}
catch (FormatException ex) { }
//catch (Exception ex2) { }
}