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