protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { ABE_Category_Revers.DataBind(); GridView9.DataBind(); string DD2_index = DropDownList2.SelectedValue; DropDownList1.SelectedValue = GridView9.Rows[0].Cells[0].Text; ABE_Sub_Category.DataBind(); DropDownList2.DataBind(); DropDownList2.SelectedValue = DD2_index; // TextBox9.Text = DropDownList2.SelectedItem.Text; DropDownList101.SelectedValue = "0"; DropDownList102.SelectedValue = "0"; DropDownList103.SelectedValue = "0"; DropDownList104.SelectedValue = "0"; DropDownList105.SelectedValue = "0"; DropDownList106.SelectedValue = "0"; DropDownList107.SelectedValue = "0"; DropDownList108.SelectedValue = "0"; DropDownList109.SelectedValue = "0"; DropDownList110.SelectedValue = "0"; TextBox121.Text = "0"; TextBox133.Text = "0"; ShowDDL(); if (DropDownList1.SelectedValue == "4") { DropDownList111.Enabled = true; } else { DropDownList111.Enabled = false; DropDownList111.SelectedIndex = 0; } }
protected void SummitReportData_Click(object sender, EventArgs e) { string man = Session["UserName"].ToString(); foreach (GridViewRow rows in GridView9.Rows) { TextBox note = rows.Cells[6].FindControl("TextBox1") as TextBox; TextBox net = rows.Cells[7].FindControl("TextBox2") as TextBox; if (net.Text != "" && net.Enabled) { string notestring = note.Text; string netstring = net.Text; Guid detailid = new Guid(rows.Cells[0].Text); hd.InsertDetail(detailid, new Guid(ReportID.Text), netstring, man, notestring); } } Panel9.Visible = false; GridView9.DataSource = hd.QueryDetail(new Guid(VersionID.Text), Guid.Empty); GridView9.DataBind(); UpdatePanel9.Update(); }
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(); } } }
private void View6_DataBind() { Label31.Text = DropDownList13.SelectedItem.Text; Label32.Text = DropDownList14.SelectedItem.Text; Label30.Text = DropDownList12.SelectedItem.Text + ": " + DropDownList13.SelectedItem.Text + " Vs " + DropDownList14.SelectedItem.Text; GridView8.DataSource = SqlDataSource16; GridView8.DataBind(); GridView9.DataBind(); GridView9.Visible = true; Chart5.DataSource = SqlDataSource16; Chart5.DataBind(); if (Chart5.Series[0].Points.Count > 0 || Chart5.Series[1].Points.Count > 0) { Label31.Text = DropDownList13.SelectedItem.Text; Label32.Text = DropDownList14.SelectedItem.Text; Label31.Visible = true; Label32.Visible = true; } Chart5.Visible = true; }
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) { if (TextBox121.Text.Length == 0) { TextBox121.Text = "0"; TextBox133.Text = "0"; } Page.MaintainScrollPositionOnPostBack = true; TextBox135.Text = (string)Session["ID_Pers_Check_Proj"]; TextBox130.Text = DateTime.Today.Year.ToString(); // TextBox8.Text = DateTime.Today.ToString("dd/MM/yyyy"); TextBox124.Text = DateTime.Today.ToString("dd/MM/yyyy"); TextBox126.Text = User.Identity.Name; TextBox128.Text = FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isotimia().ToString(); if (!CheckBox1.Checked) { TextBox8.Text = DateTime.Today.ToString("dd/MM/yyyy"); } if (TextBox128.Text == "0") { GridView4.Visible = false; GridView8.Visible = false; TextBox133.Visible = false; TextBox134.Visible = false; } else { GridView4.Columns[0].HeaderText = FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isot_Descr(Convert.ToDateTime(TextBox8.Text).ToString("yyyy-MM-dd")).ToString(); GridView4.Visible = true; GridView8.Visible = true; TextBox133.Visible = true; TextBox134.Visible = true; } Session["Status_Cur"] = "0"; TextBox134.Text = FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isot_Descr(DateTime.Today.ToString("yyyy-MM-dd")).ToString(); if (!IsPostBack) { TextBox121.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); TextBox125.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); TextBox133.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); TextBox134.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); ABE_KINISI_WAIT.DataBind(); GridView9.DataBind(); TextBox138.Text = GridView9.Rows[0].Cells[17].Text; TextBox139.Text = GridView9.Rows[0].Cells[6].Text + ", " + GridView9.Rows[0].Cells[8].Text; TextBox140.Text = GridView9.Rows[0].Cells[19].Text.Replace(" ", ""); if (GridView9.Rows[0].Cells[20].Text == "1") { Label1.Visible = true; Label1.Text = "ΕΠΙΣΤΡΟΦΗ ΧΡΗΜΑΤΩΝ - ΑΠΟΡΡΙΨΗ"; } else if (GridView9.Rows[0].Cells[20].Text == "2") { Label1.Visible = true; Label1.Text = "ΣΥΜΨΗΦΙΣΜΟ ME ΑΠΟΡΡΙΨΗ " + "<br>" + GridView9.Rows[0].Cells[22].Text.Replace(" ", ""); } else { Label1.Visible = false; } if (GridView9.Rows[0].Cells[5].Text == "6" || (GridView9.Rows[0].Cells[5].Text == "7" && Convert.ToDecimal(GridView9.Rows[0].Cells[9].Text) > 0) || 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 if (GridView9.Rows[0].Cells[5].Text == "7" && Convert.ToDecimal(GridView9.Rows[0].Cells[9].Text) <= 0) { Dis_Area(); TextBox121.Text = GridView9.Rows[0].Cells[9].Text; TextBox133.Text = GridView9.Rows[0].Cells[10].Text; TextBox121.BackColor = System.Drawing.ColorTranslator.FromHtml("#89009b"); TextBox125.BackColor = System.Drawing.ColorTranslator.FromHtml("#89009b"); TextBox133.BackColor = System.Drawing.ColorTranslator.FromHtml("#89009b"); TextBox134.BackColor = System.Drawing.ColorTranslator.FromHtml("#89009b"); } else { Enab_Area(); } } }
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 Page_Load(object sender, EventArgs e) { if (TextBox121.Text.Length == 0) { TextBox121.Text = "0"; TextBox142.Text = "0"; TextBox133.Text = "0"; TextBox144.Text = "0"; } Page.MaintainScrollPositionOnPostBack = true; TextBox135.Text = (string)Session["ID_Pers_Check_Proj"]; TextBox130.Text = DateTime.Today.Year.ToString(); // TextBox8.Text = DateTime.Today.ToString("dd/MM/yyyy"); TextBox124.Text = DateTime.Today.ToString("dd/MM/yyyy"); TextBox126.Text = User.Identity.Name; TextBox128.Text = FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isotimia().ToString(); TextBox121.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); TextBox125.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); TextBox133.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); TextBox134.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); TextBox144.BackColor = TextBox142.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); TextBox145.BackColor = TextBox143.BackColor = System.Drawing.ColorTranslator.FromHtml("#000066"); if (!CheckBox1.Checked) { TextBox8.Text = DateTime.Today.ToString("dd/MM/yyyy"); } if (TextBox128.Text == "0") { GridView4.Visible = false; GridView8.Visible = false; GridView12.Visible = false; TextBox133.Visible = false; TextBox134.Visible = false; TextBox144.Visible = false; TextBox145.Visible = false; } else { GridView4.Columns[0].HeaderText = FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isot_Descr(Convert.ToDateTime(TextBox8.Text).ToString("yyyy-MM-dd")).ToString(); GridView12.Columns[0].HeaderText = FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isot_Descr(Convert.ToDateTime(TextBox8.Text).ToString("yyyy-MM-dd")).ToString(); GridView4.Visible = true; GridView8.Visible = true; GridView12.Visible = true; TextBox133.Visible = true; TextBox134.Visible = true; TextBox144.Visible = true; TextBox145.Visible = true; } Session["Status_Cur"] = "0"; TextBox134.Text = FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isot_Descr(DateTime.Today.ToString("yyyy-MM-dd")).ToString(); TextBox145.Text = FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isot_Descr(DateTime.Today.ToString("yyyy-MM-dd")).ToString(); if (!IsPostBack) { ABE_KINISI_WAIT.DataBind(); GridView9.DataBind(); TextBox138.Text = GridView9.Rows[0].Cells[17].Text; TextBox139.Text = GridView9.Rows[0].Cells[6].Text + ", " + GridView9.Rows[0].Cells[8].Text; } Enab_Area(); ScriptManager.GetCurrent(Page).RegisterPostBackControl(Button1); }
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 Btn_AgergarCodigosP(object sender, EventArgs e) { tb.Columns.Add("ID"); tb.Columns.Add("Codigo"); tb.Columns.Add("ID_Marca"); tb.Columns.Add("Marca_P"); foreach (GridViewRow drow in GridView6.Rows) { DataRow dr = tb.NewRow(); dr["ID"] = drow.Cells[0].Text.ToString(); dr["Codigo"] = drow.Cells[1].Text.ToString(); dr["ID_Marca"] = drow.Cells[2].Text.ToString(); dr["Marca_P"] = drow.Cells[3].Text.ToString(); tb.Rows.Add(dr); } if (TextBox2.Text != "") { DataRow dr = null; if (ViewState["Detalles9"] != null) { for (int i = 0; i < 1; i++) { tb = (DataTable)ViewState["Detalles9"]; if (tb.Rows.Count > 0) { dr = tb.NewRow(); // dr["ID"] = Label1.Text; dr["ID"] = "-"; dr["Codigo"] = TextBox2.Text; dr["ID_Marca"] = DropDownList2.SelectedValue.ToString(); dr["Marca_P"] = DropDownList2.SelectedItem.ToString(); tb.Rows.Add(dr); GridView9.DataSource = tb; GridView9.DataBind(); } } } else { dr = tb.NewRow(); // dr["ID"] = Label1.Text; dr["ID"] = "-"; dr["Codigo"] = TextBox2.Text; dr["ID_Marca"] = DropDownList2.SelectedValue.ToString(); dr["Marca_P"] = DropDownList2.SelectedItem.ToString(); tb.Rows.Add(dr); GridView9.DataSource = tb; GridView9.DataBind(); } ViewState["Detalles9"] = tb; TextBox2.Text = ""; GridView9.Visible = true; GridView6.Visible = false; } else { Response.Write("<script>alert('Ingrese un codigo')</script>"); } DatosP.DeleteCodigoProd(Convert.ToInt32(Label8.Text)); Button4_ModalPopupExtender.Show(); }
protected void Page_Load(object sender, EventArgs e) { try { c.Open(); String month = DateTime.Now.ToString("MMMMMMMMMMMMM"); SqlCommand cmd = new SqlCommand("Select AbsentTeacherId,ZeroPeriod from Arrangement where ZPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd1 = new SqlCommand("Select AbsentTeacherId,FirstPeriod from Arrangement where FPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd2 = new SqlCommand("Select AbsentTeacherId,SecondPeriod from Arrangement where SPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd3 = new SqlCommand("Select AbsentTeacherId,ThirdPeriod from Arrangement where TPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd4 = new SqlCommand("Select AbsentTeacherId,FourthPeriod from Arrangement where FOPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd5 = new SqlCommand("Select AbsentTeacherId,FifthPeriod from Arrangement where FIPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd6 = new SqlCommand("Select AbsentTeacherId,SixthPeriod from Arrangement where SIPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd7 = new SqlCommand("Select AbsentTeacherId,SeventhPeriod from Arrangement where SEPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd8 = new SqlCommand("Select AbsentTeacherId,EighthPeriod from Arrangement where EPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd9 = new SqlCommand("Select AbsentTeacherId,NinethPeriod from Arrangement where NPDTArrName = '" + Session["user"].ToString() + "' and Daay='" + DateTime.Now.ToString("dddddddddd") + "'", c); SqlCommand cmd10 = new SqlCommand("Select Day from No_Of_Arrangement as Today where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlCommand cmd11 = new SqlCommand("Select Week from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlCommand cmd13 = new SqlCommand("Select Year from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); if (da.Fill(dt) > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } SqlDataAdapter da1 = new SqlDataAdapter(cmd1); DataTable dt1 = new DataTable(); if (da1.Fill(dt1) > 0) { GridView2.DataSource = dt1; GridView2.DataBind(); } SqlDataAdapter da2 = new SqlDataAdapter(cmd2); DataTable dt2 = new DataTable(); if (da2.Fill(dt2) > 0) { GridView3.DataSource = dt2; GridView3.DataBind(); } SqlDataAdapter da3 = new SqlDataAdapter(cmd3); DataTable dt3 = new DataTable(); if (da3.Fill(dt3) > 0) { GridView4.DataSource = dt3; GridView4.DataBind(); } SqlDataAdapter da4 = new SqlDataAdapter(cmd4); DataTable dt4 = new DataTable(); if (da4.Fill(dt4) > 0) { GridView5.DataSource = dt4; GridView5.DataBind(); } SqlDataAdapter da5 = new SqlDataAdapter(cmd5); DataTable dt5 = new DataTable(); if (da5.Fill(dt5) > 0) { GridView6.DataSource = dt5; GridView6.DataBind(); } SqlDataAdapter da6 = new SqlDataAdapter(cmd6); DataTable dt6 = new DataTable(); if (da6.Fill(dt6) > 0) { GridView7.DataSource = dt6; GridView7.DataBind(); } SqlDataAdapter da7 = new SqlDataAdapter(cmd7); DataTable dt7 = new DataTable(); if (da7.Fill(dt7) > 0) { GridView8.DataSource = dt7; GridView8.DataBind(); } SqlDataAdapter da8 = new SqlDataAdapter(cmd8); DataTable dt8 = new DataTable(); if (da8.Fill(dt8) > 0) { GridView9.DataSource = dt8; GridView9.DataBind(); } SqlDataAdapter da9 = new SqlDataAdapter(cmd9); DataTable dt9 = new DataTable(); if (da9.Fill(dt9) > 0) { GridView10.DataSource = dt9; GridView10.DataBind(); } SqlDataAdapter da10 = new SqlDataAdapter(cmd10); DataTable dt10 = new DataTable(); if (da10.Fill(dt10) > 0) { GridView11.DataSource = dt10; GridView11.DataBind(); } SqlDataAdapter da11 = new SqlDataAdapter(cmd11); DataTable dt11 = new DataTable(); if (da11.Fill(dt11) > 0) { GridView12.DataSource = dt11; GridView12.DataBind(); } if (month == "January") { SqlCommand cmd12 = new SqlCommand("Select January from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "February") { SqlCommand cmd12 = new SqlCommand("Select February from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "March") { SqlCommand cmd12 = new SqlCommand("Select March from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "April") { SqlCommand cmd12 = new SqlCommand("Select April from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "May") { SqlCommand cmd12 = new SqlCommand("Select May from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "June") { SqlCommand cmd12 = new SqlCommand("Select June from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "July") { SqlCommand cmd12 = new SqlCommand("Select July from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "August") { SqlCommand cmd12 = new SqlCommand("Select August from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "September") { SqlCommand cmd12 = new SqlCommand("Select September from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "October") { SqlCommand cmd12 = new SqlCommand("Select October from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "November") { SqlCommand cmd12 = new SqlCommand("Select November from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } if (month == "December") { SqlCommand cmd12 = new SqlCommand("Select December from No_Of_Arrangement where TeacherId= '" + Session["user"].ToString() + "' ", c); SqlDataAdapter da12 = new SqlDataAdapter(cmd12); DataTable dt12 = new DataTable(); if (da12.Fill(dt12) > 0) { GridView13.DataSource = dt12; GridView13.DataBind(); } } SqlDataAdapter da13 = new SqlDataAdapter(cmd13); DataTable dt13 = new DataTable(); if (da13.Fill(dt13) > 0) { GridView14.DataSource = dt13; GridView14.DataBind(); } c.Close(); } catch (Exception ex) { Label1.Text = ex.Message; } }
protected void GridView9_IndexChanging(object sender, GridViewPageEventArgs e) { GridView9.PageIndex = e.NewPageIndex; GridView9.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 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"; }
protected void Page_Load(object sender, EventArgs e) { try { SqlConnection con = new SqlConnection(strcon); if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataAdapter da = new SqlDataAdapter("SELECT F.TitluFilm as 'Film', SUM(R.NumarBilete) as 'Total Bilete', COUNT(R.RezervareID) as 'Total Rezervari' FROM Bilet B LEFT JOIN Rezervare R ON B.RezervareID = R.RezervareID LEFT JOIN Film F ON B.FilmID = F.FilmID GROUP BY F.TitluFilm ", con); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); SqlDataAdapter da1 = new SqlDataAdapter("SELECT DISTINCT COUNT(R.RezervareID) as Rezervari, U.Username FROM[User] U INNER JOIN Rezervare R ON R.UserID = U.UserID GROUP BY U.Username HAVING COUNT(R.RezervareID) = (SELECT MAX(C.Suma) FROM(SELECT(COUNT(RR.RezervareID)) AS Suma, UU.Username FROM[User] UU INNER JOIN Rezervare RR ON RR.UserID = UU.UserID GROUP BY UU.Username) C); ", con); DataTable dt1 = new DataTable(); da1.Fill(dt1); GridView2.DataSource = dt1; GridView2.DataBind(); SqlDataAdapter da2 = new SqlDataAdapter("SELECT DISTINCT P.Platit,COUNT(R.RezervareID) as 'Numar rezervari', U.Username FROM [User] U INNER JOIN Rezervare R ON U.UserID = R.UserID INNER JOIN Plata P ON R.RezervareID = P.RezervareID WHERE P.Platit = 'NU' GROUP BY U.Username, Platit HAVING COUNT(R.RezervareID) IN (SELECT (COUNT(RR.RezervareID)) FROM [User] UU INNER JOIN Rezervare RR ON RR.UserID = UU.UserID GROUP BY UU.Username HAVING COUNT(RR.RezervareID) > 1) ", con); DataTable dt2 = new DataTable(); da2.Fill(dt2); GridView3.DataSource = dt2; GridView3.DataBind(); SqlDataAdapter da3 = new SqlDataAdapter("SELECT DISTINCT F.TitluFilm as 'Titlu Film', S.NumeSala as 'Nume Sala' FROM Film F LEFT JOIN Bilet B ON B.FilmID = F.FilmID left join Sala S on S.SalaID = F.SalaID WHERE F.FilmID NOT IN (SELECT FilmID FROM Bilet)", con); DataTable dt3 = new DataTable(); da3.Fill(dt3); GridView4.DataSource = dt3; GridView4.DataBind(); SqlDataAdapter da4 = new SqlDataAdapter(" SELECT F.TitluFilm as 'Titlu Film' FROM Film F ORDER BY (SELECT Sum(R.NumarBilete) FROM Rezervare R inner join Bilet B ON R.RezervareID = B.RezervareID INNER JOIN [User] U ON U.UserID = R.UserID INNER JOIN Film FF ON B.FilmID = FF.FilmID where ff.filmid = f.filmid group by ff.filmid) desc ", con); DataTable dt4 = new DataTable(); da4.Fill(dt4); GridView5.DataSource = dt4; GridView5.DataBind(); SqlDataAdapter da5 = new SqlDataAdapter("SELECT R.NumarRezervare, R.NumarBilete, U.Username FROM Rezervare R INNER JOIN [User] U ON U.UserID = R.UserID WHERE U.Username ='******'", con); DataTable dt5 = new DataTable(); da5.Fill(dt5); GridView6.DataSource = dt5; GridView6.DataBind(); SqlDataAdapter da6 = new SqlDataAdapter("SELECT R.NumarRezervare, P.Platit FROM Rezervare R INNER JOIN Plata P ON P.RezervareID = r.RezervareID", con); DataTable dt6 = new DataTable(); da6.Fill(dt6); GridView7.DataSource = dt6; GridView7.DataBind(); SqlDataAdapter da7 = new SqlDataAdapter("SELECT * FROM [USER] U INNER JOIN Rezervare R ON U.UserID = R.UserID", con); DataTable dt7 = new DataTable(); da7.Fill(dt7); GridView8.DataSource = dt7; GridView8.DataBind(); SqlDataAdapter da8 = new SqlDataAdapter("SELECT R.NumarRezervare, P.Platit FROM Plata P INNER JOIN Rezervare R ON P.RezervareID = R.RezervareID WHERE P.Platit = 'DA' ", con); DataTable dt8 = new DataTable(); da8.Fill(dt8); GridView9.DataSource = dt8; GridView9.DataBind(); con.Close(); // Response.Write("<script>alert('Total Bilete');</script>"); } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } }
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 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
public void getbankdeatils() { DateTime dt1 = new DateTime(); DateTime dt2 = new DateTime(); string d1 = dt1.ToString("MM/dd/yyyy"); string d2 = dt2.ToString("MM/dd/yyyy"); DBManager vdm = new DBManager(); DateTime ServerDateCurrentdate = DBManager.GetTime(vdm.conn); string branch = ddlbranch.SelectedItem.Value; string month = ddlmonth.SelectedItem.Value; string year = ddlyear.SelectedItem.Value; string get; string fileid = ""; string d3 = ddl_filename.SelectedItem.Value.ToString(); SqlCommand cmd = new SqlCommand("SELECT subbankformatmaster.empid, subbankformatmaster.empname, subbankformatmaster.designation, subbankformatmaster.bankaccountno, subbankformatmaster.ifsccode, subbankformatmaster.Companyid, subbankformatmaster.branchid, subbankformatmaster.employecode, subbankformatmaster.emptype, subbankformatmaster.bankid, subbankformatmaster.deptid, subbankformatmaster.refno, subbankformatmaster.mobileno, subbankformatmaster.month, subbankformatmaster.year, CONVERT(int, subbankformatmaster.netpay) AS AMOUNT, bankmaster.bankname FROM subbankformatmaster INNER JOIN bankmaster ON subbankformatmaster.bankid = bankmaster.sno WHERE subbankformatmaster.branchid=@branchid AND month=@month AND year=@year AND refno=@refno"); cmd.Parameters.Add("@branchid", branch); cmd.Parameters.Add("@month", month); cmd.Parameters.Add("@year", year); cmd.Parameters.Add("@refno", d3); DataTable dt = vdm.SelectQuery(cmd).Tables[0]; showreport.Rows.Clear(); showreport.Columns.Clear(); showreport.Columns.Add("Report"); foreach (DataRow dr in dt.Rows) { string getagentid = dr["empid"].ToString(); string Agent_Name = dr["empname"].ToString(); string Ifsccode = dr["ifsccode"].ToString(); string Account_no = dr["bankaccountno"].ToString(); Account_no = Account_no.Replace("'", String.Empty).TrimStart(); // string Account_no double NetAmount = Convert.ToDouble(dr["AMOUNT"].ToString()); string date = ServerDateCurrentdate.ToString("dd/MM/yyyy"); string pmail = "*****@*****.**"; string milktype = "Salary"; string plcode = dr["employecode"].ToString(); int bankid = Convert.ToInt16(dr["bankid"].ToString()); string mobile = dr["mobileno"].ToString(); string accountnu = ddl_kotacklist.SelectedItem.Value; string companyname = "Vyshnavi Dairy"; string pay = "RPAY"; if (bankid == 8) { paymode = "IFT"; } if (bankid != 8) { if (NetAmount > 200000) { paymode = "RTGS"; } else { paymode = "NEFT"; } } if ((accountnu == "425044000438") || (accountnu == "328044039913") || (accountnu == "334044049195") || (accountnu == "337044040029")) { ptype = "SVDSPL"; } if (accountnu == "334044032411") { ptype = "SVDPL"; } DateTime dtt = new DateTime(); dtt = System.DateTime.Now; string condate = dtt.ToString("dd/MM/yyyy"); // string[] SPP = string LOCALPLANT = ddlbranch.SelectedItem.Text; statement = ptype + "~" + pay + "~" + paymode + "~~" + condate + "~" + accountnu + "~" + NetAmount + "~~" + Agent_Name + "~" + Ifsccode + "~" + Account_no + "~" + pmail + "~" + mobile + "~" + LOCALPLANT + getagentid + "~" + companyname + "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"; showreport.Rows.Add(statement); } if (showreport.Rows.Count > 0) { GridView9.DataSource = showreport; GridView9.DataBind(); Visible = false; } // Agent_Id, Agent_Name, Ifsccode, Account_no, NetAmount, Date, Pmail, Milktype, Plant_Code, Bank_Id, phone_Number // con = dbaccess.GetConnection(); // string getquery = "select Agent_Id,Agent_Name,Ifsccode,Account_no,convert(decimal(18,0),floor(NetAmount)) as NetAmount,Date,Pmail,Milktype,Plant_Code,Bank_Id from (select Agent_Id,Agent_Name,Ifsccode,Account_no,NetAmount,Plant_Code,convert(varchar,Added_Date,103) as Date,Bank_id from BankPaymentllotment where plant_code='" + pcode + "' and Billfrmdate='" + d1 + "' and Billtodate='" + d2 + "' AND BankFileName='" + ddl_filename.SelectedItem.Text + "' and NetAmount > 0) as ff left join (Select pmail,Milktype,Plant_Code as pcode from Plant_Master where plant_code='" + pcode + "' ) as pm on ff.Plant_Code= pm.pcode order by Date asc"; // string getquery = "sELECT Agent_Id,Agent_Name,Ifsccode,Account_no,convert(decimal(18,0),floor(NetAmount)) as NetAmount,Date,Pmail,Milktype,Plant_Code,Bank_Id,phone_Number FROM (select Agent_Id,Agent_Name,Ifsccode,Account_no,convert(decimal(18,0),floor(NetAmount)) as NetAmount,Date,Pmail,Milktype,Plant_Code,Bank_Id from (select Agent_Id,Agent_Name,Ifsccode,Account_no,NetAmount,Plant_Code,convert(varchar,Added_Date,103) as Date,Bank_id from BankPaymentllotment where plant_code='" + pcode + "' and Billfrmdate='" + d1 + "' and Billtodate='" + d2 + "' AND BankFileName='" + ddl_filename.SelectedItem.Text + "' and NetAmount > 0) as ff left join (Select pmail,Milktype,Plant_Code as pcode from Plant_Master where plant_code='" + pcode + "' ) as pm on ff.Plant_Code= pm.pcode ) AS FF LEFT JOIN (sELECT Plant_code AS amplantcode,Agent_Id as agent,phone_Number FROM Agent_Master WHERE plant_code='" + pcode + "' GROUP BY Plant_code,Agent_Id,phone_Number) AS AM ON FF.Plant_Code=AM.amplantcode and FF.Agent_Id=AM.agent"; }
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 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='11' 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='10' 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_Remark14.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) { 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(); } }
public void fetchdata() { string connectionString = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand c = new SqlCommand("select papername from Publication where btype='General science' and published='Yes'", con); SqlDataReader rdr = c.ExecuteReader(); GridView1.DataSource = rdr; GridView1.DataBind(); GridView1.GridLines = GridLines.None; rdr.Close(); con.Close(); con.Open(); SqlCommand c2 = new SqlCommand("select papername from Publication where btype='Neuroscience & Psychology' and published='Yes'", con); SqlDataReader rdr2 = c2.ExecuteReader(); GridView2.DataSource = rdr2; GridView2.DataBind(); GridView2.GridLines = GridLines.None; rdr2.Close(); con.Close(); con.Open(); SqlCommand c3 = new SqlCommand("select papername from Publication where btype='Genetics & Molicular Biology' and published='Yes'", con); SqlDataReader rdr3 = c3.ExecuteReader(); GridView3.DataSource = rdr3; GridView3.DataBind(); GridView3.GridLines = GridLines.None; rdr3.Close(); con.Close(); con.Open(); SqlCommand c4 = new SqlCommand("select papername from Publication where btype='Biochemistry' and published='Yes'", con); SqlDataReader rdr4 = c4.ExecuteReader(); GridView4.DataSource = rdr4; GridView4.DataBind(); GridView4.GridLines = GridLines.None; rdr4.Close(); con.Close(); con.Open(); SqlCommand c5 = new SqlCommand("select papername from Publication where btype='Engineering' and published='Yes'", con); SqlDataReader rdr5 = c5.ExecuteReader(); GridView5.DataSource = rdr5; GridView5.DataBind(); GridView5.GridLines = GridLines.None; rdr5.Close(); con.Close(); con.Open(); SqlCommand c6 = new SqlCommand("select papername from Publication where btype='Chemistry' and published='Yes'", con); SqlDataReader rdr6 = c6.ExecuteReader(); GridView6.DataSource = rdr6; GridView6.DataBind(); GridView6.GridLines = GridLines.None; rdr6.Close(); con.Close(); con.Open(); SqlCommand c7 = new SqlCommand("select papername from Publication where btype='Physics' and published='Yes'", con); SqlDataReader rdr7 = c7.ExecuteReader(); GridView7.DataSource = rdr7; GridView7.DataBind(); GridView7.GridLines = GridLines.None; rdr7.Close(); con.Close(); con.Open(); SqlCommand c8 = new SqlCommand("select papername from Publication where btype='Material Sciences' and published='Yes'", con); SqlDataReader rdr8 = c8.ExecuteReader(); GridView8.DataSource = rdr8; GridView8.DataBind(); GridView8.GridLines = GridLines.None; rdr8.Close(); con.Close(); con.Open(); SqlCommand c9 = new SqlCommand("select papername from Publication where btype='Social & Political Science' and published='Yes'", con); SqlDataReader rdr9 = c9.ExecuteReader(); GridView9.DataSource = rdr9; GridView9.DataBind(); GridView9.GridLines = GridLines.None; rdr9.Close(); con.Close(); con.Open(); SqlCommand c10 = new SqlCommand("select papername from Publication where btype='Earth & Environmental Science' and published='Yes'", con); SqlDataReader rdr10 = c10.ExecuteReader(); GridView10.DataSource = rdr10; GridView10.DataBind(); GridView10.GridLines = GridLines.None; rdr10.Close(); con.Close(); con.Open(); SqlCommand c11 = new SqlCommand("select papername from Publication where btype='Chemical Engineering' and published='Yes'", con); SqlDataReader rdr11 = c11.ExecuteReader(); GridView11.DataSource = rdr11; GridView11.DataBind(); GridView11.GridLines = GridLines.None; rdr11.Close(); con.Close(); con.Open(); SqlCommand c12 = new SqlCommand("select papername from Publication where btype='Medical' and published='Yes'", con); SqlDataReader rdr12 = c12.ExecuteReader(); GridView12.DataSource = rdr12; GridView12.DataBind(); GridView12.GridLines = GridLines.None; rdr12.Close(); con.Close(); con.Open(); SqlCommand c13 = new SqlCommand("select papername from Publication where btype='Agri Food & Aqua' and published='Yes'", con); SqlDataReader rdr13 = c13.ExecuteReader(); GridView13.DataSource = rdr13; GridView13.DataBind(); GridView13.GridLines = GridLines.None; rdr13.Close(); con.Close(); con.Open(); SqlCommand c14 = new SqlCommand("select papername from Publication where btype='Immunology & Microbiology' and published='Yes'", con); SqlDataReader rdr14 = c14.ExecuteReader(); GridView14.DataSource = rdr14; GridView14.DataBind(); GridView14.GridLines = GridLines.None; rdr14.Close(); con.Close(); con.Open(); SqlCommand c15 = new SqlCommand("select papername from Publication where btype='Pharmaceutical Sciences' and published='Yes'", con); SqlDataReader rdr15 = c15.ExecuteReader(); GridView15.DataSource = rdr15; GridView15.DataBind(); GridView15.GridLines = GridLines.None; rdr15.Close(); con.Close(); con.Open(); SqlCommand c16 = new SqlCommand("select papername from Publication where btype='Informatics' and published='Yes'", con); SqlDataReader rdr16 = c16.ExecuteReader(); GridView16.DataSource = rdr16; GridView16.DataBind(); GridView16.GridLines = GridLines.None; rdr16.Close(); con.Close(); con.Open(); SqlCommand c17 = new SqlCommand("select papername from Publication where btype='Business and Management' and published='Yes'", con); SqlDataReader rdr17 = c17.ExecuteReader(); GridView17.DataSource = rdr17; GridView17.DataBind(); GridView17.GridLines = GridLines.None; rdr17.Close(); con.Close(); }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["U_name"] == null) { Response.Redirect("AdminLogin.aspx"); } else { GetcountofComments(); SqlDataAdapter da1 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='1'", con); DataSet ds1 = new DataSet(); da1.Fill(ds1, "tbl_CompltChangeCommentCount"); GridView2.DataSource = ds1; GridView2.DataBind(); SqlDataAdapter da2 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='2'", con); DataSet ds2 = new DataSet(); da2.Fill(ds2, "tbl_CompltChangeCommentCount"); GridView3.DataSource = ds2; GridView3.DataBind(); SqlDataAdapter da3 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='3'", con); DataSet ds3 = new DataSet(); da3.Fill(ds3, "tbl_CompltChangeCommentCount"); GridView4.DataSource = ds3; GridView4.DataBind(); SqlDataAdapter da4 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='4'", con); DataSet ds4 = new DataSet(); da4.Fill(ds4, "tbl_CompltChangeCommentCount"); GridView5.DataSource = ds4; GridView5.DataBind(); SqlDataAdapter da5 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='5'", con); DataSet ds5 = new DataSet(); da5.Fill(ds5, "tbl_CompltChangeCommentCount"); GridView6.DataSource = ds5; GridView6.DataBind(); SqlDataAdapter da6 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='6'", con); DataSet ds6 = new DataSet(); da6.Fill(ds6, "tbl_CompltChangeCommentCount"); GridView7.DataSource = ds6; GridView7.DataBind(); SqlDataAdapter da7 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='7'", con); DataSet ds7 = new DataSet(); da7.Fill(ds7, "tbl_CompltChangeCommentCount"); GridView8.DataSource = ds7; GridView8.DataBind(); SqlDataAdapter da8 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='8'", con); DataSet ds8 = new DataSet(); da8.Fill(ds8, "tbl_CompltChangeCommentCount"); GridView9.DataSource = ds8; GridView9.DataBind(); SqlDataAdapter da9 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='9'", con); DataSet ds9 = new DataSet(); da9.Fill(ds9, "tbl_CompltChangeCommentCount"); GridView10.DataSource = ds9; GridView10.DataBind(); SqlDataAdapter da10 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='10'", con); DataSet ds10 = new DataSet(); da10.Fill(ds10, "tbl_CompltChangeCommentCount"); GridView11.DataSource = ds10; GridView11.DataBind(); SqlDataAdapter da11 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='11'", con); DataSet ds11 = new DataSet(); da11.Fill(ds11, "tbl_CompltChangeCommentCount"); GridView12.DataSource = ds11; GridView12.DataBind(); SqlDataAdapter da12 = new SqlDataAdapter("select CityName as[City],GoodCnt as [Good Cmnt],BadCnt as [Bad Cmnt],CantSayCnt as [Cant Say Cmnt],TotalCnt as [Total],TotalNoTcmnt as [Not Cmnt],TotalVisitors as [Total Visitors] from tbl_CompltChangeCommentCount where Pro_id='12'", con); DataSet ds12 = new DataSet(); da12.Fill(ds12, "tbl_CompltChangeCommentCount"); GridView13.DataSource = ds12; GridView13.DataBind(); } } catch (Exception) { } }
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(); } }
public void resultRepeat() { try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("S.S.T", bd); if (registros.Rows.Count > 0) { GridView1.DataSource = registros; GridView1.DataBind(); } else { GridView1.DataSource = null; GridView1.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("P.E.S.V", bd); if (registros.Rows.Count > 0) { GridView2.DataSource = registros; GridView2.DataBind(); } else { GridView2.DataSource = null; GridView2.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("RRHH", bd); if (registros.Rows.Count > 0) { GridView3.DataSource = registros; GridView3.DataBind(); } else { GridView3.DataSource = null; GridView3.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("Correspondencia", bd); if (registros.Rows.Count > 0) { GridView4.DataSource = registros; GridView4.DataBind(); } else { GridView4.DataSource = null; GridView4.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("Plan_Contingencia", bd); if (registros.Rows.Count > 0) { GridView5.DataSource = registros; GridView5.DataBind(); } else { GridView5.DataSource = null; GridView5.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("Covid_19", bd); if (registros.Rows.Count > 0) { GridView6.DataSource = registros; GridView6.DataBind(); } else { GridView6.DataSource = null; GridView6.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("Examen_MA", bd); if (registros.Rows.Count > 0) { GridView7.DataSource = registros; GridView7.DataBind(); } else { GridView7.DataSource = null; GridView7.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("Plan_MA", bd); if (registros.Rows.Count > 0) { GridView8.DataSource = registros; GridView8.DataBind(); } else { GridView8.DataSource = null; GridView8.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("CursosMA", bd); if (registros.Rows.Count > 0) { GridView9.DataSource = registros; GridView9.DataBind(); } else { GridView9.DataSource = null; GridView9.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } try { String bd = Session["BD"].ToString(); var registros = Controlasql.ClistFiles("Formatos_sanidad", bd); if (registros.Rows.Count > 0) { GridView10.DataSource = registros; GridView10.DataBind(); } else { GridView10.DataSource = null; GridView10.DataBind(); } } catch (Exception ex) { alerta.MessageBox(this, $"{ex}"); // Response.Redirect("Exceptionnet.aspx"); } }