//copy gridview process panel to another gridview protected void ButtonGenP_Click(object sender, EventArgs e) { DataTable dt1 = new DataTable(); dt1.Columns.Add("Process Size [kB]", typeof(string)); foreach (GridViewRow gvr in GVProcesses.Rows) { string var1 = gvr.Cells[0].Text; DataRow dr = dt1.NewRow(); dr["Process Size [kB]"] = var1; dt1.Rows.Add(dr); } GridView7.DataSource = dt1; GridView7.DataBind(); GridView10.DataSource = null; GridView10.DataBind(); GVProcesses.DataSource = null; GVProcesses.DataBind(); DropDownList2.Items.Clear(); txtNoProcesses.Text = ""; txtProcessSize.Text = ""; }
//Process Creation protected void btnAddProcess_Click(object sender, EventArgs e) { int i = 0; DropDownList2.Items.Clear(); DataTable dt = new DataTable(); dt.Columns.Add("Process Size [kB]", typeof(int)); for (i = 0; i < Convert.ToInt32(txtNoProcesses.Text); i++) { dt.Rows.Add(0); //Add row to gridview DropDownList2.Items.Add(new ListItem("P" + Convert.ToString(i + 1), Convert.ToString(i + 1))); //List Item value starts from 1 } numberOfProcesses = Convert.ToInt32(txtNoProcesses.Text); GVProcesses.DataSource = dt; GVProcesses.DataBind(); GridView10.DataSource = dt; GridView10.DataBind(); }
protected void GridView10_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView theGrid = sender as GridView; // refer to the GridView int newPageIndex = 0; if (-2 == e.NewPageIndex) { TextBox txtNewPageIndex = null; GridViewRow pagerRow = GridView10.BottomPagerRow; if (null != pagerRow) { txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); // refer to the TextBox with the NewPageIndex value } if (null != txtNewPageIndex && txtNewPageIndex.Text != "") { newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex } } else { newPageIndex = e.NewPageIndex; } GridView10.DataSource = dp.GetAuditSuggest(new Guid(PPID.Text)); GridView10.DataBind(); newPageIndex = newPageIndex < 0 ? 0 : newPageIndex; newPageIndex = newPageIndex >= GridView10.PageCount ? GridView10.PageCount - 1 : newPageIndex; GridView10.PageIndex = newPageIndex; GridView10.DataBind(); }
protected void Button10_Click(object sender, EventArgs e) { string connectionString = ConfigurationManager.ConnectionStrings["conStr"].ToString(); SqlConnection con = new SqlConnection(connectionString); try { con.Open(); } catch (Exception) { con.Close(); return; throw; } DataSet ds = new DataSet(); string sqlstr = "select * From Pharmacist p"; SqlDataAdapter da = new SqlDataAdapter(sqlstr, con); da.Fill(ds); GridView10.DataSource = ds; GridView10.DataBind(); con.Close(); }
protected void btnIradatInsert_Click(object sender, EventArgs e) { if (txtIradatTitle.Text != "") { Value.InsertValues(lblIradatID.Text, lblIradatValue.Text, txtIradatTitle.Text); } txtIradatTitle.Text = ""; GridView10.DataBind(); }
//Panel process Close button protected void LinkButton2_Click(object sender, EventArgs e) { GridView10.DataSource = null; GridView10.DataBind(); GVProcesses.DataSource = null; GVProcesses.DataBind(); DropDownList2.Items.Clear(); txtNoProcesses.Text = ""; txtProcessSize.Text = ""; }
protected void GridView10_RowDeleting1(object sender, GridViewDeleteEventArgs e) { int index = Convert.ToInt32(e.RowIndex); tba = (DataTable)ViewState["Detalles11"]; tba.Rows[index].Delete(); GridView10.DataSource = tba; GridView10.DataBind(); Button4_ModalPopupExtender.Show(); }
protected void Button10_Click(object sender, EventArgs e) { String query = "SELECT SUM(Order_cost) AS Total_Sales from Order_table"; SqlDataAdapter dataadapter = new SqlDataAdapter(query, conx); DataSet ds = new DataSet(); dataadapter.Fill(ds); GridView10.DataSource = ds; GridView10.DataBind(); }
protected void GridView10_Sorting(object sender, GridViewSortEventArgs e) { DataTable dataTable = GridView10.DataSource as DataTable; if (dataTable != null) { DataView dataView = new DataView(dataTable); dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection); GridView10.DataSource = dataView; GridView10.DataBind(); } }
private void View7_DataBind() { GridView10.DataBind(); GridView11.DataBind(); Chart7.DataBind(); if (Chart7.Series[0].Points.Count > 0 || Chart7.Series[1].Points.Count > 0) { Chart7.Visible = true; } else { Chart7.Visible = false; } }
protected void Button2_Click(object sender, EventArgs e) { ABE_KINISI.DataBind(); ABE_Cost.DataBind(); ABE_KINISI_WAIT.DataBind(); ABE_KINISI_WAIT_GRID.DataBind(); GridView3.DataBind(); GridView9.DataBind(); GridView1.DataBind(); GridView4.DataBind(); GridView10.DataBind(); DropDownList2.DataBind(); dele_DDL(); }
protected void btn9_Click(object sender, EventArgs e) { // Clear all content output from the buffer stream Response.ClearContent(); // Specify the default file name using "content-disposition" RESPONSE header Response.AppendHeader("content-disposition", "attachment; filename=school-admin.xls"); // Set excel as the HTTP MIME type Response.ContentType = "application/excel"; // Create an instance of stringWriter for writing information to a string System.IO.StringWriter stringWriter9 = new System.IO.StringWriter(); // Create an instance of HtmlTextWriter class for writing markup // characters and text to an ASP.NET server control output stream HtmlTextWriter htw9 = new HtmlTextWriter(stringWriter9); GridView10.RenderControl(htw9); Response.Write(stringWriter9.ToString()); Response.End(); }
void FillStatsView(SqlConnection sqlCon) { if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlDataAdapter sqlDa = new SqlDataAdapter("ViewFamilyStats", sqlCon); sqlDa.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDa.SelectCommand.Parameters.AddWithValue("@TreeID", Session["CurMemberTreeID"]); DataTable dtbl = new DataTable(); sqlDa.Fill(dtbl); GridView10.DataSource = dtbl; GridView10.DataBind(); }
protected void GridView8_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "show") { int rowindex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex; s = Convert.ToInt32(GridView8.DataKeys[rowindex].Value); GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer); string check = (row.FindControl("type") as Label).Text.Trim(); DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.SurveyQuestion q1 = new Entities.SurveyQuestion() { surveyId = s, }; DataSet ds = new DataSet(); ds = db.ShowSurvey(q1); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { if (check == "Yes/No") { GridView9.DataSource = ds; GridView9.DataBind(); Page.ClientScript.RegisterStartupScript(GetType(), "id", "sShowSurveyPop()", true); Panel4.Visible = true; Panel3.Visible = false; } else if (check == "Rating") { GridView10.DataSource = ds; GridView10.DataBind(); Page.ClientScript.RegisterStartupScript(GetType(), "id", "sShowSurveyPop()", true); Panel4.Visible = false; Panel3.Visible = true; } } else { Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('ShowSurvey')", true); } } }
protected void Button26_Click(object sender, EventArgs e) { GridView10.DataSource = null; GridView10.DataBind(); MySqlConnection con = new MySqlConnection("server=localhost;user id=root;persistsecurityinfo=True;database=test_db;password=somoslossuper11"); con.Open(); MySqlCommand cmd = new MySqlCommand("call Act_x_Proyecto_y_empleados()", con); MySqlDataAdapter adp = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); adp.Fill(ds); GridView10.DataSource = ds; GridView10.DataBind(); cmd.Dispose(); con.Close(); }
protected void Button3_Click(object sender, EventArgs e) { if (DropDownList2.Items.Count <= 1 || DropDownList2.SelectedValue == "10000000") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Δεν έχει γίνει επιλογή !!!!');", true); } else { txbID_Res.Text = GridView9.Rows[0].Cells[18].Text; ABE_KINISI_WAIT_GRID.Update(); ABE_KINISI_WAIT_GRID.DataBind(); ABE_KINISI_WAIT_List.DataBind(); DropDownList2.DataBind(); GridView10.DataBind(); LnkFocus.Focus(); } }
protected void Page_Load(object sender, EventArgs e) { // Image1.Visible = false; // Label2.Visible = false; Button1.Visible = false; conn.Open(); cmd = new SqlCommand("select * from CartDetail Where Email ='" + Session["UID"].ToString() + "' ", conn); dr = cmd.ExecuteReader(); if (dr.HasRows == true) { GridView10.DataSource = dr; GridView10.DataBind(); Button1.Visible = true; } else { //Image1.Visible = true; //Label2.Visible = true; } dr.Dispose(); conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["U_name"] == null) { Response.Redirect("AdminLogin.aspx"); } else { CompletelyChngedCode(); SqlDataAdapter da11 = new SqlDataAdapter("select CityName As [Name],Pro1 As [P1],Pro2 As [P2],Pro3 As [P3],Pro4 As [P4],Pro5 As [P5],Pro6 As [P6],Pro7 As [P7],Pro8 As [P8],Pro9 As [P9],Pro10 As [P10],Pro11 As [P11],Pro12 As [P12],ProTotal As [Total] from tbl_CompltChange", con); DataSet ds11 = new DataSet(); da11.Fill(ds11, "tbl_CompltChange"); GridView1.DataSource = ds11; GridView1.DataBind(); Getcountofmainpage(); SqlDataAdapter da9 = new SqlDataAdapter("select CityName as [City],VisitorsCnt as [Total Visitors] from tbl_CompltChangeMainPageCount order by VisitorsCnt Desc", con); DataSet ds9 = new DataSet(); da9.Fill(ds9, "tbl_CompltChangeMainPageCount"); GridView12.DataSource = ds9; GridView12.DataBind(); GetcountofmainAndproductpage(); SqlDataAdapter da10 = new SqlDataAdapter("select CityName as [City],VisitorsCnt as [Total Visitors] from tbl_CompltChangeMainAndProductPageCount order by VisitorsCnt Desc", con); DataSet ds10 = new DataSet(); da10.Fill(ds10, "tbl_CompltChangeMainAndProductPageCount"); GridView10.DataSource = ds10; GridView10.DataBind(); } } catch (Exception) { } }
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList2.SelectedValue != "10000000") { ABE_KINISI.DataBind(); ABE_Cost.DataBind(); ABE_KINISI_WAIT.DataBind(); ABE_KINISI_WAIT_GRID.DataBind(); GridView3.DataBind(); GridView9.DataBind(); GridView1.DataBind(); GridView4.DataBind(); GridView10.DataBind(); dele_DDL(); ShowDDL(); GridView10.SelectedIndex = -1; GridView10.DataBind(); if (GridView9.Rows[0].Cells[5].Text == "6" || GridView9.Rows[0].Cells[5].Text == "7" || GridView9.Rows[0].Cells[5].Text == "8") { Dis_Area(); TextBox121.Text = GridView9.Rows[0].Cells[9].Text; TextBox133.Text = GridView9.Rows[0].Cells[10].Text; TextBox121.BackColor = System.Drawing.ColorTranslator.FromHtml("#006600"); TextBox125.BackColor = System.Drawing.ColorTranslator.FromHtml("#006600"); TextBox133.BackColor = System.Drawing.ColorTranslator.FromHtml("#006600"); TextBox134.BackColor = System.Drawing.ColorTranslator.FromHtml("#006600"); } else { Enab_Area(); } } }
protected void TransactionDetails_Click(object sender, EventArgs e) { string invoiceID = TextBox17.Text; Label41.Text = string.Empty; Label42.Text = string.Empty; SqlDataSource1.SelectParameters.Clear(); SqlDataSource1.SelectParameters.Add("invoiceID", invoiceID); SqlDataSource1.SelectCommand = "SELECT date_time, totalSales, payment_method, CASE WHEN home_delivery = 1 THEN 'Yes' ELSE 'No' END AS home_delivery from INVOICE WHERE(@invoiceID IS NULL OR COALESCE(invoiceID, '') = @invoiceID)"; SqlDataSource1.CancelSelectOnNullParameter = false; if (invoiceID == "") { Label41.Text = "Please enter a Transaction ID."; } else { GridView9.DataSource = SqlDataSource1; GridView9.DataBind(); if (GridView9.Rows.Count == 0) { Label41.Text = "Transaction not found."; Label42.Text = string.Empty; GridView10.DataSource = null; GridView10.DataBind(); } else { Label42.Text = "Products Sold:"; SqlDataSource1.SelectCommand = "SELECT pro_ID, invoiceDetail.quantity, priceSold, name from invoiceDetail, Product WHERE(@InvoiceID IS NULL OR COALESCE(Inv_ID, '') = @invoiceID) AND product.productID = invoiceDetail.Pro_ID"; GridView10.DataSource = SqlDataSource1; GridView10.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(CS); con.Open(); Label1.Text = "All info about the employee with ID 8"; SqlCommand cmd1 = new SqlCommand("select * from employees where EmployeeID=8", con); GridView1.DataSource = cmd1.ExecuteReader(); GridView1.DataBind(); con.Close(); con.Open(); Label2.Text = "The list of first and last names of the employees from London"; SqlCommand cmd2 = new SqlCommand("select FirstName,LastName from employees where City='London'", con); GridView2.DataSource = cmd2.ExecuteReader(); GridView2.DataBind(); con.Close(); con.Open(); Label3.Text = "The list of first and last names of the employees whose first name begins with letter A"; SqlCommand cmd3 = new SqlCommand("select FirstName,LastName from employees where FirstName like 'A%' ", con); GridView3.DataSource = cmd3.ExecuteReader(); GridView3.DataBind(); con.Close(); con.Open(); Label4.Text = "The list of first, last names and ages of the employees whose age is greater than 55. The result should be sorted by last name"; SqlCommand cmd4 = new SqlCommand("select FirstName,LastName ,(CURRENT_TIMESTAMP-BirthDate)as ages from employees where (CURRENT_TIMESTAMP-BirthDate) > 55 order by LastName", con); GridView4.DataSource = cmd4.ExecuteReader(); GridView4.DataBind(); con.Close(); con.Open(); Label5.Text = "The count of employees from London"; SqlCommand cmd5 = new SqlCommand("select count(*) from employees where city='London'", con); GridView5.DataSource = cmd5.ExecuteReader(); GridView5.DataBind(); con.Close(); con.Open(); Label6.Text = "The greatest, the smallest and the average age among the employees from London"; SqlCommand cmd6 = new SqlCommand(" SELECT city,CONVERT(datetime,avg(CONVERT(INT, BirthDate)))as AVG,CONVERT(datetime,max(CONVERT(INT, BirthDate)))as MAX,CONVERT(datetime,min(CONVERT(INT, BirthDate)))as MIN from employees where city='London' group by city", con); GridView6.DataSource = cmd6.ExecuteReader(); GridView6.DataBind(); con.Close(); con.Open(); Label7.Text = "The greatest, the smallest and the average age of the employees for each city"; SqlCommand cmd7 = new SqlCommand(" SELECT CONVERT(datetime,avg(CONVERT(INT, BirthDate)))as AVG,CONVERT(datetime,max(CONVERT(INT, BirthDate)))as MAX,CONVERT(datetime,min(CONVERT(INT, BirthDate)))as MIN from employees", con); GridView7.DataSource = cmd7.ExecuteReader(); GridView7.DataBind(); con.Close(); con.Open(); Label8.Text = "The greatest, the smallest and the average age of the employees for each city"; SqlCommand cmd8 = new SqlCommand(" SELECT CONVERT(datetime,avg(CONVERT(INT, BirthDate)))as AVG,CONVERT(datetime,max(CONVERT(INT, BirthDate)))as MAX,CONVERT(datetime,min(CONVERT(INT, BirthDate)))as MIN from employees", con); GridView8.DataSource = cmd8.ExecuteReader(); GridView8.DataBind(); con.Close(); con.Open(); Label9.Text = "First, last names and dates of birth of the employees who celebrate their birthdays this month"; SqlCommand cmd9 = new SqlCommand("select FirstName,LastName,BirthDate from employees where MONTH(BirthDate)=MONTH(GETDATE())", con); GridView9.DataSource = cmd9.ExecuteReader(); GridView9.DataBind(); con.Close(); con.Open(); Label10.Text = "First and last names of the employees who used to serve orders shipped to Madrid"; SqlCommand cmd10 = new SqlCommand("select distinct FirstName,LastName,shipcity from employees inner join orders on employees.EmployeeID=orders.EmployeeID where shipcity='Madrid'", con); GridView10.DataSource = cmd10.ExecuteReader(); GridView10.DataBind(); con.Close(); con.Open(); Label11.Text = "First and last names of the employees who used to serve orders shipped to Madrid"; SqlCommand cmd11 = new SqlCommand("select distinct FirstName,LastName,shipcity from employees inner join orders on employees.EmployeeID=orders.EmployeeID where shipcity='Madrid'", con); GridView11.DataSource = cmd11.ExecuteReader(); GridView11.DataBind(); con.Close(); con.Open(); Label12.Text = "The count of orders made by each customer from France"; SqlCommand cmd12 = new SqlCommand("select count(*) from orders inner join customers on orders.shipcountry = customers.country where customers.country='France'", con); GridView12.DataSource = cmd12.ExecuteReader(); GridView12.DataBind(); con.Close(); con.Open(); Label13.Text = "The list of french customers’ names who used to order non-french products"; SqlCommand cmd13 = new SqlCommand("select distinct ContactName from Customers left join Orders on Customers.country <> Orders.ShipCountry where country='France'", con); GridView13.DataSource = cmd13.ExecuteReader(); GridView13.DataBind(); con.Close(); con.Open(); Label14.Text = "The total ordering sum calculated for each country of customer"; SqlCommand cmd14 = new SqlCommand("select count(orders.shipcountry),customers.country from orders inner join customers on orders.shipcountry=customers.country group by customers.country", con); GridView14.DataSource = cmd14.ExecuteReader(); GridView14.DataBind(); con.Close(); con.Open(); Label15.Text = "The list of cities where employees and customers are from and where orders have been made to. Duplicates should be eliminated."; SqlCommand cmd15 = new SqlCommand("SELECT distinct Orders.shipcity FROM((Orders INNER JOIN Customers ON Orders.shipcity = Customers.city) INNER JOIN employees ON Orders.shipcity = employees.city)", con); GridView15.DataSource = cmd15.ExecuteReader(); GridView15.DataBind(); con.Close(); }
protected void Button1_Click(object sender, EventArgs e) { if (DropDownList2.Items.Count <= 1 || DropDownList2.SelectedValue == "10000000") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Ελλιπή Στοιχεία !!!!');", true); } else { if (CheckBox1.Checked) { TextBox131.Text = TextBox8.Text + " " + DateTime.Now.ToString("HH:mm:ss"); } else { TextBox131.Text = DateTime.Now.ToString(); } if (FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isotimia() != 0 && FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isot_Mina() == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(' Δεν έχει ορισθεί Ισοτιμία για τον μήνα');", true); } else { if (TextBox128.Text == "1") { if (GridView4.Rows.Count > 0) { TextBox127.Text = ((Convert.ToDecimal(GridView4.Rows[0].Cells[0].Text))).ToString(); } } else { TextBox127.Text = "0.00"; } TextBox12.Text = DateTime.Parse(TextBox124.Text).Year.ToString(); TextBox11.Text = DateTime.Parse(TextBox124.Text).Month.ToString(); int Etos_Y = DateTime.Parse(TextBox124.Text).Year; TextBox9.Text = GridView9.Rows[0].Cells[17].Text; TextBox2.Text = GridView9.Rows[0].Cells[16].Text; TextBox10.Text = FINANCIAL_MANAGEMENT.App_Code.xrisi.XrisiTR(Etos_Y).ToString(); if (DropDownList2.SelectedValue == "10000000" || DropDownList2.SelectedValue == "0") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Λάθος Επιλογή !!!!');", true); } else if ((Convert.ToDecimal(GridView1.Rows[0].Cells[0].Text)) - Convert.ToDecimal(TextBox121.Text) != 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Δεν έχουν επιλεγεί σωστά ένσημα. Απαιτούμενο ποσό : € " + (Convert.ToDecimal(GridView1.Rows[0].Cells[0].Text)) + " !!! ');", true); } else { if (GridView9.Rows[0].Cells[5].Text == "1" || GridView9.Rows[0].Cells[5].Text == "2" || GridView9.Rows[0].Cells[5].Text == "3" || GridView9.Rows[0].Cells[5].Text == "4" || GridView9.Rows[0].Cells[5].Text == "5") { Kin_Logariasmon.Insert(); ABE_KINISI.Insert(); GridView2.DataBind(); Fill_Textbox(); Arithmos_ABE(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Αριθμός ΑΒΕ : " + Convert.ToString(Session["ABE_NUMBER"]) + " / " + Etos_Y + " ');window.open('Tameio.aspx','_self');", true); } if (GridView9.Rows[0].Cells[5].Text == "6") { Kin_Logariasmon.Insert(); Visa_kinisi.Insert(); } if (GridView9.Rows[0].Cells[5].Text == "7") { TextBox121.Text = "5"; TextBox127.Text = (Convert.ToDecimal(TextBox121.Text) * FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isot_Mera(Convert.ToDateTime(TextBox8.Text).ToString("yyyy-MM-dd"))).ToString(); Kin_Logariasmon.Insert(); ABE_KINISI_WAIT_GRID.Insert(); Pass_kinisi.Insert(); Arithmos_ABE(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Αριθμός ΑΒΕ : " + Convert.ToString(Session["ABE_NUMBER"]) + " / " + Etos_Y + " ');window.open('Tameio.aspx','_self');", true); } if (GridView9.Rows[0].Cells[5].Text == "8") { Kin_Logariasmon.Insert(); FET_kinisi.Insert(); } ABE_KINISI_WAIT.Delete(); FINANCIAL_MANAGEMENT.App_Code.xrisi.Update_Reserv_Status(Convert.ToInt32(GridView9.Rows[0].Cells[18].Text), 4); } } Ypoloipo_Ensimwn.DataBind(); ABE_KINISI.DataBind(); ABE_Cost.DataBind(); ABE_KINISI_WAIT.DataBind(); ABE_KINISI_WAIT_List.DataBind(); ABE_KINISI_WAIT_GRID.DataBind(); GridView3.DataBind(); GridView9.DataBind(); GridView1.DataBind(); GridView4.DataBind(); GridView10.DataBind(); } }
protected void grdvw_List_RowEditing(object sender, GridViewEditEventArgs e) { strSelectedId = grdvw_List.Rows[e.NewEditIndex].Cells[1].Text; txt_ItemName.Text = grdvw_List.Rows[e.NewEditIndex].Cells[2].Text; if (grdvw_List.Rows[e.NewEditIndex].Cells[2].Text.Trim() != " ") { txt_AccessTime.Text = grdvw_List.Rows[e.NewEditIndex].Cells[4].Text; } else { txt_AccessTime.Text = ""; } txt_person0.Text = grdvw_List.Rows[e.NewEditIndex].Cells[3].Text; txt_ItemName.ReadOnly = true; txt_person0.ReadOnly = true; //备注绑定 //项目接收备注显示 string remarkstr = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='1' order by t_Y_Detail.id"; DataSet ds_Remark1 = new MyDataOp(remarkstr).CreateDataSet(); string strtemp = "select Name,UserID from t_R_UserInfo"; DataSet ds_User = new MyDataOp(strtemp).CreateDataSet(); foreach (DataRow dr in ds_Remark1.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView1.DataSource = ds_Remark1; GridView1.DataBind(); string remarkstr2 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='2' order by t_Y_Detail.id"; DataSet ds_Remark2 = new MyDataOp(remarkstr2).CreateDataSet(); foreach (DataRow dr in ds_Remark2.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView2.DataSource = ds_Remark2; GridView2.DataBind(); string remarkstr3 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='3' order by t_Y_Detail.id"; DataSet ds_Remark3 = new MyDataOp(remarkstr3).CreateDataSet(); foreach (DataRow dr in ds_Remark3.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView3.DataSource = ds_Remark3; GridView3.DataBind(); string remarkstr4 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='4' order by t_Y_Detail.id"; DataSet ds_Remark4 = new MyDataOp(remarkstr4).CreateDataSet(); foreach (DataRow dr in ds_Remark4.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView4.DataSource = ds_Remark4; GridView4.DataBind(); string remarkstr5 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='5' order by t_Y_Detail.id"; DataSet ds_Remark5 = new MyDataOp(remarkstr5).CreateDataSet(); foreach (DataRow dr in ds_Remark5.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView5.DataSource = ds_Remark5; GridView5.DataBind(); string remarkstr6 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='6' order by t_Y_Detail.id"; DataSet ds_Remark6 = new MyDataOp(remarkstr6).CreateDataSet(); foreach (DataRow dr in ds_Remark6.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView6.DataSource = ds_Remark6; GridView6.DataBind(); string remarkstr7 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='7' order by t_Y_Detail.id"; DataSet ds_Remark7 = new MyDataOp(remarkstr7).CreateDataSet(); foreach (DataRow dr in ds_Remark7.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView7.DataSource = ds_Remark7; GridView7.DataBind(); string remarkstr8 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='8' order by t_Y_Detail.id"; DataSet ds_Remark8 = new MyDataOp(remarkstr8).CreateDataSet(); foreach (DataRow dr in ds_Remark8.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView8.DataSource = ds_Remark8; GridView8.DataBind(); string remarkstr9 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='9' order by t_Y_Detail.id"; DataSet ds_Remark9 = new MyDataOp(remarkstr9).CreateDataSet(); foreach (DataRow dr in ds_Remark9.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView9.DataSource = ds_Remark9; GridView9.DataBind(); string remarkstr10 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='10' order by t_Y_Detail.id"; DataSet ds_Remark10 = new MyDataOp(remarkstr10).CreateDataSet(); foreach (DataRow dr in ds_Remark10.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView10.DataSource = ds_Remark10; GridView10.DataBind(); string remarkstr11 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='11' order by t_Y_Detail.id"; DataSet ds_Remark11 = new MyDataOp(remarkstr11).CreateDataSet(); foreach (DataRow dr in ds_Remark11.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView11.DataSource = ds_Remark11; GridView11.DataBind(); string remarkstr12 = "select CreateDate 备注时间,bz 备注及意见,userid 用户名 from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='12' order by t_Y_Detail.id"; DataSet ds_Remark12 = new MyDataOp(remarkstr12).CreateDataSet(); foreach (DataRow dr in ds_Remark12.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView12.DataSource = ds_Remark12; GridView12.DataBind(); //备注绑定 //有回退的,则显示回退备注,非回退,不显示 string backremarkstr = "select createdate 备注时间,t_Y_BackInfo.remark 备注及意见,userid 用户名 from t_Y_BackInfo inner join t_Y_FlowInfo on t_Y_BackInfo.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_BackInfo.functionid where t_Y_BackInfo.itemid='" + strSelectedId + "' and t_Y_BackInfo.functionid='14' order by t_Y_BackInfo.id"; // string backremarkstr = "select * from t_Y_BackInfo where itemid='" + strSelectedId + "' and functionid='2'"; DataSet ds_Remark_back = new MyDataOp(backremarkstr).CreateDataSet(); foreach (DataRow dr in ds_Remark_back.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView_back.DataSource = ds_Remark_back; GridView_back.DataBind(); //回退的数据编辑,显示前面的备注信息,只读 string remarkstr_now = "select ItemName 项目类型, name 阶段,CreateDate 备注时间,bz 备注及意见,userid 用户名,flag,t_Y_Detail.id from t_Y_Detail inner join t_Y_FlowInfo on t_Y_Detail.itemid=t_Y_FlowInfo.id inner join t_Y_FlowDetail on t_Y_FlowDetail.id= t_Y_Detail.statusid where t_Y_Detail.itemid='" + strSelectedId + "' and t_Y_Detail.statusid='13' order by t_Y_Detail.id"; DataSet ds_Remark_now = new MyDataOp(remarkstr_now).CreateDataSet(); foreach (DataRow dr in ds_Remark_now.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["用户名"].ToString() == drr["UserID"].ToString()) { dr["用户名"] = drr["Name"].ToString(); } } } GridView_now.DataSource = ds_Remark_now; GridView_now.DataBind(); DataRow[] dr_remark = ds_Remark_now.Tables[0].Select("flag=0"); if (dr_remark.Length > 0) { txt_Remark_now.Text = dr_remark[0][3].ToString(); SelectedId = dr_remark[0][6].ToString(); } if (ds_Remark_back.Tables[0].Rows.Count > 0) { Panel_back.Visible = true; } else { Panel_back.Visible = false; } ds_Remark1.Dispose(); ds_Remark2.Dispose(); ds_Remark3.Dispose(); ds_Remark4.Dispose(); ds_Remark5.Dispose(); ds_Remark6.Dispose(); ds_Remark7.Dispose(); ds_Remark8.Dispose(); ds_Remark9.Dispose(); ds_Remark10.Dispose(); ds_Remark11.Dispose(); ds_Remark12.Dispose(); //ds_Remark13.Dispose(); ds_Remark_back.Dispose(); ds_Remark_now.Dispose(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "showAddEdit();", true); }
protected void Button1_Click(object sender, EventArgs e) { //--------------------------------BUGS cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Bugs' " + " From Caso " + " Where categoria = 1", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData); GridView1.DataSource = (tblData); GridView1.DataBind(); //--------------------------------Mejoras cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Mejoras' " + " From Caso " + " Where categoria = 2", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData2); GridView2.DataSource = (tblData2); GridView2.DataBind(); //--------------------------------INVESTIGACIONES cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Investigaciones' " + " From Caso " + " Where categoria = 3", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData3); GridView3.DataSource = (tblData3); GridView3.DataBind(); //--------------------------------Actividades cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Actividades' " + " From Caso " + " Where categoria = 4", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData4); GridView4.DataSource = (tblData4); GridView4.DataBind(); //--------------------------------Activos cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Activos' " + " From Caso " + " Where estado = 1", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData5); GridView5.DataSource = (tblData5); GridView5.DataBind(); //--------------------------------Reactivados cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Reactivados' " + " From Caso " + " Where estado = 2", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData6); GridView6.DataSource = (tblData6); GridView6.DataBind(); //--------------------------------Cerrados cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Cerrados' " + " From Caso " + " Where estado = 3", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData7); GridView7.DataSource = (tblData7); GridView7.DataBind(); //--------------------------------Reactivados cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Resueltos' " + " From Caso " + " Where estado = 4", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData8); GridView8.DataSource = (tblData8); GridView8.DataBind(); //--------------------------------Criticos cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos Criticos' " + " From Caso " + " Where prioridad = 1", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData9); GridView9.DataSource = (tblData9); GridView9.DataBind(); //--------------------------------Deben Arreglarse cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos que Deben Arreglarse' " + " From Caso " + " Where prioridad = 2", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData10); GridView10.DataSource = (tblData10); GridView10.DataBind(); //--------------------------------Arreglarse si hay tiempo cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos que Deben Arreglarse si hay tiempo' " + " From Caso " + " Where prioridad = 3", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData11); GridView11.DataSource = (tblData11); GridView11.DataBind(); //--------------------------------Reactivados cn = Conexion.conectar(); cmd = new SqlCommand("Select COUNT(categoria) As 'Casos que no deben arreglarse' " + " From Caso " + " Where prioridad = 4", cn.getSqlConnection()); sda = new SqlDataAdapter(cmd); sda.Fill(tblData12); GridView12.DataSource = (tblData12); GridView12.DataBind(); }
protected void Btn_AgergarAnioRP(object sender, EventArgs e) { tba.Columns.Add("Marca"); tba.Columns.Add("Modelo"); tba.Columns.Add("Rubro"); tba.Columns.Add("ID_Rubro"); tba.Columns.Add("AnioInicio"); tba.Columns.Add("AnioFinal"); foreach (GridViewRow drow in GridView7.Rows) { DataRow dr = tba.NewRow(); dr["Marca"] = drow.Cells[0].Text.ToString(); dr["Modelo"] = drow.Cells[1].Text.ToString(); dr["Rubro"] = drow.Cells[2].Text.ToString(); dr["ID_Rubro"] = drow.Cells[3].Text.ToString(); dr["AnioInicio"] = drow.Cells[4].Text.ToString(); dr["AnioFinal"] = drow.Cells[5].Text.ToString(); tba.Rows.Add(dr); } if (DropDownList16.SelectedItem.ToString() != "") { DataRow dr = null; if (ViewState["Detalles11"] != null) { for (int i = 0; i < 1; i++) { tba = (DataTable)ViewState["Detalles11"]; if (tba.Rows.Count > 0) { dr = tba.NewRow(); // dr["ID"] = Label1.Text; dr["Marca"] = DropDownList7.SelectedItem.ToString(); dr["Modelo"] = DropDownList8.SelectedItem.ToString(); dr["Rubro"] = DropDownList10.SelectedItem.ToString(); dr["ID_Rubro"] = DropDownList10.SelectedValue.ToString(); dr["AnioInicio"] = DropDownList15.SelectedItem.ToString(); dr["AnioFinal"] = DropDownList16.SelectedItem.ToString(); tba.Rows.Add(dr); GridView10.DataSource = tba; GridView10.DataBind(); } } } else { dr = tba.NewRow(); // dr["ID"] = Label1.Text; dr["Marca"] = DropDownList7.SelectedItem.ToString(); dr["Modelo"] = DropDownList8.SelectedItem.ToString(); dr["Rubro"] = DropDownList10.SelectedItem.ToString(); dr["ID_Rubro"] = DropDownList10.SelectedValue.ToString(); dr["AnioInicio"] = DropDownList15.SelectedItem.ToString(); dr["AnioFinal"] = DropDownList16.SelectedItem.ToString(); tba.Rows.Add(dr); GridView10.DataSource = tba; GridView10.DataBind(); } ViewState["Detalles11"] = tba; GridView10.Visible = true; GridView7.Visible = false; } else { Response.Write("<script>alert('Ingrese un codigo')</script>"); } DatosP.DeleteAnioProd(Convert.ToInt32(Label8.Text)); Button4_ModalPopupExtender.Show(); }
protected void Page_Load(object sender, EventArgs e) { //create database sample //go //use sample //go //create table products (id int, name varchar(100), price int) //go //insert into products values(1, 'racecare', 10) //insert into products values (2, 'balloons', 110) //insert into products values (3, 'webcam', 12) //go //select id,name,price from products // 1.) Inital SqlConnection con = new SqlConnection("data source=CATROOM\\SQLEXPRESS; database=sample; integrated security=SSPI"); try { SqlCommand cmd = new SqlCommand("select id,name,price from products", con); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); GridView1.DataSource = sdr; GridView1.DataBind(); } catch { } finally { con.Close(); } //2.) using the using command string CS2 = "data source=CATROOM\\SQLEXPRESS; database=sample; integrated security=SSPI"; using (SqlConnection con2 = new SqlConnection(CS2)) { SqlCommand cmd2 = new SqlCommand("select id,name,price from products", con2); con2.Open(); SqlDataReader sdr = cmd2.ExecuteReader(); GridView2.DataSource = sdr; GridView2.DataBind(); } //3.) connection string in app config string CS3 = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; //Can also call by index (bad practice) //ConfigurationManager.ConnectionStrings[0]; using (SqlConnection con3 = new SqlConnection(CS3)) { SqlCommand cmd3 = new SqlCommand("select id,name,price from products", con3); con3.Open(); SqlDataReader sdr = cmd3.ExecuteReader(); GridView3.DataSource = sdr; GridView3.DataBind(); } //4.) SQL command class // ExecuteReader- use when tsql retunrs multiple rows // ExecuteNonquery- use when perform Insert/Upd/Del // ExeculateScalar- when returns single scalar value string CS4 = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; //ExecuteReader using (SqlConnection con4 = new SqlConnection(CS4)) { SqlCommand cmd4 = new SqlCommand("select id,name,price from products", con4); con4.Open(); SqlDataReader sdr = cmd4.ExecuteReader(); GridView4.DataSource = sdr; GridView4.DataBind(); } // ExeculateScalar (return single value) using (SqlConnection con5 = new SqlConnection(CS4)) { SqlCommand cmd5 = new SqlCommand("select count(*) from products", con5); con5.Open(); int count = (int)cmd5.ExecuteScalar(); Response.Write("Using ExecuteScalar total rows count= " + count.ToString()); Response.Write("<br>"); } // ExeculateNonQuery (for CRUD) using (SqlConnection con6 = new SqlConnection(CS4)) { con6.Open(); SqlCommand cmd6 = new SqlCommand("delete from products where id=4", con6); int returnValueOfRowsChanged = cmd6.ExecuteNonQuery(); // reuse cmd object cmd6 = new SqlCommand("insert into products values(4, 'boop', 121)", con6); returnValueOfRowsChanged = cmd6.ExecuteNonQuery(); Response.Write("Using ExeculateNonQuery total rows inserted= " + returnValueOfRowsChanged.ToString()); Response.Write("<br>"); } //create procedure spListProducts //@id int //as //begin //select* from products //where id = @id //end //5.) Call stored procedure (help prevent sql injection) using (SqlConnection con7 = new SqlConnection(CS4)) { SqlCommand cmd7 = new SqlCommand("spListProducts", con7); cmd7.CommandType = System.Data.CommandType.StoredProcedure; cmd7.Parameters.AddWithValue("@id", 3); con7.Open(); SqlDataReader sdr = cmd7.ExecuteReader(); GridView5.DataSource = sdr; GridView5.DataBind(); } //create procedure spListProductsOutput //@id int, //@count int out //as //begin //select @count = count(*) from products where id = @id //end //5.) Call stored procedure with output parameters using (SqlConnection con8 = new SqlConnection(CS4)) { SqlCommand cmd8 = new SqlCommand("spListProductsOutput", con8); cmd8.CommandType = System.Data.CommandType.StoredProcedure; cmd8.Parameters.AddWithValue("@id", 3); SqlParameter outputParameter = new SqlParameter(); outputParameter.ParameterName = "@count"; outputParameter.SqlDbType = System.Data.SqlDbType.Int; outputParameter.Direction = System.Data.ParameterDirection.Output; cmd8.Parameters.Add(outputParameter); con8.Open(); SqlDataReader sdr = cmd8.ExecuteReader(); con.Open(); int returnOutputValue = (int)outputParameter.Value; Response.Write("Output parameter value= " + returnOutputValue.ToString()); Response.Write("<br>"); } //6.) SQLDataReader using (SqlConnection con9 = new SqlConnection(CS4)) { SqlCommand cmd9 = new SqlCommand("select id,name,price from products", con9); con9.Open(); using (SqlDataReader sdr = cmd9.ExecuteReader()) { DataTable table = new DataTable(); table.Columns.Add("id"); table.Columns.Add("name"); table.Columns.Add("price"); table.Columns.Add("discountprice"); while (sdr.Read()) { DataRow datarow = table.NewRow(); int originalPrice = (int)sdr["price"]; double discountedPrice = originalPrice * .9; datarow["id"] = sdr["ID"]; datarow["name"] = sdr["name"]; datarow["price"] = originalPrice; datarow["discountprice"] = discountedPrice; table.Rows.Add(datarow); } GridView6.DataSource = table; GridView6.DataBind(); } } //7.) SQLDataReader NextResult using (SqlConnection con10 = new SqlConnection(CS4)) { SqlCommand cmd10 = new SqlCommand("select id,price from products;select id,name from products", con10); con10.Open(); using (SqlDataReader sdr = cmd10.ExecuteReader()) { GridView7.DataSource = sdr; GridView7.DataBind(); while (sdr.NextResult()) { GridView8.DataSource = sdr; GridView8.DataBind(); } } } //8.) SQLDataApater and DataSet using (SqlConnection con10 = new SqlConnection(CS4)) { SqlDataAdapter da = new SqlDataAdapter("select id,price,name from products", con10); DataSet ds = new DataSet(); //in memory representation of table in memory da.Fill(ds); GridView9.DataSource = ds; GridView9.DataBind(); } //create procedure spListTwoResults //as //begin //select* from products //select id from products //end //9.) DataSet in asp.net using (SqlConnection con11 = new SqlConnection(CS4)) { SqlDataAdapter da = new SqlDataAdapter("spListTwoResults", con11); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); //in memory representation of table in memory da.Fill(ds); GridView10.DataSource = ds.Tables[0]; GridView10.DataBind(); GridView11.DataSource = ds.Tables[1]; GridView11.DataBind(); } //10.) Caching dataset using (SqlConnection con11 = new SqlConnection(CS4)) { SqlDataAdapter da = new SqlDataAdapter("spListTwoResults", con11); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); //in memory representation of table in memory da.Fill(ds); GridView10.DataSource = ds.Tables[0]; GridView10.DataBind(); GridView11.DataSource = ds.Tables[1]; GridView11.DataBind(); } //Create Table tblStudents //( // ID int identity primary key, // Name nvarchar(50), // Gender nvarchar(20), // TotalMarks int //) //Insert into tblStudents values('Mark Hastings', 'Male', 900) //Insert into tblStudents values('Pam Nicholas', 'Female', 760) //Insert into tblStudents values('John Stenson', 'Male', 980) //Insert into tblStudents values('Ram Gerald', 'Male', 990) //Insert into tblStudents values('Ron Simpson', 'Male', 440) //Insert into tblStudents values('Able Wicht', 'Male', 320) //Insert into tblStudents values('Steve Thompson', 'Male', 983) //Insert into tblStudents values('James Bynes', 'Male', 720) //Insert into tblStudents values('Mary Ward', 'Female', 870) //Insert into tblStudents values('Nick Niron', 'Male', 680) //11.) CommandBuilder using (SqlConnection con11 = new SqlConnection(CS4)) { SqlDataAdapter da = new SqlDataAdapter("spListTwoResults", con11); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); //in memory representation of table in memory da.Fill(ds); GridView10.DataSource = ds.Tables[0]; GridView10.DataBind(); GridView11.DataSource = ds.Tables[1]; GridView11.DataBind(); } }//end pageload
protected void btnEmail_Click(object sender, EventArgs e) { strEmail = txtEmail.Text; DataSourceSelectArguments srUserID_IDStr = new DataSourceSelectArguments(); DataView dvUserID_IDStr = (DataView)SqlDataSource5.Select(srUserID_IDStr); if (dvUserID_IDStr.Count != 0) { strUserID_ID = dvUserID_IDStr[0][0].ToString(); } DataSourceSelectArguments srUserID_SSOStr = new DataSourceSelectArguments(); DataView dvUserID_SSOStr = (DataView)SqlDataSource14.Select(srUserID_SSOStr); if (dvUserID_SSOStr.Count != 0) { strUserID_SSO = dvUserID_SSOStr[0][0].ToString(); } DataSourceSelectArguments srTokenUser = new DataSourceSelectArguments(); DataView dvTokenUser = (DataView)SqlDataSource4.Select(srTokenUser); if (dvTokenUser.Count != 0) { strTokenUser = dvTokenUser[0][0].ToString(); } DataSourceSelectArguments srTokenPassStr = new DataSourceSelectArguments(); DataView dvTokenPassStr = (DataView)SqlDataSource12.Select(srTokenPassStr); if (dvTokenPassStr.Count != 0) { strTokenPass = dvTokenPassStr[0][0].ToString(); } DataSourceSelectArguments srOrgTempStr = new DataSourceSelectArguments(); DataView dvOrgTempStr = (DataView)SqlDataSource110.Select(srOrgTempStr); if (dvOrgTempStr.Count != 0) { strOrgTemp = dvOrgTempStr[0][0].ToString(); } DataSourceSelectArguments srOrgTempIDStr = new DataSourceSelectArguments(); DataView dvOrgTempIDStr = (DataView)SqlDataSource118.Select(srOrgTempIDStr); if (dvOrgTempIDStr.Count != 0) { strOrgTempID = dvOrgTempIDStr[0][0].ToString(); } DataSourceSelectArguments srOrgTempNameStr = new DataSourceSelectArguments(); DataView dvOrgTempNameStr = (DataView)SqlDataSource124.Select(srOrgTempNameStr); if (dvOrgTempNameStr.Count != 0) { strOrgTempName = dvOrgTempNameStr[0][0].ToString(); } DataSourceSelectArguments srOrgIDStr = new DataSourceSelectArguments(); DataView dvOrgIDStr = (DataView)SqlDataSource111.Select(srOrgIDStr); if (dvOrgIDStr.Count != 0) { strOrgID = dvOrgIDStr[0][0].ToString(); } DataSourceSelectArguments srOrgAccessRequestedStr = new DataSourceSelectArguments(); DataView dvOrgAccessRequestedStr = (DataView)SqlDataSource112.Select(srOrgAccessRequestedStr); if (dvOrgAccessRequestedStr.Count != 0) { strOrgAccessRequested = dvOrgAccessRequestedStr[0][0].ToString(); } DataSourceSelectArguments srOrgModAccessRequestedStr = new DataSourceSelectArguments(); DataView dvOrgModAccessRequestedStr = (DataView)SqlDataSource113.Select(srOrgModAccessRequestedStr); if (dvOrgModAccessRequestedStr.Count != 0) { strOrgModAccessRequested = dvOrgModAccessRequestedStr[0][0].ToString(); } DataSourceSelectArguments srOrgLicAccessRequestedStr = new DataSourceSelectArguments(); DataView dvOrgLicAccessRequestedStr = (DataView)SqlDataSource114.Select(srOrgLicAccessRequestedStr); if (dvOrgLicAccessRequestedStr.Count != 0) { strOrgLicAccessRequested = dvOrgLicAccessRequestedStr[0][0].ToString(); } DataSourceSelectArguments srOrgMembershipUserIDStr = new DataSourceSelectArguments(); DataView dvOrgMembershipUserIDStr = (DataView)SqlDataSource115.Select(srOrgMembershipUserIDStr); if (dvOrgMembershipUserIDStr.Count != 0) { strOrgMembershipUserID = dvOrgMembershipUserIDStr[0][0].ToString(); } DataSourceSelectArguments srUserPasswordExpiryDt = new DataSourceSelectArguments(); DataView dvUserPasswordExpiryDt = (DataView)SqlDataSource116.Select(srUserPasswordExpiryDt); if (dvUserPasswordExpiryDt.Count != 0) { strDateUserPasswordExpiry = dvUserPasswordExpiryDt[0][0].ToString(); } DataSourceSelectArguments srUserPasswordChangedDt = new DataSourceSelectArguments(); DataView dvUserPasswordChangedDt = (DataView)SqlDataSource126.Select(srUserPasswordChangedDt); if (dvUserPasswordChangedDt.Count != 0) { strDateUserPasswordChanged = dvUserPasswordChangedDt[0][0].ToString(); } DataSourceSelectArguments srUserPasswordResetTokenDt = new DataSourceSelectArguments(); DataView dvUserPasswordResetTokenDt = (DataView)SqlDataSource122.Select(srUserPasswordResetTokenDt); if (dvUserPasswordResetTokenDt.Count != 0) { strDatePasswordResetToken = dvUserPasswordResetTokenDt[0][0].ToString(); } DataSourceSelectArguments srDateRegisteredDt = new DataSourceSelectArguments(); DataView dvDateRegisteredDt = (DataView)SqlDataSource121.Select(srDateRegisteredDt); if (dvDateRegisteredDt.Count != 0) { strDateRegistered = dvDateRegisteredDt[0][0].ToString(); } DataSourceSelectArguments srUserTempDetailsStr = new DataSourceSelectArguments(); DataView dvUserTempDetailsStr = (DataView)SqlDataSource117.Select(srUserTempDetailsStr); if (dvUserTempDetailsStr.Count != 0) { strUserID_TempID = dvUserTempDetailsStr[0][0].ToString(); } DataSourceSelectArguments srOrganisationRequestStr = new DataSourceSelectArguments(); DataView dvOrganisationRequestStr = (DataView)SqlDataSource119.Select(srOrganisationRequestStr); if (dvOrganisationRequestStr.Count != 0) { strOrganisationRequest = dvOrganisationRequestStr[0][0].ToString(); } DataSourceSelectArguments srUserID_UPMStr = new DataSourceSelectArguments(); DataView dvUserID_UPMStr = (DataView)SqlDataSource120.Select(srUserID_UPMStr); if (dvUserID_UPMStr.Count != 0) { strUserID_UPM = dvUserID_UPMStr[0][0].ToString(); } DataSourceSelectArguments srEventTypeRejectedStr = new DataSourceSelectArguments(); DataView dvEventTypeRejectedStr = (DataView)SqlDataSource123.Select(srEventTypeRejectedStr); if (dvEventTypeRejectedStr.Count != 0) { strEventTypeRejected = dvEventTypeRejectedStr[0][0].ToString(); } dtDateToday = DateTime.Now; /* * Password expiry notification and countdown * */ dtDateUserPasswordExpiry = null; if (!string.IsNullOrEmpty(strDateUserPasswordExpiry)) { dtDateUserPasswordExpiry = DateTime.ParseExact(strDateUserPasswordExpiry, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); dtDateUserPasswordExpiryForSubtraction = DateTime.ParseExact(strDateUserPasswordExpiry, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); } if (dtDateUserPasswordExpiry != null && dtDateToday > dtDateUserPasswordExpiry && strOrgID != "7c310be0-c20f-de11-b526-0022642a33b2") { divPasswordExpiry.Visible = true; lblPasswordExpiry.Text = "EDEN password has expired"; lblPasswordExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divPasswordExpiry.Visible = false; } /* * Registration expiry * */ if (!string.IsNullOrEmpty(strDateRegistered)) { dtDateRegistered = DateTime.ParseExact(strDateRegistered, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); tsDateRegistrationValidTimeRemaining = dtDateRegistered.AddHours(+24).Subtract(DateTime.Now); } if (strUserID_SSO == null && dtDateRegistered != null && strDateRegistered != null && dtDateRegistered < DateTime.Now.AddHours(-24)) { divRegistrationExpiry.Visible = true; lblRegistrationExpiry.Text = "<i>Registration token has expired.</i> <br />- User's registration must be deleted to allow re-registration"; lblRegistrationExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divRegistrationExpiry.Visible = false; } if (strUserID_SSO == null && dtDateRegistered != null && strDateRegistered != null && dtDateRegistered > DateTime.Now.AddHours(-24)) { divRegistrationExpiry.Visible = true; lblRegistrationExpiry.Text = "Registration token is valid.<br />- The account verification link can be copied and emailed to the user if the notification has been blocked or re-routed. <br/>- This link is valid until " + dtDateRegistered.AddHours(+24) + ". Remaining time: <b>" + tsDateRegistrationValidTimeRemaining.ToString(@"hh\:mm") + "</b> hours"; lblRegistrationExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900"); } else { divRegistrationExpiry.Visible = false; } if (dtDateRegistered == null) { divRegistrationExpiry.Visible = false; } if (strUserID_SSO != null) { divRegistrationExpiry.Visible = false; } /* * Password reset token expiry * */ //dtDatePasswordResetToken=''; if (!string.IsNullOrEmpty(strDatePasswordResetToken)) { dtDatePasswordResetToken = DateTime.ParseExact(strDatePasswordResetToken, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); tsDatePasswordResetTokenTimeRemaining = dtDatePasswordResetToken.AddHours(+24).Subtract(DateTime.Now); } if (strUserID_SSO != null && dtDatePasswordResetToken != null && strDatePasswordResetToken != null && dtDatePasswordResetToken < DateTime.Now.AddHours(-24)) { divPasswordResetTokenExpiry.Visible = true; lblPasswordResetTokenExpiry.Text = "<br /><i>Password reset token has expired.</i> <br />- The user will need to be begin the password reset process again and generate a new token."; lblPasswordResetTokenExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divPasswordResetTokenExpiry.Visible = false; } if (strUserID_SSO != null && dtDatePasswordResetToken != null && dtDatePasswordResetToken > DateTime.Now.AddHours(-24)) { divPasswordResetTokenExpiry.Visible = true; lblPasswordResetTokenExpiry.Text = "<br />Password reset token is valid.<br />- The password reset token can be copied and emailed to the user.<br/>- This token is valid until " + dtDatePasswordResetToken.AddHours(+24) + ". Remaining time: <b>" + tsDatePasswordResetTokenTimeRemaining.ToString(@"hh\:mm") + "</b> hours (after which the user will need to be begin the password reset process again and generate a new token)."; lblPasswordResetTokenExpiry.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900"); } if (dtDatePasswordResetToken == null) { divPasswordResetTokenExpiry.Visible = false; } if (strUserID_ID == null && strUserID_SSO == null && strUserID_TempID == null && strOrgID == null && strOrgTemp == null && strOrgTempID == null && strTokenUser == null && strOrgAccessRequested == null && strOrgMembershipUserID == null ) { divEmailNotFound.Visible = true; lblEmailNotFound.Text = "Email address not found"; lblEmailNotFound.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divEmailNotFound.Visible = false; } if (strUserID_ID != null && strUserID_SSO == null && strUserID_TempID == null && strOrgID == null && strOrgTemp == null && strOrgTempID == null && strTokenUser != null && strOrgAccessRequested == null && strOrgMembershipUserID == null ) { divUserNoConfirmationClicked.Visible = true; lblUserNoConfirmationClicked.Text = "Status: User has not clicked confirmation email and signed in"; lblUserNoConfirmationClicked.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserNoConfirmationClicked.Visible = false; } if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID == null && strOrgID == null && strOrgTemp == null && strOrgTempID == null && strTokenUser != null && strOrgAccessRequested == null && strOrgMembershipUserID == null ) { divUserConfirmSignedNoStep1.Visible = true; lblUserConfirmSignedNoStep1.Text = "Status: EDEN Portal Access Request - Step 1: User has clicked confirmation email, but has not selected an organisation"; lblUserConfirmSignedNoStep1.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserConfirmSignedNoStep1.Visible = false; } if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID == null && strOrgID == null && strOrgTemp == null && strOrgTempID != null && strTokenUser != null && strOrgAccessRequested == null && strOrgMembershipUserID == null ) { divUserConfirmSignedStep2.Visible = true; divUserConfirmTempOrgDetails.Visible = true; lblUserConfirmSignedStep2.Text = "Status: EDEN Portal Access Request - Step 2: User has selected an organisation, but has not yet added their personal and contact details"; lblUserConfirmSignedStep2.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserConfirmSignedStep2.Visible = false; divUserConfirmTempOrgDetails.Visible = false; } if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID == null && strOrgID == null && strOrgTemp != null && strTokenUser != null ) { divUserConfirmSignedLAStep2.Visible = true; divUserConfirmTempOrgDetails.Visible = true; lblUserConfirmSignedLAStep2.Text = "Status: EDEN Portal Access Request - Step 2: User has selected an organisation, but has not yet added their personal and contact details"; lblUserConfirmSignedLAStep2.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserConfirmSignedLAStep2.Visible = false; divUserConfirmTempOrgDetails.Visible = false; } if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID != null && strOrgID == null && strOrgTemp == null && strOrgTempID != null && strOrgAccessRequested == null && strTokenUser != null && strOrgMembershipUserID == null && strEventTypeRejected != "Organisation Membership Request Rejected" ) { divUserConfirmSignedStep3.Visible = true; divUserConfirmTempOrgDetails.Visible = true; lblUserConfirmSignedStep3.Text = "Status: EDEN Portal Access Request - Step 3: User has selected an organisation, but has not yet selected a module and submitted the access request"; lblUserConfirmSignedStep3.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserConfirmSignedStep3.Visible = false; divUserConfirmTempOrgDetails.Visible = false; } //if (strUserID_SSO != null && strOrgID == null && strUserID_TempID != null && strOrgTemp != null && strOrgAccessRequested == null) if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID != null && strOrgID == null && strOrgTemp != null && strOrgAccessRequested == null && strTokenUser != null && strOrgMembershipUserID == null && strOrganisationRequest == null && strEventTypeRejected == null ) { divUserConfirmSignedLAStep3.Visible = true; divUserConfirmTempOrgDetails.Visible = true; lblUserConfirmSignedLAStep3.Text = "Status: EDEN Portal Access Request - Step 3: User has selected an organisation, but has not yet selected a module and submitted the access request"; lblUserConfirmSignedLAStep3.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserConfirmSignedLAStep3.Visible = false; divUserConfirmTempOrgDetails.Visible = false; } if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID != null && strOrgID == null && strOrgTemp != null && strOrgAccessRequested == null && strTokenUser != null && strOrgMembershipUserID == null && strOrganisationRequest != null ) { divUserNewOrgCreate.Visible = true; lblUserNewOrgCreate.Text = "Status: User has selected a module and requested to register a <i>new</i> organisation on EDEN. The request is now with the EPA for approval"; lblUserNewOrgCreate.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900"); } else { divUserNewOrgCreate.Visible = false; } if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID != null && strOrgID == null && strOrgTemp == null && strOrgTempID != null && strOrgAccessRequested != null && strTokenUser != null && strOrgMembershipUserID == null ) { divUserRegCompleteNoApproval.Visible = true; divUserConfirmTempOrgDetails.Visible = true; lblUserRegCompleteNoApproval.Text = "Status: User has selected an organisation, selected a module and submitted the access request. The org admin(s) can now process this request"; lblUserRegCompleteNoApproval.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900"); } else { divUserRegCompleteNoApproval.Visible = false; divUserConfirmTempOrgDetails.Visible = false; } //if (strUserID_SSO != null && strOrgID == null && strUserID_TempID != null && strOrgTemp != null && strOrgAccessRequested != null) if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID != null && strOrgID == null && strOrgTemp != null && strOrgAccessRequested != null && strTokenUser != null && strOrgMembershipUserID == null ) { divUserRegCompleteNoApprovalLA.Visible = true; lblUserRegCompleteNoApprovalLA.Text = "Status: User has selected an organisation, selected a module and submitted the access request. The org admin(s) can now process this request"; lblUserRegCompleteNoApprovalLA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900"); } else { divUserRegCompleteNoApprovalLA.Visible = false; } if (strOrgModAccessRequested != null && strOrgID != null) { divModuleAccessPending.Visible = true; lblModuleAccessPending.Text = "Status: One or more module access requests by this user currently Pending Approval"; lblModuleAccessPending.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divModuleAccessPending.Visible = false; } if (strOrgID != null) { divUserConfirmSignedNoStep1.Visible = false; } if (strUserID_TempID != null) { divPasswordExpiry.Visible = false; } if (strOrgModAccessRequested != null && strOrgLicAccessRequested != null) { GridView16.Visible = true; GridView17.Visible = false; } if (strOrgModAccessRequested == strOrgLicAccessRequested) { GridView16.Visible = true; GridView17.Visible = true; } if (strOrgMembershipUserID == null) { GridView23.Visible = true; } else { GridView23.Visible = false; } if (strOrgMembershipUserID == null) { GridView22.Visible = true; } else { GridView22.Visible = false; } if (strUserID_SSO == null & strTokenUser != null) { divVerificationLink.Visible = true; } else { divVerificationLink.Visible = false; } if (strUserID_SSO != null) { divVerificationLink.Visible = false; } if (strUserID_SSO != null) { divUserExternalLinks.Visible = true; } else { divUserExternalLinks.Visible = false; } if (strTokenPass == null) { divPasswordReset.Visible = false; } else { divPasswordReset.Visible = true; } /* * EPA Users */ if (strUserID_ID == null && strUserID_SSO != null && strUserID_TempID == null && strUserID_UPM != null && strOrgID == null && strOrgTemp == null && strOrgTempID == null && strTokenUser == null && strTokenPass == null && strOrgAccessRequested == null && strOrgModAccessRequested == null && strOrgLicAccessRequested == null && strOrgMembershipUserID == null && strOrganisationRequest == null && strEventTypeRejected == null ) { divUserEPAStep1.Visible = true; lblUserEPAStep1.Text = "Status: EDEN Portal Access Request - Step 1: EPA user has signed up, but has not selected an organisation"; lblUserEPAStep1.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserEPAStep1.Visible = false; } if (strUserID_ID == null && strUserID_SSO != null && strUserID_TempID == null && strUserID_UPM != null && strOrgTemp != null && strOrgAccessRequested == null && strOrgMembershipUserID == null ) { divUserEPAStep2.Visible = true; lblUserEPAStep2.Text = "Status: EDEN Portal Access Request - Step 2: EPA user has selected organisation, but has not yet added their personal and contact details"; lblUserEPAStep2.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserEPAStep2.Visible = false; } if (strUserID_ID == null && strUserID_SSO != null && strUserID_TempID != null && strUserID_UPM != null && strOrgTemp != null && strOrgAccessRequested == null && strOrgMembershipUserID == null ) { divUserEPAStep3.Visible = true; lblUserEPAStep3.Text = "Status: EDEN Portal Access Request - Step 3: EPA user has added their personal and contact details, but has not yet selected a module"; lblUserEPAStep3.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserEPAStep3.Visible = false; } if (strUserID_ID == null && strUserID_SSO != null && strUserID_TempID != null && strUserID_UPM != null && strOrgTemp != null && strOrgAccessRequested != null ) { divUserRegCompleteNoApprovalEPA.Visible = true; lblUserRegCompleteNoApprovalEPA.Text = "EPA user has selected an organisation, selected a module and submitted the access request. The EPA org admin(s) can now process this request"; lblUserRegCompleteNoApprovalEPA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#4d9900"); } else { divUserRegCompleteNoApprovalEPA.Visible = false; } if (strUserID_ID == null && strUserID_SSO != null && strUserID_TempID == null && strUserID_UPM != null && strOrgID == null && strOrgTemp == null && strOrgTempID == null && strTokenUser == null && strTokenPass == null && strOrgAccessRequested == null && strOrgModAccessRequested == null && strOrgLicAccessRequested == null && strOrgMembershipUserID == null && strOrganisationRequest == null && strEventTypeRejected == "Organisation Rejected" ) { divUserRejectedLA.Visible = true; lblUserRejectedLA.Text = "Status: User has signed up, but the organisation has been <b>rejected</b><br /> - This email address must be manually deleted from the SSO to be used again to register."; lblUserRejectedLA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserRejectedLA.Visible = false; } if (strUserID_ID != null && strUserID_SSO != null && strUserID_TempID != null && strEventTypeRejected == "Organisation Rejected" ) { divOrgRejected.Visible = true; lblOrgRejected.Text = "Status: User has signed up, but the <b>organisation creation request</b> has been <b>rejected</b><br /> - This email address must be manually deleted from the SSO to be used again to register."; lblOrgRejected.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divOrgRejected.Visible = false; } if ( strEventTypeRejected == "Organisation Membership Request Rejected" ) { divUserRejectedLA.Visible = true; lblUserRejectedLA.Text = "Status: User has signed up, but the <b>organisation membership request</b> has been <b>rejected</b><br /> - This email address must be manually deleted from the SSO to be used again to register."; lblUserRejectedLA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserRejectedLA.Visible = false; } if ( strEventTypeRejected == "Module Authorisation Rejected" ) { divUserRejectedLA.Visible = true; lblUserRejectedLA.Text = "Status: User's organisation access has been approved, but a module authorisation request has been rejected. (This may have been rectified - please check the notifications below).<br />"; lblUserRejectedLA.ForeColor = System.Drawing.ColorTranslator.FromHtml("#E60000"); } else { divUserRejectedLA.Visible = false; } tsDatePasswordExpiryLessDatePasswordReset = dtDateUserPasswordExpiryForSubtraction - dtDatePasswordResetToken; int passwordReset_Expiry_DifferenceInDays = tsDatePasswordExpiryLessDatePasswordReset.Days; if (tsDatePasswordExpiryLessDatePasswordReset.Days == 90) { divPasswordResetTokenExpiry.Visible = false; } divTokens.Visible = true; divSeperatorCurrent.Visible = true; divSeperatorPending.Visible = true; divSeperatorLicences.Visible = true; divSeperatorTokens.Visible = true; txtCopyVerificationLink.Text = "https://account.edenireland.ie/signup/confirmemail?userId=" + strUserID_ID + "&token=" + strTokenUser; txtCopyPasswordResetLink.Text = "https://account.edenireland.ie/passwordreset/resetpassword?userId=" + strUserID_SSO + "&token=" + strTokenPass; GridView1.DataBind(); GridView2.DataBind(); GridView3.DataBind(); GridView4.DataBind(); GridView5.DataBind(); GridView6.DataBind(); GridView7.DataBind(); GridView8.DataBind(); GridView9.DataBind(); GridView10.DataBind(); GridView11.DataBind(); GridView12.DataBind(); GridView13.DataBind(); GridView14.DataBind(); GridView15.DataBind(); GridView16.DataBind(); GridView17.DataBind(); GridView18.DataBind(); GridView19.DataBind(); GridView20.DataBind(); GridView21.DataBind(); GridView22.DataBind(); GridView23.DataBind(); GridView24.DataBind(); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "setorder") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; PPID.Text = e.CommandArgument.ToString(); Panel9.Visible = true; Panel10.Visible = true; GridView4.DataSource = dp.Query_ConnectedWorkOrder(new Guid(PPID.Text)); GridView4.DataBind(); GridView5.DataSource = dp.Query_WorkOrder(TextBox20.Text); GridView5.DataBind(); UpdatePanel9.Update(); UpdatePanel10.Update(); } if (e.CommandName == "getorder") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; PPID.Text = e.CommandArgument.ToString(); Panel9.Visible = false; Panel10.Visible = false; Panel12.Visible = true; GridView9.DataSource = dp.Query_ConnectedWorkOrder(new Guid(PPID.Text)); GridView9.DataBind(); UpdatePanel12.Update(); UpdatePanel10.Update(); UpdatePanel9.Update(); } if (e.CommandName == "setview") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; PPID.Text = e.CommandArgument.ToString(); DropDownList3.Items.Clear(); SqlDataReader myReader = dp.Query_CapableDep(new Guid(PPID.Text)); SqlDataReader myReader2 = dp.Query_CapableDepDone(new Guid(PPID.Text)); while (myReader.Read()) { string a = myReader["BDOS_Name"].ToString(); if (Session["Department"].ToString().Contains(myReader["BDOS_Name"].ToString())) { DropDownList3.Items.Add(new ListItem(myReader["BDOS_Name"].ToString(), myReader["PPDS_ID"].ToString()));//增加Item } } while (myReader2.Read()) { ListItem li = DropDownList3.Items.FindByText(myReader2["BDOS_Name"].ToString()); DropDownList3.Items.Remove(li); } if (DropDownList3.Items.Count > 0) { Panel11.Visible = true; UpdatePanel11.Update(); } else { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('处理意见已填写或您没有相应的权限!')", true); } } if (e.CommandName == "getview") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; PPID.Text = e.CommandArgument.ToString(); GridView10.DataSource = dp.GetAuditSuggest(new Guid(PPID.Text)); GridView10.DataBind(); Panel15.Visible = true; UpdatePanel15.Update(); } if (e.CommandName == "track") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; PPID.Text = e.CommandArgument.ToString(); Panel13.Visible = true; Panel14.Visible = false; Panel15.Visible = false; UpdatePanel13.Update(); UpdatePanel14.Update(); UpdatePanel15.Update(); } if (e.CommandName == "audit") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; PPID.Text = e.CommandArgument.ToString(); GridView8.DataSource = dp.GetAuditSuggest(new Guid(PPID.Text)); GridView8.DataBind(); Panel14.Visible = true; UpdatePanel14.Update(); } if (e.CommandName == "mod") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; switchlabel.Text = "修改"; PPID.Text = e.CommandArgument.ToString(); Panel3.Visible = true; UpdatePanel3.Update(); UpdatePanel4.Update(); } if (e.CommandName == "del") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; PPID.Text = e.CommandArgument.ToString(); dp.Delete_DefectProduct(new Guid(PPID.Text)); GridView1.DataSource = dp.Query_DefectProduct(); GridView1.DataBind(); Panel4.Visible = false; Panel10.Visible = false; Panel14.Visible = false; UpdatePanel2.Update(); UpdatePanel3.Update(); UpdatePanel4.Update(); UpdatePanel10.Update(); UpdatePanel14.Update(); } }
protected void Page_Load(object sender, EventArgs e) { try { con = new SqlConnection(conString); con.Open(); try { if (!string.IsNullOrEmpty(Request.QueryString["numePacient"] as string)) { numeP = Request.QueryString["numePacient"]; cnp = Request.QueryString["cnpPacient"]; LabelIesirePacient.Text = "Iesire, " + numeP.ToString().Trim(); Label9.Text = ""; } else { if (!string.IsNullOrEmpty(Application["numePacient"] as string)) { LabelIesirePacient.Text = "Iesire, " + (string)Application["numePacient"]; Label9.Text = ""; } else { throw new NullReferenceException("Eroare la transmiterea datelor utilizand sesiunin. Pacientul nu este logat."); } } } catch (NullReferenceException ex) { Label9.ForeColor = Color.Red; Label9.Text = ex.Message; } cnpPacientLogat = (string)Application["cnpPacient"]; string stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CISimple"; SqlDataAdapter da = new SqlDataAdapter(stmt, con); DataSet ds = new DataSet(); da.Fill(ds, "CISimple"); GridView1.DataSource = ds.Tables["CISimple"]; GridView1.DataBind(); stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CIAlbireDentaraTratamenteSpeciale"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIAlbireDentaraTratamenteSpeciale"); GridView2.DataSource = ds.Tables["CIAlbireDentaraTratamenteSpeciale"]; GridView2.DataBind(); stmt = "select nume as [Nume interventie], categorie as [Categorie], pret as [Pret in Lei] from CIProtetica"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIProtetica"); GridView3.DataSource = ds.Tables["CIProtetica"]; GridView3.DataBind(); stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CIChirurgie"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIChirurgie"); GridView10.DataSource = ds.Tables["CIChirurgie"]; GridView10.DataBind(); stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CIImplantDentar"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIImplantDentar"); GridView4.DataSource = ds.Tables["CIImplantDentar"]; GridView4.DataBind(); stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CIBonturiProtetice"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIBonturiProtetice"); GridView5.DataSource = ds.Tables["CIBonturiProtetice"]; GridView5.DataBind(); stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CIProtezeSpecialeImplant"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIProtezeSpecialeImplant"); GridView6.DataSource = ds.Tables["CIProtezeSpecialeImplant"]; GridView6.DataBind(); stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CIProteze"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIProteze"); GridView7.DataSource = ds.Tables["CIProteze"]; GridView7.DataBind(); stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CIRadiologie"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIRadiologie"); GridView8.DataSource = ds.Tables["CIRadiologie"]; GridView8.DataBind(); stmt = "select nume as [Nume interventie], pret as [Pret in Lei] from CIAblatiiCimentariAmprente"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "CIAblatiiCimentariAmprente"); GridView9.DataSource = ds.Tables["CIAblatiiCimentariAmprente"]; GridView9.DataBind(); stmt = "select nume, prenume from Medici"; da = new SqlDataAdapter(stmt, con); da.Fill(ds, "Medici"); DataRow[] medici = ds.Tables["Medici"].Select(); if (!Page.IsPostBack) //ca sa faca upload numai o data cand se ruleaza pagina si nu de fiecare data cand se da refresh { mediciDDL.Items.Clear(); mediciDDL.Items.Add("Selectati..."); foreach (DataRow row in medici) { mediciDDL.Items.Add(row["nume"].ToString() + " " + row["prenume"].ToString()); } } da.Dispose(); ds.Dispose(); Label10.Text = ""; Label11.Text = ""; Label12.Text = ""; Label13.Text = ""; Label14.Text = ""; Label15.Text = ""; Label16.Text = ""; Label17.Text = ""; Label37.Text = ""; dataTB.Attributes.Add("readonly", "readonly"); if (!IsPostBack) { IncarcareDatePacientLogat(); } } catch (Exception ex) { Label9.ForeColor = Color.Red; Label9.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label10.ForeColor = Color.Red; Label10.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label11.ForeColor = Color.Red; Label11.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label12.ForeColor = Color.Red; Label12.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label13.ForeColor = Color.Red; Label13.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label14.ForeColor = Color.Red; Label14.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label15.ForeColor = Color.Red; Label15.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label16.ForeColor = Color.Red; Label16.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label17.ForeColor = Color.Red; Label17.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; Label37.ForeColor = Color.Red; Label37.Text = "Nu se poate realiza conexiunea la baza de date: " + ex.Message; } finally { con.Close(); } }
protected void Button17_Click(object sender, EventArgs e) { string str131 = "delete from tablefielddetail where tableId='" + ViewState["tableid"] + "'"; SqlCommand cmd131 = new SqlCommand(str131, con); con.Open(); cmd131.ExecuteNonQuery(); con.Close(); foreach (GridViewRow gr51 in GridView8.Rows) { Label txtfeild = ((Label)gr51.FindControl("Label25")); Label ddltype = ((Label)gr51.FindControl("Label27")); Label txtsize = ((Label)gr51.FindControl("Label28")); Label chkprimary = ((Label)gr51.FindControl("Label29")); Label chkforign = ((Label)gr51.FindControl("Label31")); Label ddlforigntableid = ((Label)gr51.FindControl("Label351")); Label ddlforignfeildid = ((Label)gr51.FindControl("Label354")); Label chknull = ((Label)gr51.FindControl("Label34")); SqlCommand cmd33 = new SqlCommand("Insert into tablefielddetail(TableId,feildname,fieldtype,size,Isforeignkey,foreignkeytblid,foreignkeyfieldId,isprimarykey,notallownull)Values('" + Convert.ToInt32(ViewState["tableid"]) + "','" + txtfeild.Text + "','" + ddltype.Text + "','" + txtsize.Text + "','" + chkforign.Text + "','" + ddlforigntableid.Text + "','" + ddlforignfeildid.Text + "','" + chkprimary.Text + "','" + chknull.Text + "')", con); if (con.State.ToString() != "Open") { con.Open(); } cmd33.ExecuteNonQuery(); } CheckDbConn(); SqlDataAdapter da = new SqlDataAdapter("SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name='" + ViewState["TableName"].ToString() + "'", conn1); DataTable dt = new DataTable(); da.Fill(dt); DataTable dt_s = new DataTable(); if (dt.Rows.Count > 0) { if (dt_s.Rows.Count < 1) { dt_s.Columns.Add("COLUMN_NAME"); dt_s.Columns.Add("DATA_TYPE"); } for (int k = 0; k < dt.Rows.Count; k++) { DataRow dr = dt_s.NewRow(); dr["COLUMN_NAME"] = dt.Rows[k]["COLUMN_NAME"].ToString(); dr["DATA_TYPE"] = dt.Rows[k]["DATA_TYPE"].ToString(); dt_s.Rows.Add(dr); } if (dt_s.Rows.Count == GridView8.Rows.Count) { foreach (GridViewRow gr5 in GridView8.Rows) { TextBox txtfeild = ((TextBox)gr5.FindControl("TextBox2")); } } else { ModalPopupExtender1.Show(); GridView9.DataSource = dt_s; GridView9.DataBind(); DataTable dtu = select("select feildname,fieldtype from tablefielddetail where TableId='" + ViewState["tableid"] + "'"); GridView10.DataSource = dtu; GridView10.DataBind(); } } else { } Panel9.Visible = false; Label360.Text = "Updated Successfully"; }