protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { /* //Get the LinkButton control in the first cell LinkButton _doubleClickButton = (LinkButton)e.Row.Cells[0].Controls[0].FindControl("CaseDoubleClick"); //Get the javascript which is assigned to this LinkButton string _jsDouble = ClientScript.GetPostBackClientHyperlink(_doubleClickButton, ""); //Add this JavaScript to the ondblclick Attribute of the row e.Row.Attributes["ondblclick"] = _jsDouble; */ //if (!String.IsNullOrEmpty(e.Row.Cells[7].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[7].Text); // e.Row.Cells[7].Text = workstatus(num); // e.Row.Cells[7].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[8].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[8].Text); // e.Row.Cells[8].Text = workstatus(num); // e.Row.Cells[8].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[9].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[9].Text); // e.Row.Cells[9].Text = workstatus(num); // e.Row.Cells[9].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[10].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[10].Text); // e.Row.Cells[10].Text = workstatus(num); // e.Row.Cells[10].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[11].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[11].Text); // e.Row.Cells[11].Text = workstatus(num); // e.Row.Cells[11].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[12].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[12].Text); // e.Row.Cells[12].Text = workstatus(num); // e.Row.Cells[12].BackColor = statusColor(num); //} //Response.Write(e.Row.Cells[8].Text +"c8"); //Response.Write(e.Row.Cells[9].Text +"c9"); //the checked box item //if (showtechnote.Checked == false) // GridView1.Columns[9].Visible = false; //else if (showtechnote.Checked == true) // GridView1.Columns[9].Visible = true; //if (showsales.Checked == false) // GridView1.Columns[7].Visible = false; //else if (showsales.Checked == true) // GridView1.Columns[7].Visible = true; //if (showsupportteam.Checked == false) // GridView1.Columns[8].Visible = false; //else if (showsupportteam.Checked == true) // GridView1.Columns[8].Visible = true; //if (showinstruction.Checked == false) // GridView1.Columns[10].Visible = false; //else if (showinstruction.Checked == true) // GridView1.Columns[10].Visible = true; //if (showfaq.Checked == false) // GridView1.Columns[11].Visible = false; //else if (showfaq.Checked == true) // GridView1.Columns[11].Visible = true; //if (showallcompany.Checked == false) // GridView1.Columns[12].Visible = false; //else if (showallcompany.Checked == true) // GridView1.Columns[12].Visible = true; //if (showother.Checked == false) // GridView1.Columns[13].Visible = false; //else if (showother.Checked == true) // GridView1.Columns[13].Visible = true; //Response.Write(e.Row.Cells[1].Text); string QueryString = "~/Detail/DetailCase2.aspx?id=" + e.Row.Cells[1].Text; string NavigateURL = ResolveUrl(QueryString); e.Row.Attributes.Add("onClick", string.Format("window.open('{0}')", NavigateURL)); e.Row.Style.Add("cursor", "pointer"); try { Support support = new Support(); Support personnel = new Support(); int rid = Convert.ToInt32(e.Row.Cells[1].Text); var cases = from c in support.Incidents where c.id == rid select new { c.allcompany, c.model, c.description, c.enddate, c.faq, c.instruction, c.lastupdatedate, c.other, c.reportdate, c.sales, c.supportteam, c.technote, c.handler, c.drafter, c.parent, }; //description if (cases.FirstOrDefault().description != null) { //if (Encoding.GetEncoding("utf-8").GetBytes(cases.FirstOrDefault().description).Length > 30) //{ // e.Row.Cells[3].Text = cases.FirstOrDefault().description.Substring(0, 30) + "..."; //} } if (cases.FirstOrDefault().model != null) { //interface and cord using (Support mod = new Support()) { var par = (from c in support.Incidents where c.id == cases.FirstOrDefault().parent select c).FirstOrDefault(); if (par != null) { using (Support s = new Support()) { int par_mod = par.model.Value; var target = (from x in s.models where x.id == par_mod select x).FirstOrDefault(); var ca = (from c in s.Incidents where c.id == rid select c).FirstOrDefault(); if (ca.model != par_mod) { ca.model = par_mod; s.SaveChanges(); } } } System.Web.UI.WebControls.Image img = e.Row.FindControl("ImageInterface") as System.Web.UI.WebControls.Image; var option = (from o in support.models where o.id == cases.FirstOrDefault().model select o).FirstOrDefault(); utils u = new utils(); img.ImageUrl = u.interfaceUntil(option._interface); Label lbCord = e.Row.FindControl("TextBoxCord") as Label; lbCord.Text = option.cord; } } //drafter List<int> all_person = (from x in personnel.people select x.id).ToList(); if (!all_person.Contains(Convert.ToInt32(cases.FirstOrDefault().drafter.ToString()))) { e.Row.Cells[5].Text = "No drafter..."; } else { int d = cases.FirstOrDefault().drafter; var p_query = from p in personnel.people where p.id == d select p; e.Row.Cells[5].Text = p_query.FirstOrDefault().lastname + " " + p_query.FirstOrDefault().firstname; } //report //all company if (cases.FirstOrDefault().allcompany == 1) { (e.Row.Cells[6].FindControl("list_allcompany") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_allcompany") as Label).ForeColor = statusColor(1); } else if (cases.FirstOrDefault().allcompany == 2) { (e.Row.Cells[6].FindControl("list_allcompany") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_allcompany") as Label).ForeColor = statusColor(2); } //all company if (cases.FirstOrDefault().sales == 1) { (e.Row.Cells[6].FindControl("list_sales") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_sales") as Label).ForeColor = statusColor(1); } else if (cases.FirstOrDefault().sales == 2) { (e.Row.Cells[6].FindControl("list_sales") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_sales") as Label).ForeColor = statusColor(2); } //instruction if (cases.FirstOrDefault().instruction == 1) { (e.Row.Cells[6].FindControl("list_instruction") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_instruction") as Label).ForeColor = statusColor(1); } else if (cases.FirstOrDefault().instruction == 2) { (e.Row.Cells[6].FindControl("list_instruction") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_instruction") as Label).ForeColor = statusColor(2); } //tech note if (cases.FirstOrDefault().technote == 1) { (e.Row.Cells[6].FindControl("list_technote") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_technote") as Label).ForeColor = statusColor(1); } else if (cases.FirstOrDefault().technote == 2) { (e.Row.Cells[6].FindControl("list_technote") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_technote") as Label).ForeColor = statusColor(2); } //support team if (cases.FirstOrDefault().supportteam == 1) { (e.Row.Cells[6].FindControl("list_supportteam") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_supportteam") as Label).ForeColor = statusColor(1); } else if (cases.FirstOrDefault().supportteam == 2) { (e.Row.Cells[6].FindControl("list_supportteam") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_supportteam") as Label).ForeColor = statusColor(2); } //faq if (cases.FirstOrDefault().faq == 1) { (e.Row.Cells[6].FindControl("list_faq") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_faq") as Label).ForeColor = statusColor(1); } else if (cases.FirstOrDefault().faq == 2) { (e.Row.Cells[6].FindControl("list_faq") as Label).Visible = true; (e.Row.Cells[6].FindControl("list_faq") as Label).ForeColor = statusColor(2); } if(cases.FirstOrDefault().enddate > cases.FirstOrDefault().reportdate) { e.Row.BorderStyle = BorderStyle.Solid; e.Row.BorderColor = Color.DarkGray; } //if (!String.IsNullOrEmpty(e.Row.Cells[8].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[8].Text); // e.Row.Cells[8].Text = workstatus(num); // e.Row.Cells[8].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[9].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[9].Text); // e.Row.Cells[9].Text = workstatus(num); // e.Row.Cells[9].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[10].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[10].Text); // e.Row.Cells[10].Text = workstatus(num); // e.Row.Cells[10].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[11].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[11].Text); // e.Row.Cells[11].Text = workstatus(num); // e.Row.Cells[11].BackColor = statusColor(num); //} //if (!String.IsNullOrEmpty(e.Row.Cells[12].Text)) //{ // int num = Convert.ToInt32(e.Row.Cells[12].Text); // e.Row.Cells[12].Text = workstatus(num); // e.Row.Cells[12].BackColor = statusColor(num); /* //handler List<int> all_members = (from x in personnel.members select x.id).ToList(); if (cases.FirstOrDefault().handler != null) { if (!all_members.Contains(Convert.ToInt32(cases.FirstOrDefault().handler.ToString()))) { e.Row.Cells[7].Text = "No handler"; } else { int mem = Convert.ToInt32(cases.FirstOrDefault().handler.ToString()); var m_query = from me in personnel.people join m in personnel.members on me.id equals m.person where m.id == mem select me; e.Row.Cells[7].Text = m_query.FirstOrDefault().lastname + " " + m_query.FirstOrDefault().firstname; ; } } else { e.Row.Cells[7].Text = "No handler..."; } */ ////files //List<int> all_files = (from x in support.Files select x.incident).ToList(); //if (!all_files.Contains(Convert.ToInt32(rid))) //{ // e.Row.Cells[14].Text = "No attachment"; //} //else //{ // var f_query = from f in support.Files // where f.incident == rid // select f.name; // e.Row.Cells[14].Text = f_query.FirstOrDefault().ToString(); //} //action if (!actnum.ContainsKey(Convert.ToInt32(rid))) { e.Row.Cells[7].Text = "N/A"; } else { e.Row.Cells[7].Text = actnum[rid].ToString(); } e.Row.Cells[1].Visible = false; } catch (Exception ex) { Response.Write(ex); } } if (e.Row.RowType == DataControlRowType.Header) { e.Row.Cells[1].Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] != null) { string decoded_username = Encoding.UTF8.GetString(MachineKey.Unprotect(Convert.FromBase64String(Request.Cookies["user"]["username"]), "ProtectCookieUsername")); string decoded_role = Encoding.UTF8.GetString(MachineKey.Unprotect(Convert.FromBase64String(Request.Cookies["user"]["role"]), "ProtectCookieRole")); if (decoded_role == "admin") { } else { Response.Redirect("~/"); } } else { Response.Redirect("~/"); } if (!String.IsNullOrEmpty(Request.QueryString["id"])) { id = Convert.ToInt32(Request.QueryString["id"]); } int isNew = Convert.ToInt32(Request.QueryString["new"]); if (!IsPostBack) { if (isNew == 1) { model NewModel = new model() { _interface=1, cord = "this is a new item" }; Support s = new Support(); s.models.Add(NewModel); s.SaveChanges(); id = NewModel.id; } else { try { Support support = new Support(); var model = from m in support.models where m.id == id select new { m.name, m._interface, m.cord }; //name if (!String.IsNullOrEmpty(model.FirstOrDefault().name)) { name = model.FirstOrDefault().name.ToString(); detailmodel_name.Text = name; } else { name = "No name..."; } //cord desc = model.FirstOrDefault().cord.ToString(); detailmodel_cord.Text = desc; utils u = new utils(); //interface detailmodel_interface.Text = u.interfaceUntil(model.FirstOrDefault()._interface); } catch (Exception ex) { Response.Write(ex); } using (Support s = new Support()) { var target = (from x in s.models where x.id == id select x).FirstOrDefault(); detailmodel_interface.SelectedValue = target._interface.ToString(); } } } }
//show closed protected void Default_checkbox_show_only_unclosed_CheckedChanged(object sender, EventArgs e) { if (Default_checkbox_show_only_unclosed.Checked) { utils u = new utils(); SqlDataSource1.SelectCommand = u.caselistquery + " WHERE reportdate = enddate" + " order by sort"; //Response.Write(SqlDataSource1.SelectCommand.ToString()); GridView1.DataBind(); } else if (!Default_checkbox_show_only_unclosed.Checked) { GridView1.DataBind(); } }