void PopulateDataGridView()
{
try
{
dbs_CMMSEntities1 obj = new dbs_CMMSEntities1();
//var FillData = obj.tbl_ShenasnamehMoshinAlat.ToList();
var result = (from b in obj.tbl_GhataatMasrafiMashinAlat
join p in obj.tbl_AnbarGhataatYadaki
on b.IDAnbarGhataatYadaki equals p.ID where b.IDShenasnamehMoshinAlat == PropIDShenasnamehMoshinAlat
select new
{
IDShenasnamehMoshinAlat = p.ID,
Tedad = b.Tedad,
NameGheteh = p.NameGheteh,
Mojoodi = p.Mojoodi
}).ToList();
dgvShenasnamehMashinAlat.DataSource = result;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "خطایی رخ داده است", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
void PopulateDataGridView()
{
try
{
using (dbs_CMMSEntities1 _db = new dbs_CMMSEntities1())
{
dgvShenasnamehMashinAlat.DataSource = _db.tbl_AnbarGhataatYadaki.ToList();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "خطایی رخ داده است", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
using (dbs_CMMSEntities1 _db = new dbs_CMMSEntities1())
{
_List_tbl_AnbarGhataatYadaki = _db.tbl_AnbarGhataatYadaki.Where(x => x.Code.Contains(txtSearch.Text) || x.NameGheteh.Contains(txtSearch.Text) || x.ShomarehFani.Contains(txtSearch.Text)).ToList <tbl_AnbarGhataatYadaki>();
dgvShenasnamehMashinAlat.DataSource = _List_tbl_AnbarGhataatYadaki;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "خطایی رخ داده است", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
dbs_CMMSEntities1 obj = new dbs_CMMSEntities1();
tbl_GhataatMasrafiMashinAlat tbl = new tbl_GhataatMasrafiMashinAlat();
tbl.IDShenasnamehMoshinAlat = PropIDShenasnamehMoshinAlat;
tbl.IDAnbarGhataatYadaki = PropIDAnbarGhataatYadaki;
tbl.Tedad = int.Parse(txtTedad.Text);
obj.tbl_GhataatMasrafiMashinAlat.Add(tbl);
obj.SaveChanges();
MessageBox.Show("اطلاعات با موفقیت ذخیره گردید", "ثبت اطلاعات", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "خطای رخ داده است", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
