public void deleteBankPolicy(TextBox id) { var str = from a in con.BankPolicies where a.Id == int.Parse(id.Text) select a; BankPolicy c = str.First(); con.BankPolicies.DeleteOnSubmit(c); con.SubmitChanges(); }
public void insertBankPolicy(TextBox id, TextBox bankName, TextBox bankBranch, TextBox bankAddress, TextBox bankImage) { BankPolicy bp = new BankPolicy(); bp.Id = int.Parse(id.Text); bp.BankName = bankName.Text; bp.Branch = bankBranch.Text; bp.Address = bankAddress.Text; bp.Image = bankImage.Text; con.BankPolicies.InsertOnSubmit(bp); con.SubmitChanges(); }
public void updateBankPolicy(TextBox id, TextBox bname, TextBox branch, TextBox address, TextBox image) { var str = from a in con.BankPolicies where a.Id == int.Parse(id.Text) select a; BankPolicy b = str.First(); b.BankName = bname.Text; b.Branch = branch.Text; b.Address = address.Text; b.Image = image.Text; con.SubmitChanges(); }
//*********************picture public void retrieveBankPolicy(PictureBox p, TextBox id, DataGridView d) { var str = from a in con.BankPolicies where a.Id == int.Parse(id.Text) select a; BankPolicy b = str.First(); string s = b.Image; string ipath = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), @s); p.Image = System.Drawing.Image.FromFile(ipath); SqlConnection conc = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=I:\varsity\C#\Car-Showroom Management System\WindowsFormsApplication1\CarShowDB.mdf;Integrated Security=True;Connect Timeout=30"); SqlDataAdapter sda = new SqlDataAdapter(@"SELECT Id, BankName, Branch, Image, Address FROM BankPolicy where Id =" + id.Text, conc); DataTable dt = new DataTable(); sda.Fill(dt); d.DataSource = dt; conc.Close(); }