예제 #1
0
        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);
        }
예제 #2
0
        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";
        }
예제 #4
0
        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));
        }
예제 #5
0
        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";
        }
예제 #6
0
        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";
        }
예제 #7
0
        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);
        }