private void button3_Click(object sender, EventArgs e)
{
try
{
using (FacultyLinqDataContext fup = new FacultyLinqDataContext())
{
FacultyLinqDataContext fupdate = new FacultyLinqDataContext();
int id = int.Parse(label6.Text);
Faculty_Info fobj = fupdate.Faculty_Infos.SingleOrDefault(Faculty_Info => Faculty_Info.Id == id);
MessageBox.Show(textBox1.Text);
fobj.Name = textBox1.Text;
fobj.Email = textBox2.Text;
fobj.Contact = textBox3.Text;
fobj.Address = textBox4.Text;
fobj.Depatment = textBox5.Text;
fupdate.SubmitChanges();
MessageBox.Show("Data Updated");
}
}
catch (Exception ex)
{
//FacultyLinqDataContext fupdate = new FacultyLinqDataContext();
//fupdate.SubmitChanges();
MessageBox.Show(ex.Message);
/// textBox1.Text = null;
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
FacultyLinqDataContext db = new FacultyLinqDataContext();
Faculty_Info fac = new Faculty_Info();
fac.Name = textBox1.Text;
fac.Email = textBox2.Text;
fac.Contact = textBox3.Text;
fac.Address = textBox4.Text;
fac.Education = textBox5.Text;
fac.Age = textBox6.Text;
fac.Sex = textBox7.Text;
fac.Religion = textBox8.Text;
fac.PreferredCourse = textBox9.Text;
fac.DayOff = "Friday";
fac.Depatment = textBox13.Text;
fac.CreatePassword = textBox12.Text;
db.Faculty_Infos.InsertOnSubmit(fac);
db.SubmitChanges();
File.Copy(temp_a, @"C:\Users\Tomal\Documents\Visual Studio 2013\Projects\Info\AllInfo\facultypropic\" + textBox1.Text + ".jpg");
MessageBox.Show("Data Inserted");
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace);
}
}
private void button4_Click(object sender, EventArgs e)
{
FacultyLinqDataContext fdelete = new FacultyLinqDataContext();
Faculty_Info finfo = fdelete.Faculty_Infos.Single(Faculty_Info => Faculty_Info.Name == textBox1.Text);
fdelete.Faculty_Infos.DeleteOnSubmit(finfo);
fdelete.SubmitChanges();
MessageBox.Show("Data ddeleted");
}