protected void isavebtn_Click(object sender, EventArgs e) { Investigation_management_systemEntities4 db = new Investigation_management_systemEntities4(); Interview_Memo t = new Interview_Memo(); t.Investigation_Interview_ID = Convert.ToInt32(CaseIDlb.Text); t.Investigation_Interview_Memo = imemotxt.Text; db.Interview_Memo.Add(t); int res = db.SaveChanges(); if (res > 0) { LabelInterview.Text = "Data Inserted Successfully"; } else { LabelInterview.Text = "Try Again!!!"; } //Response.Write(newID); //Response.Redirect("QandA.aspx?Investigation_Interview_ID =" + newID); }
protected void Button1_Click(object sender, EventArgs e) { Investigation_management_systemEntities4 db = new Investigation_management_systemEntities4(); QuestionsAnswer qa = new QuestionsAnswer(); //c.Requester_ID = requestertxt.Text; //c.Employee_ID = accusedtxt.Text; //c.Case_Details = casedetailstxt.Text; //c.Case_Start_Date = Convert.ToDateTime(datetxt.Text); //c.Case_Type = int.Parse(DropDownList1.SelectedValue); qa.Question_ID = int.Parse(DropDownList1.SelectedValue); qa.Investigation_Interview_ID = Convert.ToInt32(CaseIDlb.Text); qa.Answer_Details = answertxt.Text; db.QuestionsAnswers.Add(qa); int res = db.SaveChanges(); if (res > 0) { Response.Write("Data Inserted Successfully"); } else { Response.Write("Try Again!!!"); } int newID = qa.Investigation_Interview_ID; Response.Redirect("Interviewmemo.aspx?CaseID=" + newID); }
protected void iisendbtn_Click(object sender, EventArgs e) { Investigation_management_systemEntities4 db = new Investigation_management_systemEntities4(); Interview_Invite i = new Interview_Invite(); //var userinfo = (from a in db.Employees // where a.Employee_ID == iichtxt.Text // select new LoginRecords // { // UserID = a.Employee_ID, // }).FirstOrDefault(); i.Interview_Invitation_Date = Convert.ToDateTime(iidatetxt.Text); i.Interview_Invitation_Date_Sent = Convert.ToDateTime(iidatesenttxt.Text); i.Interview_Invitation_Invitee = EmpDropDownList.SelectedValue; i.Interview_Invitation_Location = iilocationtxt.Text; i.Interview_Invitation_Time = iiTimetxt.Text; i.Interview_Invitation_Details = iiDetailstxt.Text; i.Case_Handler_ID = CHlbl.Text; i.Case_ID = int.Parse(iiDropDownList.SelectedValue); db.Interview_Invite.Add(i); int res = db.SaveChanges(); if (res > 0) { LabelInvite.Text = "Data Inserted Successfully"; } else { LabelInvite.Text = "Try Again!!!"; } //if (userinfo != null) //{ // int res = db.SaveChanges(); // if (res > 0) // { // LabelInvite.Text = "Data Inserted Successfully"; // } // else // { // LabelInvite.Text = "Try Again!!!"; // } //} //else LabelInvite.Text = "Invalid username"; }
protected void Button1_Click1(object sender, EventArgs e) { Investigation_management_systemEntities4 te = new Investigation_management_systemEntities4(); InvestigationCase1 c = new InvestigationCase1(); //var userinfo = (from a in te.Employees // where a.Employee_ID == requestertxt.Text // select new LoginRecords // { // UserID = a.Employee_ID, // }).FirstOrDefault(); c.Requester_ID = Emplbl.Text; c.Employee_ID = EmpDropDownList.SelectedValue; c.Case_Details = casedetailstxt.Text; c.Case_Start_Date = Convert.ToDateTime(datetxt.Text); c.Case_Type = int.Parse(DropDownList1.SelectedValue); //c.Case_Type = Convert.ToInt32(TextBox1.Text); te.InvestigationCase1.Add(c); //insert it into table int res = te.SaveChanges(); if (res > 0) { Label7.Text = "Data Inserted Successfully"; } else { Label7.Text = "Try Again!!!"; } int newID = c.Case_ID; string requesterID = c.Requester_ID; //Response.Write(newID); //Response.Redirect("Evidence.aspx?CaseID=" + newID + requesterID); Response.Redirect(String.Format("Evidence.aspx?CaseID={0}&Requester_ID={1}", newID, requesterID)); //Response.Redirect(String.Format("~/page2.aspx?x={0}&y={1}", p1.x, p1.y)); }
protected void trsavebtn_Click(object sender, EventArgs e) { Investigation_management_systemEntities4 db = new Investigation_management_systemEntities4(); Termination_Request tr = new Termination_Request(); tr.Termination_Request_Date = Convert.ToDateTime(trDatetxt.Text); tr.Termination_Request_Justification = Justificationtxt.Text; tr.Case_ID = int.Parse(trDropDownList.SelectedValue); tr.Employee_ID = EmpDropDownList.SelectedValue; //var userinfo = (from a in db.Employees // where a.Employee_ID == trEmptxt.Text // select new LoginRecords // { // UserID = a.Employee_ID, // }).FirstOrDefault(); db.Termination_Requests.Add(tr); int res = db.SaveChanges(); if (res > 0) { LabelTermination.Text = "Data Inserted Successfully"; } else { LabelTermination.Text = "Try Again!!!"; } //if (userinfo != null) //{ // int res = db.SaveChanges(); // if (res > 0) // { // LabelTermination.Text = "Data Inserted Successfully"; // } // else // { // LabelTermination.Text = "Try Again!!!"; // } //} //else LabelTermination.Text = "Invalid username"; }
protected void evidsubmitbtn_Click(object sender, EventArgs e) { Investigation_management_systemEntities4 db = new Investigation_management_systemEntities4(); Evidence_Request evid = new Evidence_Request(); //var userinfo = (from a in db.Employees // where a.Employee_ID == EmpDropDownList.SelectedValue // select new LoginRecords // { // UserID = a.Employee_ID, // }).FirstOrDefault(); evid.Evidence_Request_Details = evidtxt.Text; evid.Case_Handler = CHlbl.Text; evid.Employee = EmpDropDownList.SelectedValue; evid.Case_ID = int.Parse(casedropdownlist.SelectedValue); evid.evidence_request_date = Convert.ToDateTime(datetxt.Text); db.Evidence_Request.Add(evid); int res = db.SaveChanges(); if (res > 0) { labelevid.Text = "Data Inserted Successfully"; } else { labelevid.Text = "Try Again!!!"; } //if (userinfo != null) //{ // int res = db.SaveChanges(); // if (res > 0) // { // labelevid.Text = "Data Inserted Successfully"; // } // else // { // labelevid.Text = "Try Again!!!"; // } //} //else labelevid.Text = "Invalid User ID"; }
protected void inextbtn_Click(object sender, EventArgs e) { Investigation_management_systemEntities4 db = new Investigation_management_systemEntities4(); Investigation_Interview t = new Investigation_Interview(); //var userinfo = (from a in db.Employees // where a.Employee_ID == Interviewertxt.Text // select new LoginRecords // { // UserID = a.Employee_ID, // }).FirstOrDefault(); t.Investigation_Interview_Interviewer_ID = CHlbl.Text; t.Investigation_Interview_Interviewee_ID = EmpDropDownList.SelectedValue; t.Case_ID = int.Parse(iDropDownList.SelectedValue); t.Investigation_Interview_Date = Convert.ToDateTime(idatetxt.Text); t.Investigation_Interview_Location = ilocationtxt.Text; t.Investigation_Interview_Time = itimetxt.Text; //t.Investigation_Interview_Memo = imemotxt.Text; db.Investigation_Interview.Add(t); int res = db.SaveChanges(); if (res > 0) { LabelInterview.Text = "Data Inserted Successfully"; } else { LabelInterview.Text = "Try Again!!!"; } //if (userinfo != null) //{ // int res = db.SaveChanges(); // if (res > 0) // { // LabelInterview.Text = "Data Inserted Successfully"; // } // else // { // LabelInterview.Text = "Try Again!!!"; // } //} /*else LabelInterview.Text = "Invalid username"*/ int newID = t.Investigation_Interview_ID; Response.Redirect("QandA.aspx?CaseID=" + newID); //Response.Write(newID); //Response.Redirect("QandA.aspx?Investigation_Interview_ID =" + newID); }