protected void btndel_Click(object sender, EventArgs e) { var del = (from x in db.tblStaff_infos where x.Staff_id == Convert.ToInt32(dropstaff.SelectedValue) select new { id = x.Staff_id, count = x.tblTime_Records.Count }).SingleOrDefault(); if (del != null) { if (del.count < 250) { //Delete Permanently tblStaff_info stf = db.tblStaff_infos.Single(x => x.Staff_id == del.id); db.tblStaff_infos.DeleteOnSubmit(stf); db.SubmitChanges(); Response.Write("<script>alert ('Staff Deleted Permanently');</script>"); } else { //terminate tblStaff_info stf = db.tblStaff_infos.Single(x => x.Staff_id == del.id); stf.Del_status = "Terminated"; db.SubmitChanges(); Response.Write("<script>alert ('Staff Terminated');</script>"); } } }
protected void btnupd_Click(object sender, EventArgs e) { try { if (validateinput()) { if (dropstaff.SelectedValue.ToString() == "") { Response.Write("<script>alert ('Please Selerct a staff member');</script>"); return; } tblStaff_info upd = db.tblStaff_infos.Single(x => x.Staff_id == Convert.ToInt32(dropstaff.SelectedValue)); upd.Fname = txtfname.Text; upd.Lname = txtlname.Text; upd.Join_date = Convert.ToDateTime(txtdate.Text); upd.Phone_number = Convert.ToInt32(txtphone.Text); if (RadioButton1.Checked == true) { upd.Sex = 'M'; } else if (RadioButton2.Checked == true) { upd.Sex = 'F'; } upd.Hrs_per_day = Convert.ToInt32(txthour.Text); upd.Profession = dropprofession.SelectedItem.ToString(); upd.Age = Convert.ToInt32(txtage.Text); upd.Address = txtaddress.Text; db.SubmitChanges(); Response.Write("<script>alert ('Record Updated Successfully');</script>"); clear(); } else { return; } } catch (Exception ex) { Response.Write("<script>alert ('Please Try Again');</script>"); return; } }
protected void btnadd_Click(object sender, EventArgs e) { Label10.Text = ""; try { if (validateinput()) { tblStaff_info person = new tblStaff_info(); person.Fname = txtfname.Text; person.Lname = txtlname.Text; person.Join_date = Convert.ToDateTime(txtdate.Text); person.Phone_number = Convert.ToInt32(txtphone.Text); person.Address = txtaddress.Text; person.Profession = (dropjob.SelectedItem.Text); person.Jop_id = Convert.ToInt32(dropjob.SelectedValue); person.Hrs_per_day = Convert.ToInt32(txthour.Text); person.Age = Convert.ToInt32(txtage.Text); if (RadioButton1.Checked == true) { person.Sex = 'M'; } else if (RadioButton2.Checked == true) { person.Sex = 'F'; } db.tblStaff_infos.InsertOnSubmit(person); db.SubmitChanges(); Response.Write("<script>alert ('Record Added Successfully');</script>"); clear(); } else { return; } } catch (Exception ex) { Response.Write("<script>alert ('Please Try Again');</script>"); // Label10.Text = ex.ToString(); } }
partial void DeletetblStaff_info(tblStaff_info instance);
partial void UpdatetblStaff_info(tblStaff_info instance);
partial void InserttblStaff_info(tblStaff_info instance);
private void detach_tblStaff_infos(tblStaff_info entity) { this.SendPropertyChanging(); entity.tblJob_Title = null; }