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