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 Page_Load(object sender, EventArgs e)
{
Investigation_management_systemEntities4 db = new Investigation_management_systemEntities4();
var total = (from o in db.InvestigationCase1
select o).Count();
lb1.Text = total.ToString();
var ia = (from o in db.InvestigationCase1
where o.Case_Type >= 9 && o.Case_Type <= 15
select o).Count();
lb2.Text = ia.ToString();
var hr = (from o in db.InvestigationCase1
where o.Case_Type >= 1 && o.Case_Type <= 8
select o).Count();
lb3.Text = hr.ToString();
var complete = (from o in db.InvestigationCase1
where o.Case_Status == 1
select o).Count();
lb5.Text = complete.ToString();
var newcase = (from o in db.InvestigationCase1
where o.Case_Status == 4
select o).Count();
lb6.Text = newcase.ToString();
var open = (from o in db.InvestigationCase1
where o.Case_Status == 3
select o).Count();
lb4.Text = open.ToString();
}
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);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Investigation_management_systemEntities4 db = new Investigation_management_systemEntities4();
//string query_empID = (from c in db.Employees
// where c.Employee_ID == txtUserName.Text && c.Password == txtPWD.Text
// select c.Employee_ID).FirstOrDefault();
//int temp = Convert.ToInt32(query_empID.ToString());
//if (temp != 0)
//{
// lbMessage.Text = "";
// string query_empName = (from x in db.Employees
// where x.Employee_ID == query_empID
// select x.First_Name + " " + x.Last_Name).FirstOrDefault();
// Response.Redirect("CaseRequest.aspx?name=" + query_empName);
// //Response.Redirect("Homepage.aspx?name=" + query_empName);
//}
var userinfo = (from c in db.Employees
where c.Employee_ID == txtUserName.Text && c.Password == txtPWD.Text
select new LoginRecords
{
UserID = c.Employee_ID,
UserPassword = c.Password,
UserType = c.Employee_Type
}).FirstOrDefault();
if (userinfo != null)
{
lbMessage.Text = "";
if (userinfo.UserType == "Ch")
{
string query_chEmpName = (from x in db.Employees
where x.Employee_ID == userinfo.UserID
select x.First_Name + " " + x.Last_Name).FirstOrDefault();
//Response.Redirect("Homepage.aspx?name=" + query_chEmpName);
//string empID = userinfo.UserID;
//Response.Redirect(String.Format("Homepage.aspx?name={0}&emp_ID={1}", query_chEmpName, empID));
Session["empID"] = txtUserName.Text;
Session["name"] = query_chEmpName;
Response.Redirect("Homepage.aspx");
}
else if (userinfo.UserType == "Em")
{
string query_empName = (from x in db.Employees
where x.Employee_ID == userinfo.UserID
select x.First_Name + " " + x.Last_Name).FirstOrDefault();
Session["emID"] = txtUserName.Text;
Session["name"] = query_empName;
Response.Redirect("EmployeeHP.aspx");
//Response.Redirect("EmployeeHP.aspx?name=" + query_empName);
}
}
else
{
lbMessage.Text = "Invalid username or password";
}
}
