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