コード例 #1
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            String  id  = Session["id"].ToString();
            decimal dec = System.Convert.ToDecimal(id);



            String acitvity_id = activity_name.SelectedItem.Value;

            databaseDataContext up = new databaseDataContext();
            //Get Single course which need to update
            RefComplaint obj = up.RefComplaints.Single(c => c.complaint_id.Equals(dec));

            //Field which will be update

            int activity_id = System.Convert.ToInt16(activity_name.SelectedItem.Value);

            obj.ActivityID = activity_id;

            // executes the appropriate commands to implement the changes to the database
            up.SubmitChanges();

            databaseDataContext up1 = new databaseDataContext();

            RefActivityDetail activity = new RefActivityDetail {
                complaint_id = dec, ActivityID = activity_id
            };

            up1.RefActivityDetails.InsertOnSubmit(activity);
            up1.SubmitChanges();

            Response.Redirect("compaint_list.aspx");
        }
コード例 #2
0
        protected void LinkButton1_Click(object sender, EventArgs e)
        {
            String  id  = Session["id"].ToString();
            decimal dec = System.Convert.ToDecimal(id);

            string struserid = Session["UserID"].ToString();

            Session["check"]   = 1;
            Session["subject"] = "complaint";
            Session["subject"] = "complaint";
            Session["to"]      = "hh";
            Session["date"]    = DateTime.Now.ToString();
            Session["channel"] = "";
            Session["problem"] = "";
            Session["system"]  = "";
            Session["module"]  = "";
            int    actvity_id = System.Convert.ToInt16(activity.SelectedItem.Value);
            string des        = TextBox1.Text;
            string time       = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

            databaseDataContext data = new databaseDataContext();


            RefActivityDetail obj = new RefActivityDetail
            {
                complaint_id          = dec,
                ActivityID            = actvity_id,
                Activity_description  = des,
                Activity_time         = System.Convert.ToDateTime(time),
                Activity_performed_by = struserid
            };

            data.RefActivityDetails.InsertOnSubmit(obj);

            RefComplaint obj11 = data.RefComplaints.Single(c => c.complaint_id.Equals(dec));



            if (actvity_id.Equals(2) || actvity_id.Equals(10) || actvity_id.Equals(12))
            {
                obj11.status = "Close";
            }
            else
            {
                obj11.status = "Open";
            }



            obj11.ActivityID = actvity_id;
            obj11.Assigne_to = struserid;
            data.SubmitChanges();



            SendEmail();
        }
コード例 #3
0
        protected void LinkButton1_Click(object sender, EventArgs e)
        {
            String  id         = Session["id"].ToString();
            decimal dec        = System.Convert.ToDecimal(id);
            int     actvity_id = System.Convert.ToInt16(activity.SelectedItem.Value);
            string  des        = TextBox1.Text;
            string  time       = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");


            databaseDataContext data = new databaseDataContext();


            RefActivityDetail obj = new RefActivityDetail
            {
                complaint_id          = dec,
                ActivityID            = actvity_id,
                Activity_description  = des,
                Activity_time         = System.Convert.ToDateTime(time),
                Activity_performed_by = "Mohsin"
            };

            data.RefActivityDetails.InsertOnSubmit(obj);

            RefComplaint obj11 = data.RefComplaints.Single(c => c.complaint_id.Equals(dec));



            if (actvity_id.Equals(2) || actvity_id.Equals(10) || actvity_id.Equals(12))
            {
                obj11.status = "Close";
            }
            else
            {
                obj11.status = "Open";
            }



            obj11.ActivityID = actvity_id;
            //obj11.Assigne_to = assinge_to.SelectedItem.Text;
            data.SubmitChanges();
            Response.Redirect("validation_resolve.aspx");
        }