protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { string conString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; string selectString = "SELECT * FROM tb_Userinfo WHERE Username='******'";//select string for search currency name correspond with the input SqlDataSource dsrc = new SqlDataSource(conString, selectString); DataView DV = (DataView)dsrc.Select(DataSourceSelectArguments.Empty); if (DV.Table.Rows.Count > 0) { string password = (string)DV.Table.Rows[0][7]; if (password.Equals(Login1.Password)) { //Label1.Text = "Congratulations! Login succeed! Please wait for redirect to Homepage!"; Session["Username"] = Login1.UserName; Session["Call"] = DV.Table.Rows[0][1].ToString(); Server.Transfer("~/WebSite2/Default.aspx"); //Response.Write("<script language=javascript>alert('Congratulations! Login succeed!')</script>"); //System.Threading.Thread.Sleep(5000); //Response.Redirect("~/WebSite2/Default.aspx"); } else e.Authenticated = false; } else e.Authenticated = false; }
protected void Page_Load(object sender, EventArgs e) { try { String userName = Session["Username"].ToString(); string conString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; string selectString = "SELECT * FROM [tb_Userinfo] WHERE Username='******'";//select string for search currency name correspond with the input SqlDataSource dsrc = new SqlDataSource(conString, selectString); DataView DV = (DataView)dsrc.Select(DataSourceSelectArguments.Empty); username.Text = DV.Table.Rows[0][6].ToString(); Call.Text = DV.Table.Rows[0][1].ToString(); email.Text = DV.Table.Rows[0][3].ToString(); Phone.Text = DV.Table.Rows[0][5].ToString(); if(DV.Table.Rows[0][2].ToString()=="Male") RadioGenderList.Items[0].Selected=true; else RadioGenderList.Items[1].Selected = true; switch (DV.Table.Rows[0][4].ToString()) { case "BuCentral": RadioAreaList.Items[1].Selected = true; break; case "BuWest": RadioAreaList.Items[0].Selected = true; break; case "BuEast": RadioAreaList.Items[2].Selected = true; break; case "BuOther": RadioAreaList.Items[3].Selected = true; break; } Register.Text = "Update"; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void executeQuery() { x = new SqlDataSource(); x.ConnectionString = @"Data Source=iii0.database.windows.net;Initial Catalog=prjTRK;Persist Security Info=True;User ID=iii;Password=P@ssw0rd"; x.SelectCommand = "Select * from Company where companyID='" + companyID + "'"; DataView dv = x.Select(DataSourceSelectArguments.Empty) as DataView; txtCounterInput.Text = dv.Table.Rows[0]["name"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { try { RestaurantName = Session["Restaurantname"].ToString(); LabelRname.Text = RestaurantName; //Session.Remove("Restaurantname"); Image1.ImageUrl = "~/WebSite2/Image/BU Central/" + RestaurantName + ".jpg"; string conString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; string selectString = "SELECT * FROM tb_Restaurant WHERE Name='" + RestaurantName +"'";//select string for search currency name correspond with the input SqlDataSource dsrc = new SqlDataSource(conString, selectString); DataView DV = (DataView)dsrc.Select(DataSourceSelectArguments.Empty); LabelAddress.Text = DV.Table.Rows[0][2].ToString(); LabelContact.Text = DV.Table.Rows[0][3].ToString(); LabelCuisine.Text = DV.Table.Rows[0][4].ToString(); float a = float.Parse(DV.Table.Rows[0][5].ToString()); float b = (float)(Math.Round(a * 100)) / 100; LabelRate.Text = b.ToString(); LabelDescription.Text = DV.Table.Rows[0][7].ToString(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } try { UserName = Session["Username"].ToString(); UserCall = Session["Call"].ToString(); string conString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; string selectString = "SELECT * FROM tb_Review WHERE Uname='" + UserCall + "' AND Rname='" + RestaurantName + "'";//select string for search currency name correspond with the input SqlDataSource dsrc = new SqlDataSource(conString, selectString); DataView DV = (DataView)dsrc.Select(DataSourceSelectArguments.Empty); if (DV.Table.Rows.Count > 0) { LabelReviewRate.Visible = false; LabelReviewContent.Visible = false; TextBoxRate.Visible = false; TextBox1.Visible = false; Button1.Visible = false; } } catch (Exception ex) { LabelReviewRate.Visible = false; LabelReviewContent.Visible = false; TextBoxRate.Visible = false; TextBox1.Visible = false; Button1.Visible = false; Console.WriteLine(ex.ToString()); } }
protected void SubmitButton_Click1(object sender, EventArgs e) { string conString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; string selectString = "SELECT * FROM tb_Userinfo WHERE Username='******'";//select string for search currency name correspond with the input SqlDataSource dsrc = new SqlDataSource(conString, selectString); DataView DV = (DataView)dsrc.Select(DataSourceSelectArguments.Empty); if (DV.Table.Rows.Count > 0) { Session["UserForgetName"] = PasswordRecovery1.UserName; Server.Transfer("ForgetPassword.aspx"); } else PasswordRecovery1.UserNameFailureText = "Username not exists! "; }
public ronUtil2(int id) { DaysAvailable = getDaysAvailable(id); SqlDataSource SqlDataSource3 = new SqlDataSource(); SqlDataSource3.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource3.SelectCommand = "Select First_Name,Last_Name,Employee_ID,Dept_id,Image From Advisor Where Employee_ID='" + id.ToString() + "'"; DataView view3 = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); DataTable table3 = view3.ToTable(); if (table3.Rows.Count > 0) FullName = table3.Rows[0][0].ToString() + " " + table3.Rows[0][1].ToString(); First_Name = table3.Rows[0][0].ToString(); Last_Name = table3.Rows[0][1].ToString(); Employee_ID = table3.Rows[0][2].ToString(); Dept_id = table3.Rows[0][2].ToString(); Image = table3.Rows[0][3].ToString(); }
protected void btnNewsUpdate_Click(object sender, EventArgs e) { //actID 已知的活動代碼 //用where查狀態是否還為"待審中" //是待審中再進行更新動作 //是上架就進行Question 警告使用者 更新後, 將重新送審 x = new SqlDataSource(); x.ConnectionString = @"Data Source=iii0.database.windows.net;Initial Catalog=prjTRK;Persist Security Info=True;User ID=iii;Password=P@ssw0rd"; x.SelectCommand = "Select *from Promotions where activityID ='" + activity.Text + "'"; DataView dv = x.Select(DataSourceSelectArguments.Empty) as DataView; statusID = dv.Table.Rows[0]["statusID"].ToString(); if (statusID == "3" || statusID == "4") { //壓縮圖片並存檔 CImageProess.get().UploadImage(FileUpload1, 資料夾路徑, CDictionary.SET_PROMOTION_PX); x = new SqlDataSource(); x.ConnectionString = @"Data Source=iii0.database.windows.net;Initial Catalog=prjTRK;Persist Security Info=True;User ID=iii;Password=P@ssw0rd"; string sql = "UPDATE Promotions set "; if (!string.IsNullOrEmpty(titleInput.Text)) { sql += " title=N'" + titleInput.Text + "', "; if (FileUpload1.HasFile) sql += " picPath='" + CImageProess.imageName + "', "; sql += " startDate='" + startDate.Text + "', "; sql += " endDate='" + endDate.Text + "', "; sql += " onShelfDate = convert(varchar, DATEADD(hour, 8, GETUTCDATE()), 113)," ; sql += " statusID = 3 ,"; sql += " content=N'" + txtNewsContent.Text + "' "; sql += " WHERE activityID='" + activity.Text + "'"; x.UpdateCommand = sql; x.Update(); Response.Redirect("~/windowCompany/companyCheck.aspx"); } else return; } else return; }
protected void Page_Load(object sender, EventArgs e) { try { string username = Session["Username"].ToString(); string conString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; string selectString = "SELECT * FROM tb_Userinfo WHERE Username='******'";//select string for search currency name correspond with the input SqlDataSource dsrc = new SqlDataSource(conString, selectString); DataView DV = (DataView)dsrc.Select(DataSourceSelectArguments.Empty); Call.Text = DV.Table.Rows[0][1].ToString(); Gender.Text = DV.Table.Rows[0][2].ToString(); email.Text = DV.Table.Rows[0][3].ToString(); phone.Text = DV.Table.Rows[0][5].ToString(); area.Text = DV.Table.Rows[0][4].ToString(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
protected void Button1_Click(object sender, EventArgs e) { DateTime date = DateTime.Now; string content = TextBox1.Text.Trim(); float rate=float.Parse(TextBoxRate.Text.Trim()); string conString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; SqlConnection conn = new SqlConnection(conString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO tb_Review (Rname, Uname, Content, Date, Rate)VALUES ('" + RestaurantName + "', '" + Session["Call"] + "', '" + content + "', '" + date + "','"+rate+"')"; cmd.ExecuteNonQuery(); //Complete Insertion then update new rate string conString2 = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; string selectString = "SELECT * FROM tb_Review WHERE Rname='" + RestaurantName + "'";//select string for search currency name correspond with the input SqlDataSource dsrc = new SqlDataSource(conString2, selectString); DataView DV = (DataView)dsrc.Select(DataSourceSelectArguments.Empty); int rowsCount=DV.Table.Rows.Count; float Ratesum=0; float newRate = 0; if (rowsCount > 0) { for(int i=0;i<rowsCount;i++) Ratesum+=float.Parse(DV.Table.Rows[i][5].ToString()); newRate = Ratesum / rowsCount; cmd.CommandText = "Update tb_Restaurant set Rate='"+newRate+"',Ratenum='"+rowsCount+"' where Name='"+RestaurantName+"'"; cmd.ExecuteNonQuery(); } conn.Close(); TextBox1.Visible = false; Button1.Visible = false; Session["Restaurantname"] = RestaurantName; Session["Username"] = UserName; Server.Transfer("Restaurant.aspx"); //Response.Redirect(Request.Url.ToString()); //string selectString = "INSERT INTO tb_Review (Rname, Uname, Content, Date)VALUES ('RestaurantName', 'Username', 'content', 'date')";//select string for search currency name correspond with the input //SqlDataSource dsrc = new SqlDataSource(conString, selectString); }
/// <summary> /// เรียกดูข้อมูลจากตาราง COURSESUBJECTTYPE /// </summary> /// <param name="sql">SQL Command</param> /// <returns>ข้อมูลจากตาราง COURSESUBJECTTYPE</returns> public List <CourseSubjectType> getCourseGroupManual(string sql) { List <CourseSubjectType> CourseSubjectTypeData = new List <CourseSubjectType>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { CourseSubjectType CourseSubjectTypeRow = new CourseSubjectType(); CourseSubjectTypeRow.CourseTypeCode = rowData["COURSETYPECODE"].ToString(); CourseSubjectTypeRow.CourseTypeThaiName = rowData["COURSETYPETHAINAME"].ToString(); CourseSubjectTypeRow.CourseTypeEngName = rowData["COURSETYPEENGNAME"].ToString(); CourseSubjectTypeData.Add(CourseSubjectTypeRow); } return(CourseSubjectTypeData); }
//Pongsarun 26/2/2016: use for config system public List <SpecialFieldData> getSpecialFieldManual(string sql) { List <SpecialFieldData> SpecialFielData = new List <SpecialFieldData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { SpecialFieldData SpecialField_data = new SpecialFieldData(); SpecialField_data.SpecialField_Code = rowData["SPEC_FIELD_CODE"].ToString(); SpecialField_data.SpecialField_Thai = rowData["SPEC_FIELD_THAINAME"].ToString(); SpecialField_data.SpecialField_Eng = rowData["SPEC_FIELD_ENGNAME"].ToString(); SpecialField_data.SpecialField_ShortName = rowData["SPEC_FIELD_SHORTNAME"].ToString(); SpecialField_data.SpecialField_FacultyCode = rowData["FACULTY_CODE"].ToString(); SpecialField_data.SpecialField_Status = rowData["SPEC_FIELD_STATUS"].ToString(); SpecialFielData.Add(SpecialField_data); } return(SpecialFielData); }
public List <OfficeData> getOffice() { List <OfficeData> Office_data = new List <OfficeData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From OFFICE Order By OFFICE_CODE"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { OfficeData Office = new OfficeData(); Office.Office_Code = rowData["OFFICE_CODE"].ToString(); Office.Office_Thai = rowData["OFFICE_THAINAME"].ToString(); Office.Office_Eng = rowData["OFFICE_ENGNAME"].ToString(); Office.Office_ShortName = rowData["OFFICE_SHORTNAME"].ToString(); Office.Office_CampusCode = rowData["CAMPUS_CODE"].ToString(); Office.Office_Status = rowData["OFFICE_STATUS"].ToString(); Office_data.Add(Office); } return(Office_data); }
/// <summary> /// เรียกดูข้อมูลจากตาราง TQF1LEANING /// </summary> /// <returns>ข้อมูลจากตาราง TQF1LEANING</returns> public List <TQF1Leaning> getTQF1Leaning() { List <TQF1Leaning> TQF1LeaningData = new List <TQF1Leaning>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From TQF1LEANING Order By NUMTQF1"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { TQF1Leaning TQF1LeaningRow = new TQF1Leaning(); TQF1LeaningRow.NUMTQF1Leaning = rowData["NUMTQF1LEANING"].ToString(); TQF1LeaningRow.DomainTypeCode = rowData["DOMAINTYPECODE"].ToString(); TQF1LeaningRow.NUMTQF1 = rowData["NUMTQF1"].ToString(); TQF1LeaningRow.Detailtype = rowData["DETAILTYPE"].ToString(); TQF1LeaningRow.UUIDNumber = rowData["UUIDNUMBER"].ToString(); TQF1LeaningData.Add(TQF1LeaningRow); } return(TQF1LeaningData); }
protected void dbLoad2() //load資料 { intuId = Convert.ToInt32(Session["Uid"]); SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = @"Data Source=.;Initial Catalog=Guardian_Angel;Integrated Security=True;"; sds.SelectCommand = "SELECT * FROM Message INNER JOIN Oldman_Data ON Message.O_Id = Oldman_Data.O_Id where U_id = " + intuId + " ORDER BY M_date DESC"; GridView1.DataSource = sds.Select(DataSourceSelectArguments.Empty); GridView1.Font.Bold = true; //GridView GridView1.BorderColor = Color.Blue; GridView1.BorderWidth = 2; GridView1.RowStyle.Font.Size = 13; GridView1.RowStyle.Font.Name = "微軟正黑體"; GridView1.Style.Add("word-break", "keep-all"); //標題列 GridView1.ForeColor = Color.Black; GridView1.HeaderStyle.Height = 40; GridView1.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; GridView1.EmptyDataRowStyle.VerticalAlign = VerticalAlign.Middle; GridView1.DataBind(); }
/// <summary> /// เรียกดูข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN /// </summary> /// <param name="CourseCode">รหัสวิชา(Course)</param> /// <returns>ข้อมูลจากตาราง TQF2SEC3SEMESTERPLAN</returns> public TQF2Sec3SemesterPlan getTQF2Sec3SemesterPlan(string CourseCode) { TQF2Sec3SemesterPlan TQF2Sec3SemesterPlanData = new TQF2Sec3SemesterPlan(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From TQF2SEC3SEMESTERPLAN Where COURSECODE='" + CourseCode + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { TQF2Sec3SemesterPlanData.CurrCode = rowData["CURRCODE"].ToString(); TQF2Sec3SemesterPlanData.YearVersion = rowData["YEARVERSION"].ToString(); TQF2Sec3SemesterPlanData.CurrFormatCode = rowData["CURRFORMATCODE"].ToString(); TQF2Sec3SemesterPlanData.CurrTypeCode = rowData["CURRTYPECODE"].ToString(); TQF2Sec3SemesterPlanData.MajorCode = rowData["MAJORCODE"].ToString(); TQF2Sec3SemesterPlanData.CourseCode = rowData["COURSECODE"].ToString(); TQF2Sec3SemesterPlanData.EducationYear = rowData["EDUCATIONYEAR"].ToString(); TQF2Sec3SemesterPlanData.EducationSemester = rowData["EDUCATIONSEMESTER"].ToString(); } return(TQF2Sec3SemesterPlanData); }
public ronUtil(int id) { DaysAvailable = getDaysAvailable(id); SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select * From AdvisorSchedule Where Advisor_Id='" + id.ToString() + "'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); DayStart = table.Rows[0][2].ToString(); DayFinish = table.Rows[0][3].ToString(); StartDate = table.Rows[0][4].ToString(); FinishDate = table.Rows[0][5].ToString(); SqlDataSource SqlDataSource3 = new SqlDataSource(); SqlDataSource3.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource3.SelectCommand = "Select * From Advisor_Master Where Advisor_Id='" + id.ToString() + "'"; DataView view3 = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); DataTable table3 = view3.ToTable(); FullName = table3.Rows[0][1].ToString() + " " + table3.Rows[0][2].ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["login_data"] == null) { Response.Redirect("../index.aspx"); } else { login_data = (UserLoginData)Session["login_data"]; if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { divFail.Visible = false; if ((Session["save_data"] != null) && (Session["service_course"] != null)) { ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); available_data = (AvailableCourseData)Session["save_data"]; service_code = (bool)Session["service_course"]; CurriculumGeneralData curr = new Curriculum().getCurriculum(available_data.Curr_Code); degree_char = curr.Degree_Char; CourseData course_data = new CourseData(); Course course = new Course(); List <string> all_course = new List <string>(); string TableName = new AvailableCourse().getTableName(degree_char); string sql = ""; if (service_code == true) { lblFaculty.Text = "วิชาบริการศึกษา"; lblCurri.Text = curr.Curr_ThaiName + " (ปีหลักสูตร " + curr.Curr_Year + ")"; // ตรวจสอบกำหนดการ int diffDate = -1; config_data1 = new TeachExamConfig().getTeachExamConfig(); if (config_data1.Date_Stop != null) { diffDate = utlObj.getDiffDate(config_data1.Date_Stop, utlObj.getToday()); } //วิชาการคณะ if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty); sql = "Select COURSE_CODE From " + TableName + " Where ACADEMIC_YEAR='" + available_data.AcademicYear + "' And SEMESTER='" + available_data.Semester + "' And CURR_CODE='" + available_data.Curr_Code + "' And ("; int ii = 0; foreach (string fac in faculty_authorized) { ii++; sql += "FACULTY_CODE= '" + fac + "'"; if (faculty_authorized.Count != ii) { sql += " OR "; } } sql += ") GROUP By COURSE_CODE Order By COURSE_CODE"; } //วิชาการภาค else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); sql = "Select COURSE_CODE From " + TableName + " Where ACADEMIC_YEAR='" + available_data.AcademicYear + "' And SEMESTER='" + available_data.Semester + "' And CURR_CODE='" + available_data.Curr_Code + "' And ("; int ii = 0; foreach (string dep in department_authorized) { ii++; sql += "DEPARTMENT_CODE= '" + dep + "'"; if (department_authorized.Count != ii) { sql += " OR "; } } sql += ") GROUP By COURSE_CODE Order By COURSE_CODE"; } oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); all_course.Clear(); foreach (DataRowView rowData in allData) { int diffExtDate = -1; config_data2 = new TeachExamConfig().getExtendTeachExamConfig(rowData["COURSE_CODE"].ToString().Substring(0, 4)); if (config_data2.Date_Stop != null) { diffExtDate = utlObj.getDiffDate(config_data2.Date_Stop, utlObj.getToday()); } if (diffDate >= 0) { all_course.Add(rowData["COURSE_CODE"].ToString()); } else if (diffExtDate >= 0) { all_course.Add(rowData["COURSE_CODE"].ToString()); } } } else if (service_code == false) { lblFaculty.Text = new Faculty().getFaculty(available_data.Faculty_Code).Faculty_Thai; lblCurri.Text = curr.Curr_Code + " " + curr.Curr_ThaiName; sql = "Select COURSE_CODE From " + TableName + " Where ACADEMIC_YEAR='" + available_data.AcademicYear + "' And SEMESTER='" + available_data.Semester + "' And FACULTY_CODE='" + available_data.Faculty_Code + "' And DEPARTMENT_CODE='" + available_data.Department_Code + "' And CURR_CODE='" + available_data.Curr_Code + "' GROUP By COURSE_CODE Order By COURSE_CODE"; oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { all_course.Add(rowData["COURSE_CODE"].ToString()); } } RadioButton[] radio = new RadioButton[all_course.Count]; int i = 0; // Head Table string[] ar = { "รหัสวิชา", "ชื่อวิชา", "หน่วยกิต", "เลือก" }; Table tb1 = new Table(); tb1.Attributes.Add("class", "table table-bordered table-hover"); tb1.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++) { // Create a new cell and add it to the row. TableHeaderCell cellHead = new TableHeaderCell(); cellHead.Attributes.Add("class", "text-center"); cellHead.Text = ar[cellCtr - 1]; tRowHead.Cells.Add(cellHead); } tb1.Rows.Add(tRowHead); foreach (string course_code in all_course) { TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; course_data = course.getCourse(course_code); if (course_data.Practice != 0 && course_data.Theory != 0) { TableCell cellCourse_Code = new TableCell(); cellCourse_Code.Text = course_data.Course_Code; tRowBody.Cells.Add(cellCourse_Code); TableCell cellCourse_Name = new TableCell(); cellCourse_Name.Text = course_data.Course_Thainame + "<br/>" + course_data.Course_Engname; tRowBody.Cells.Add(cellCourse_Name); TableCell cellCourse_Credit = new TableCell(); cellCourse_Credit.Attributes.Add("class", "text-center"); cellCourse_Credit.Text = Convert.ToString(course_data.Credit) + "(" + Convert.ToString(course_data.Theory) + "-" + Convert.ToString(course_data.Practice) + "-" + course_data.Self_Study.ToString() + ")"; tRowBody.Cells.Add(cellCourse_Credit); TableCell cellCourse_Radio = new TableCell(); cellCourse_Radio.Attributes.Add("class", "text-center"); radio[i] = new RadioButton(); radio[i].ID = course_data.Course_Code; radio[i].AutoPostBack = true; radio[i].GroupName = "course_group"; if (Session["selected_course"] != null) { if (radio[i].ID == (string)Session["selected_course"]) { radio[i].Checked = true; } } radio[i].CheckedChanged += new EventHandler(radioButtons_CheckedChanged); cellCourse_Radio.Controls.Add(radio[i]); tRowBody.Cells.Add(cellCourse_Radio); tb1.Rows.Add(tRowBody); i++; } } if (!Page.IsPostBack) { //A1.Disabled = true; } TableRow row = new TableRow(); TableCell cell = new TableCell(); cell.Controls.Add(tb1); row.Cells.Add(cell); tblCourse.Rows.Add(row); } else { divShow.Visible = false; divFail.Visible = true; } } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
/* * Register_onClick Method: * * Takes care of validation. * Ensures uniqueness of Email ID, username and Mobile Number. * */ protected void Register_onClick(object Sender, EventArgs e) { string storagePath = Server.MapPath("~/Images/"); if (prof.FileName != "") { prof.SaveAs(storagePath + Path.GetFileName(prof.FileName)); fpath = "/Images/" + Path.GetFileName(prof.FileName); } else { fpath = "/Images/defaultuser.png"; } SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = connstring(); sds.SelectParameters.Add("username", TypeCode.String, this.uname.Text); sds.SelectParameters.Add("email", TypeCode.String, this.email.Text); sds.SelectParameters.Add("mobile", TypeCode.String, this.mobile.Text); sds.SelectCommand = "SELECT * FROM [Users] WHERE [username] = @username"; DataView dv1 = (DataView)sds.Select(DataSourceSelectArguments.Empty); sds.SelectCommand = "SELECT * FROM [Users] WHERE [email] = @email"; DataView dv2 = (DataView)sds.Select(DataSourceSelectArguments.Empty); sds.SelectCommand = "SELECT * FROM [Users] WHERE [mobile] = @mobile"; DataView dv3 = (DataView)sds.Select(DataSourceSelectArguments.Empty); if (dv1 != null && dv1.Count != 0) { lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Text = "Username already exists"; return; } else if ((dv2 != null && dv2.Count != 0)) { lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Text = "Email ID already in use"; return; } else if ((dv3 != null && dv3.Count != 0)) { lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Text = "Mobile Number already in use"; return; } else { Random rnd = new Random(); vcode = rnd.Next(100000, 999999); sendemail(email.Text, vcode); a1 = uname.Text; a2 = name.Text; a3 = gender.Text; a4 = Add1.Text; a5 = TextBox1.Text; a6 = city.SelectedItem.Value; a7 = TextBox2.SelectedItem.Value; a8 = pin.Text; a9 = mobile.Text; a10 = telephone.Text; a11 = email.Text; a12 = dob.Text; a13 = security.SelectedItem.Value; MultiView1.SetActiveView(view2); } }
protected void Page_Init(object sender, EventArgs e) { SqlDataSource sql1 = new SqlDataSource(); sql1.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql1.SelectCommand = "select a.id,a.type,a.message_type,a.place,a.message,a.year,a.month,a.day,a.hour,a.minute,a.second,b.username,b.photo "; sql1.SelectCommand += "from status_messages as a"; sql1.SelectCommand += " inner join user_login as b on b.id=a.uid"; //if want to class by type use type=0,1,2 ; message_type=0,1,2 //Before today's message sql1.SelectCommand += " where a.year<=" + DateTime.Now.Year.ToString() + " and a.month<=" + DateTime.Now.Month.ToString(); sql1.SelectCommand += " and a.day<=" + DateTime.Now.Day.ToString() + " "; //sql1.SelectCommand += " and a.day<=" + DateTime.Now.Day.ToString() + " and a.hour<="+Convert.ToInt32(DateTime.Now.ToString("HH")).ToString(); //sql1.SelectCommand += " and a.minute<=" + DateTime.Now.Minute.ToString() + " and a.second<=" + DateTime.Now.Second.ToString(); sql1.SelectCommand += " ORDER BY a.year desc,a.month desc,a.day desc,a.hour desc,a.minute desc,a.second desc;"; DataView ict = (DataView)sql1.Select(DataSourceSelectArguments.Empty); Literal li = new Literal(); li.Text = @"<script> function UploadFile(fileUpload,id) { if (fileUpload.value != '') { var cutname = id; var n = cutname.indexOf('_'); var nn = cutname.substring(n, cutname.length ); document.getElementById('btnUploadDoc' + nn).click(); } } $(function () { "; for (int i = 0; i < ict.Count; i++) { li.Text += @" $('#btnFileUpload" + i + @"').fileupload({ url: 'FileUploadHandler.ashx?upload=start', add: function(e, data) { console.log('add', data); $('#progressbar" + i + @"').show(); $('#image_place" + i + @"').hide(); $('#image_place" + i + @" div').css('width', '0%'); data.submit(); }, progress: function(e, data) { var progress = parseInt(data.loaded / data.total * 100, 10); $('#progressbar" + i + @" div').css('width', progress + '%'); }, success: function(response, status) { $('#progressbar" + i + @"').hide(); $('#progressbar" + i + @" div').css('width', '0%'); $('#image_place" + i + @"').show(); document.getElementById('make-image" + i + @"').src = response; console.log('success', response); }, error: function(error) { $('#progressbar" + i + @"').hide(); $('#progressbar" + i + @" div').css('width', '0%'); $('#image_place" + i + @"').hide(); $('#image_place" + i + @" div').css('width', '0%'); console.log('error', error); } }); $('.hidde" + i + @"').toggle(false); $('.box" + i + @"').click(function () { $('.hidde" + i + @"').toggle(); $('.box" + i + @"').toggle(false); }) $('.hidde" + i + @"').click(function () { $('.box" + i + @"').toggle(); $('.hidde" + i + @"').toggle(false); }) $('.likehidde" + i + @"').toggle(false); $('.likebox" + i + @"').click(function () { $('.likehidde" + i + @"').toggle(); $('.likebox" + i + @"').toggle(false); }) $('.likehidde" + i + @"').click(function () { $('.likebox" + i + @"').toggle(); $('.likehidde" + i + @"').toggle(false); }) $('.sharehidde" + i + @"').toggle(false); $('.sharebox" + i + @"').click(function () { $('.sharehidde" + i + @"').toggle(); $('.sharebox" + i + @"').toggle(false); }) $('.sharehidde" + i + @"').click(function () { $('.sharebox" + i + @"').toggle(); $('.sharehidde" + i + @"').toggle(false); }) $('.mess_hidde" + i + @"').toggle(false); $('.mess_box" + i + @"').click(function () { $('.mess_hidde" + i + @"').toggle(); $('.mess_box" + i + @"').toggle(false); }) $('.mess_hidde" + i + @"').click(function () { $('.mess_box" + i + @"').toggle(); $('.mess_hidde" + i + @"').toggle(false); }) $('.big_mess_hidde" + i + @"').toggle(false); $('.big_mess_box" + i + @"').click(function () { $('.big_mess_hidde" + i + @"').toggle(); $('.big_mess_box" + i + @"').toggle(false); $('.status_message_hidde" + i + @"').toggle(); $('.status_message_box" + i + @"').toggle(false); }) $('.big_mess_hidde" + i + @"').click(function () { $('.big_mess_box" + i + @"').toggle(); $('.big_mess_hidde" + i + @"').toggle(false); $('.status_message_box" + i + @"').toggle(); $('.status_message_hidde" + i + @"').toggle(false); }) $('.status_message_hidde" + i + @"').toggle(false); "; SqlDataSource sql3 = new SqlDataSource(); sql3.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql3.SelectCommand = "select filename from status_messages as a inner join status_messages_image as b on a.id=b.smid"; sql3.SelectCommand += " where b.smid=" + ict.Table.Rows[i]["id"].ToString() + ";"; DataView ict2 = (DataView)sql3.Select(DataSourceSelectArguments.Empty); if (ict2.Count > 3) { li.Text += @" $('.imhidde" + i + @"').toggle(false); $('.imbox" + i + @"').click(function () { $('.imhidde" + i + @"').toggle(); $('.imbox" + i + @"').toggle(false); }) $('.imhidde" + i + @"').click(function () { $('.imbox" + i + @"').toggle(); $('.imhidde" + i + @"').toggle(false); })"; } } li.Text += @" })"; li.Text += @"</script>"; Panel pdn_j = (Panel)this.FindControl("javaplace"); pdn_j.Controls.Add(li); //this.Page.Controls.Add(li); //this.Page.Header.Controls.Add(li); ////添加至指定位置 //this.Page.Header.Controls.AddAt(0, li); Panel pdn2 = (Panel)this.FindControl("Panel2"); for (int i = 0; i < ict.Count; i++) { //big message place pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='5%' height='5%'></td><td width='90%' height='5%'></td><td width='5%' height='5%'></td></tr>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td></td>")); pdn2.Controls.Add(new LiteralControl("<td>")); //new message place pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); pdn2.Controls.Add(new LiteralControl("<tr>")); //Poster photo pdn2.Controls.Add(new LiteralControl("<td width='10%' rowspan='2' valign='top'>")); Image img = new Image(); img.Width = 50; img.Height = 50; img.ImageUrl = ict.Table.Rows[i]["photo"].ToString(); pdn2.Controls.Add(img); pdn2.Controls.Add(new LiteralControl("</td>")); //poster username pdn2.Controls.Add(new LiteralControl("<td width='10%'>")); HyperLink hy = new HyperLink(); hy.NavigateUrl = "javascript:void(0);"; hy.Target = "_blank"; hy.Text = ict.Table.Rows[i]["username"].ToString(); hy.Font.Underline = false; pdn2.Controls.Add(hy); pdn2.Controls.Add(new LiteralControl("</td>")); //poster message type and time pdn2.Controls.Add(new LiteralControl("<td align='right' width='80%'>")); Label la = new Label(); la.ForeColor = System.Drawing.ColorTranslator.FromHtml("#CCCCCC"); la.Text = ""; if (Convert.ToInt32(ict.Table.Rows[i]["message_type"].ToString()) == 0) { la.Text += "お食事、"; } else if (Convert.ToInt32(ict.Table.Rows[i]["message_type"].ToString()) == 1) { la.Text += "人気スポット、"; } else if (Convert.ToInt32(ict.Table.Rows[i]["message_type"].ToString()) == 2) { la.Text += "イベント、"; } else if (Convert.ToInt32(ict.Table.Rows[i]["message_type"].ToString()) == 3) { la.Text += "病院、"; } else if (Convert.ToInt32(ict.Table.Rows[i]["message_type"].ToString()) == 4) { la.Text += "公園/レジャー、"; } else if (Convert.ToInt32(ict.Table.Rows[i]["message_type"].ToString()) == 5) { la.Text += "授乳室、"; } la.Text += ict.Table.Rows[i]["place"].ToString() + " "; la.Text += ict.Table.Rows[i]["year"].ToString() + "." + ict.Table.Rows[i]["month"].ToString() + "." + ict.Table.Rows[i]["day"].ToString(); pdn2.Controls.Add(la); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); //poster message pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td colspan='3' style=" + '"' + "word-break:break-all; width:90%;" + '"' + ">")); pdn2.Controls.Add(new LiteralControl("<div class='box" + i + "'>")); HyperLink hyy; if (ict.Table.Rows[i]["message"].ToString().Length < 37) { pdn2.Controls.Add(new LiteralControl(ict.Table.Rows[i]["message"].ToString())); } else { pdn2.Controls.Add(new LiteralControl(ict.Table.Rows[i]["message"].ToString().Substring(0, 37) + "‧‧‧")); hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "もっと見る"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); } pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("<div class='hidde" + i + "'>")); Label la1 = new Label(); la1.Style.Add("word-break", "break-all"); la1.Style.Add("over-flow", "hidden"); la1.Text = ict.Table.Rows[i]["message"].ToString(); pdn2.Controls.Add(la1); pdn2.Controls.Add(new LiteralControl("<br/>")); if (ict.Table.Rows[i]["message"].ToString().Length > 36) { hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "たたむ"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); } pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); //poster images pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td colspan='3' width='90%' align='center'><br/><br/>")); SqlDataSource sql2 = new SqlDataSource(); sql2.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql2.SelectCommand = "select filename from status_messages as a inner join status_messages_image as b on a.id=b.smid"; sql2.SelectCommand += " where b.smid=" + ict.Table.Rows[i]["id"].ToString() + ";"; DataView ict1 = (DataView)sql2.Select(DataSourceSelectArguments.Empty); if (ict1.Count > 3) { pdn2.Controls.Add(new LiteralControl("<div class='imbox" + i + "'>")); pdn2.Controls.Add(new LiteralControl("<div class='zoom-gallery'>")); for (int ii = 0; ii < 3; ii++) { string cutstr = ict1.Table.Rows[ii]["filename"].ToString(); int ind = cutstr.IndexOf(@"/"); string cutstr1 = cutstr.Substring(ind + 1, cutstr.Length - ind - 1); pdn2.Controls.Add(new LiteralControl("<a href='" + cutstr1 + "' data-source='' title='" + ict.Table.Rows[i]["username"].ToString() + "' style='width:100px;height:100px;'>")); pdn2.Controls.Add(new LiteralControl("<img src='" + cutstr1 + "' width='100' height='100' />")); pdn2.Controls.Add(new LiteralControl("</a>")); //Image imgg = new Image(); //imgg.Width = 100; imgg.Height = 100; //imgg.ImageUrl = ict1.Table.Rows[ii]["filename"].ToString(); //pdn2.Controls.Add(imgg); //pdn2.Controls.Add(new LiteralControl(" ")); } pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("<br/>")); hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "もっと見る"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("<div class='imhidde" + i + "'>")); for (int ii = 0; ii < ict1.Count; ii++) { if (ii > 0 && ii % 3 == 0) { pdn2.Controls.Add(new LiteralControl("<br/>")); } Image imgg = new Image(); imgg.Width = 100; imgg.Height = 100; imgg.ImageUrl = ict1.Table.Rows[ii]["filename"].ToString(); pdn2.Controls.Add(imgg); pdn2.Controls.Add(new LiteralControl(" ")); } pdn2.Controls.Add(new LiteralControl("<br/>")); hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "たたむ"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl("</div>")); } else { for (int ii = 0; ii < ict1.Count; ii++) { Image imgg = new Image(); imgg.Width = 100; imgg.Height = 100; imgg.ImageUrl = ict1.Table.Rows[ii]["filename"].ToString(); pdn2.Controls.Add(imgg); pdn2.Controls.Add(new LiteralControl(" ")); } } pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td></td>")); //poster message like and share pdn2.Controls.Add(new LiteralControl("<td width='15%' align='right'><br/><br/>")); pdn2.Controls.Add(new LiteralControl("<div style='cursor: pointer' class='likebox" + i + "'>")); Image img1 = new Image(); img1.Width = 25; img1.Height = 25; img1.ImageUrl = "~/images/like_b.png"; pdn2.Controls.Add(img1); Label laa = new Label(); laa.Font.Size = FontUnit.Point(10); laa.ForeColor = System.Drawing.ColorTranslator.FromHtml("#CCCCCC"); laa.Text = "いいね"; pdn2.Controls.Add(laa); pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("<div style='cursor: pointer' class='likehidde" + i + "'>")); img1 = new Image(); img1.Width = 25; img1.Height = 25; img1.ImageUrl = "~/images/like.png"; pdn2.Controls.Add(img1); laa = new Label(); laa.Font.Size = FontUnit.Point(10); laa.ForeColor = System.Drawing.ColorTranslator.FromHtml("#F06767"); laa.Text = "いいね"; pdn2.Controls.Add(laa); pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td>")); pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td align='center'><br/><br/>")); pdn2.Controls.Add(new LiteralControl("<div style='cursor: pointer' class='big_mess_box" + i + "'>")); img1 = new Image(); img1.Width = 25; img1.Height = 25; img1.ImageUrl = "~/images/mess_b.png"; pdn2.Controls.Add(img1); laa = new Label(); laa.Font.Size = FontUnit.Point(10); laa.ForeColor = System.Drawing.ColorTranslator.FromHtml("#CCCCCC"); laa.Text = "コメント"; pdn2.Controls.Add(laa); pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("<div style='cursor: pointer' class='big_mess_hidde" + i + "'>")); img1 = new Image(); img1.Width = 25; img1.Height = 25; img1.ImageUrl = "~/images/mess.png"; pdn2.Controls.Add(img1); laa = new Label(); laa.Font.Size = FontUnit.Point(10); laa.ForeColor = System.Drawing.ColorTranslator.FromHtml("#F06767"); laa.Text = "コメント"; pdn2.Controls.Add(laa); pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td align='left'><br/><br/>")); pdn2.Controls.Add(new LiteralControl("<div style='cursor: pointer' class='sharebox" + i + "'>")); img1 = new Image(); img1.Width = 25; img1.Height = 25; img1.ImageUrl = "~/images/share_b.png"; pdn2.Controls.Add(img1); laa = new Label(); laa.Font.Size = FontUnit.Point(10); laa.ForeColor = System.Drawing.ColorTranslator.FromHtml("#CCCCCC"); laa.Text = "シェア"; pdn2.Controls.Add(laa); pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("<div style='cursor: pointer' class='sharehidde" + i + "'>")); img1 = new Image(); img1.Width = 25; img1.Height = 25; img1.ImageUrl = "~/images/share.png"; pdn2.Controls.Add(img1); laa = new Label(); laa.Font.Size = FontUnit.Point(10); laa.ForeColor = System.Drawing.ColorTranslator.FromHtml("#F06767"); laa.Text = "シェア"; pdn2.Controls.Add(laa); pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td></td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td></td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td></td>")); pdn2.Controls.Add(new LiteralControl("<td>")); pdn2.Controls.Add(new LiteralControl("<div class='status_message_box" + i + "' style='background-color: #ffffff'>")); pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='5%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("<td width='90%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("<td width='5%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); pdn2.Controls.Add(new LiteralControl("</div >")); pdn2.Controls.Add(new LiteralControl("<div class='status_message_hidde" + i + "' style='background-color: #dddddd'>")); pdn2.Controls.Add(new LiteralControl("<table width='100%' align='left'>")); //first space way pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='5%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("<td width='90%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("<td width='5%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("<tr>")); //second space way pdn2.Controls.Add(new LiteralControl("<td></td>")); //someone answer pdn2.Controls.Add(new LiteralControl("<td>")); pdn2.Controls.Add(new LiteralControl("<table width='100%' align='left'>")); //who like this message pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='100%'>")); img1 = new Image(); img1.Width = 15; img1.Height = 15; img1.ImageUrl = "~/images/like_b_1.png"; pdn2.Controls.Add(img1); SqlDataSource sql4 = new SqlDataSource(); sql4.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql4.SelectCommand = "select b.username from status_messages_user_like as a inner join user_login as b on a.uid=b.id"; sql4.SelectCommand += " where a.smid=" + ict.Table.Rows[i]["id"].ToString() + ""; sql4.SelectCommand += " ORDER BY a.year desc,a.month desc,a.day desc,a.hour desc,a.minute desc,a.second desc;"; sql4.DataBind(); DataView ict3 = (DataView)sql4.Select(DataSourceSelectArguments.Empty); if (ict3.Count > 2) { for (int iii = 0; iii < 2; iii++) { hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = ict3.Table.Rows[iii]["username"].ToString(); hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl("、")); } hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "他" + (ict3.Count - 2) + "人"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); } else { for (int iii = 0; iii < ict3.Count; iii++) { hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = ict3.Table.Rows[iii]["username"].ToString(); hyy.Font.Underline = false; pdn2.Controls.Add(hyy); if (iii != ict3.Count - 1) { pdn2.Controls.Add(new LiteralControl("、")); } } } pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); //who talk about this status message before pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='100%'>")); sql4.SelectCommand = "select e.id,e.message,e.filename,b.username,b.photo,e.pointer_message_id,e.pointer_user_id,e.structure_level"; sql4.SelectCommand += " from status_messages as a inner join status_messages_user as c"; sql4.SelectCommand += " on a.id=c.smid inner join user_login as b on b.id=c.uid"; sql4.SelectCommand += " inner join status_messages_user_talk as e on e.smuid=c.id"; sql4.SelectCommand += " where a.id=" + ict.Table.Rows[i]["id"].ToString() + ""; sql4.SelectCommand += " ORDER BY e.year desc,e.month desc,e.day desc,e.hour desc,e.minute desc,e.second desc;"; sql4.DataBind(); ict3 = (DataView)sql4.Select(DataSourceSelectArguments.Empty); List <sorttalk> talk_list = new List <sorttalk>(); sorttalk so = new sorttalk(); for (int iy = 0; iy < ict3.Count; iy++) { so = new sorttalk(); so.id = Convert.ToInt32(ict3.Table.Rows[iy]["id"].ToString()); so.level = Convert.ToInt32(ict3.Table.Rows[iy]["structure_level"].ToString()); so.point_id = Convert.ToInt32(ict3.Table.Rows[iy]["pointer_message_id"].ToString()); so.uid = Convert.ToInt32(ict3.Table.Rows[iy]["pointer_user_id"].ToString()); so.filename = ict3.Table.Rows[iy]["filename"].ToString(); so.mess = ict3.Table.Rows[iy]["message"].ToString(); if (ict3.Table.Rows[iy]["pointer_user_id"].ToString() == "0") { so.username = ict3.Table.Rows[iy]["username"].ToString(); so.photo = ict3.Table.Rows[iy]["photo"].ToString(); } else { SqlDataSource sql6 = new SqlDataSource(); sql6.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql6.SelectCommand = "select username,photo from user_login"; sql6.SelectCommand += " where id=" + ict3.Table.Rows[iy]["pointer_user_id"].ToString() + ";"; sql6.DataBind(); DataView ict5 = (DataView)sql6.Select(DataSourceSelectArguments.Empty); so.username = ict5.Table.Rows[0]["username"].ToString(); so.photo = ict5.Table.Rows[0]["photo"].ToString(); } talk_list.Add(so); } SqlDataSource sql5 = new SqlDataSource(); sql5.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql5.SelectCommand = "select max(e.structure_level) as maxlevel"; //sql5.SelectCommand = "select e.id,e.message,e.filename,b.username,b.photo,e.pointer_message_id,e.pointer_user_id,e.structure_level"; sql5.SelectCommand += " from status_messages as a inner join status_messages_user as c"; sql5.SelectCommand += " on a.id=c.smid inner join user_login as b on b.id=c.uid"; sql5.SelectCommand += " inner join status_messages_user_talk as e on e.smuid=c.id"; sql5.SelectCommand += " where a.id=" + ict.Table.Rows[i]["id"].ToString() + ";"; sql5.DataBind(); DataView ict4 = (DataView)sql5.Select(DataSourceSelectArguments.Empty); int maxlevel = 0; if (ict4.Table.Rows[0]["maxlevel"].ToString() != "") { maxlevel = Convert.ToInt32(ict4.Table.Rows[0]["maxlevel"].ToString()); } List <sorttalk> talk_list_tmp = new List <sorttalk>(); so = new sorttalk(); for (int ik = 0; ik < talk_list.Count; ik++) { if (talk_list[ik].level == 0) { so = new sorttalk(); so.id = talk_list[ik].id; so.level = talk_list[ik].level; so.filename = talk_list[ik].filename; so.mess = talk_list[ik].mess; so.photo = talk_list[ik].photo; so.point_id = talk_list[ik].point_id; so.uid = talk_list[ik].uid; so.username = talk_list[ik].username; talk_list_tmp.Add(so); } } talk_list.Sort((a, b) => a.id.CompareTo(b.id)); for (int ik = 0; ik < talk_list.Count; ik++) { for (int le = 1; le < maxlevel + 1; le++) { if (talk_list[ik].level == le) { so = new sorttalk(); so.id = talk_list[ik].id; so.level = talk_list[ik].level; so.filename = talk_list[ik].filename; so.mess = talk_list[ik].mess; so.photo = talk_list[ik].photo; so.point_id = talk_list[ik].point_id; so.uid = talk_list[ik].uid; so.username = talk_list[ik].username; for (int ikk = 0; ikk < talk_list_tmp.Count; ikk++) { if (talk_list_tmp[ikk].id == talk_list[ik].point_id) { talk_list_tmp.Insert(ikk + 1, so); } } } } } Image img2 = new Image(); if (ict3.Count > 1) { //show div pdn2.Controls.Add(new LiteralControl("<div class='mess_box" + i + "'>")); pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='100%' align='left' colspan='2'>")); hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "以前のコメントを見る"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='10%' rowspan='2' valign='top'>")); img2 = new Image(); img2.Height = 50; img2.Width = 50; img2.ImageUrl = talk_list_tmp[0].photo; pdn2.Controls.Add(img2); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td width='90%' style=" + '"' + "word-break:break-all;" + '"' + ">")); pdn2.Controls.Add(new LiteralControl(ict3.Table.Rows[0]["username"].ToString())); pdn2.Controls.Add(new LiteralControl("<br/>")); pdn2.Controls.Add(new LiteralControl(ict3.Table.Rows[0]["message"].ToString())); pdn2.Controls.Add(new LiteralControl("<br/>")); if (talk_list_tmp[0].filename != "") { img2 = new Image(); img2.Height = 50; img2.Width = 50; img2.ImageUrl = talk_list_tmp[0].filename; pdn2.Controls.Add(img2); pdn2.Controls.Add(new LiteralControl("<br/>")); } pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td>")); //who talk about status message and who like hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "いいね!"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl(" ")); hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "返信"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); pdn2.Controls.Add(new LiteralControl("</div>")); //hidde message pdn2.Controls.Add(new LiteralControl("<div class='mess_hidde" + i + "'>")); pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); for (int iiii = 0; iiii < talk_list_tmp.Count; iiii++) { pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); pdn2.Controls.Add(new LiteralControl("<tr>")); int wid = (10 + (10 * talk_list_tmp[iiii].level)); if (wid > 90) { wid = 90; } pdn2.Controls.Add(new LiteralControl("<td width='" + wid + "%' align='right' rowspan='2' valign='top'>")); img2 = new Image(); img2.Width = 50; img2.Height = 50; img2.ImageUrl = talk_list_tmp[iiii].photo; pdn2.Controls.Add(img2); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td width='" + (100 - wid) + "%' style=" + '"' + "word-break:break-all;" + '"' + ">")); pdn2.Controls.Add(new LiteralControl(talk_list_tmp[iiii].username.ToString())); pdn2.Controls.Add(new LiteralControl("<br/>")); pdn2.Controls.Add(new LiteralControl(talk_list_tmp[iiii].mess.ToString())); pdn2.Controls.Add(new LiteralControl("<br/>")); if (talk_list_tmp[iiii].filename.ToString() != "") { img2 = new Image(); img2.Height = 50; img2.Width = 50; img2.ImageUrl = talk_list_tmp[iiii].filename.ToString(); pdn2.Controls.Add(img2); pdn2.Controls.Add(new LiteralControl("<br/>")); } pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td>")); //who talk about status message and who like hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "いいね!"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl(" ")); hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "返信"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); } pdn2.Controls.Add(new LiteralControl("</div>")); } else { if (ict3.Count > 0) { for (int iiii = 0; iiii < talk_list_tmp.Count; iiii++) { pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); pdn2.Controls.Add(new LiteralControl("<tr>")); int wid = (10 + (10 * talk_list_tmp[iiii].level)); if (wid > 90) { wid = 90; } pdn2.Controls.Add(new LiteralControl("<td width='" + wid + "%' align='right' rowspan='2' valign='top'>")); img2 = new Image(); img2.Width = 50; img2.Height = 50; img2.ImageUrl = talk_list_tmp[iiii].photo; pdn2.Controls.Add(img2); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td width='" + (100 - wid) + "%' style=" + '"' + "word-break:break-all;" + '"' + ">")); pdn2.Controls.Add(new LiteralControl(talk_list_tmp[iiii].username.ToString())); pdn2.Controls.Add(new LiteralControl("<br/>")); pdn2.Controls.Add(new LiteralControl(talk_list_tmp[iiii].mess.ToString())); pdn2.Controls.Add(new LiteralControl("<br/>")); if (talk_list_tmp[iiii].filename.ToString() != "") { img2 = new Image(); img2.Height = 50; img2.Width = 50; img2.ImageUrl = talk_list_tmp[iiii].filename.ToString(); pdn2.Controls.Add(img2); pdn2.Controls.Add(new LiteralControl("<br/>")); } pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td>")); //who talk about status message and who like hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "いいね!"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl(" ")); hyy = new HyperLink(); hyy.NavigateUrl = "javascript:void(0);"; hyy.Target = "_blank"; hyy.Text = "返信"; hyy.Font.Underline = false; pdn2.Controls.Add(hyy); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); } } } pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); pdn2.Controls.Add(new LiteralControl("</td>")); //second space way pdn2.Controls.Add(new LiteralControl("<td></td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); //third space way pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td></td>")); pdn2.Controls.Add(new LiteralControl("<td>")); pdn2.Controls.Add(new LiteralControl("<table width='100%'>")); pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='10%' valign='top'>")); //user photo img1 = new Image(); img1.Width = 50; img1.Height = 50; img1.ImageUrl = "~/images/mike.jpg"; pdn2.Controls.Add(img1); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td width='90%'>")); //user answer TextBox tex = new TextBox(); tex.Width = Unit.Percentage(100); tex.Height = 30; tex.Attributes.Add("placeholder", "コメントする"); pdn2.Controls.Add(tex); pdn2.Controls.Add(new LiteralControl("<br/>")); pdn2.Controls.Add(new LiteralControl(@" <label class='file-upload'><span><strong style='font-size: 20px;'>画像を登録</strong></span> <input type='file' name='file' id='btnFileUpload" + i + @"' /> </label> <br /> <div id='progressbar" + i + @"' style='width:100px;display:none;'> <div> 読み込み中 </div> </div> <br /> <div id='image_place" + i + @"' style='width:100px;display:none;'> <div> <img id='make-image" + i + @"' alt='' src='' width='100px' height='100px'/> </div> </div> ")); //pdn2.Controls.Add(new LiteralControl(@"<label class='file-upload'><span><strong>画像を登録</strong></span>")); //FileUpload fi=new FileUpload(); //fi.ID="fuDocument_"+i; //fi.Attributes.Add("onchange", "UploadFile(this,this.id);"); //pdn2.Controls.Add(fi); //pdn2.Controls.Add(new LiteralControl(@"</label><br />")); //Button but = new Button(); //but.ID = "btnUploadDoc_" + i; //but.Text = "Upload"; //but.Click += new System.EventHandler(this.UploadDocument); //but.OnClientClick = "ShowProgressBar();"; //but.Style["display"] = "none"; //pdn2.Controls.Add(but); //img1 = new Image(); //img1.Width = 100; img1.Height = 150; //img1.ID = "Image_" + i; //img1.Visible = false; //pdn2.Controls.Add(img1); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); pdn2.Controls.Add(new LiteralControl("</div>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td></td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); //fourth space way pdn2.Controls.Add(new LiteralControl("<tr>")); pdn2.Controls.Add(new LiteralControl("<td width='5%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("<td width='90%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("<td width='5%' height='5%'></td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); pdn2.Controls.Add(new LiteralControl("</td>")); pdn2.Controls.Add(new LiteralControl("<td></td>")); pdn2.Controls.Add(new LiteralControl("</tr>")); pdn2.Controls.Add(new LiteralControl("</table>")); pdn2.Controls.Add(new LiteralControl("<hr/>")); } //this.form1.Controls.Add(pdn2); //pdn.Controls.Add(new LiteralControl("<table align='center'>")); //pdn.Controls.Add(new LiteralControl("<tr><td align='center'>")); //pdn.Controls.Add(la); //string startd = DateTime.Now.Date.ToString("yyyy-MM-dd"); //string starth = Convert.ToInt32(DateTime.Now.ToString("HH")).ToString(); //string startm = DateTime.Now.Minute.ToString(); //string starts = DateTime.Now.Second.ToString(); //string d = Convert.ToString(DateTime.Now.ToLocalTime()); //string start = startd + " " + starth + ":" + startm + ":" + starts; //string star = starth + ":" + startm + ":" + starts; //Session["student_starttimeh"] = starth; //Session["student_starttimem"] = startm; //Session["student_starttimes"] = starts; //sql1.SelectCommand = "select date,starttime,endtime from fordate where date='" + startd + "' and starttime<'" + start + "' and endtime>'" + start + "';"; //DataView ict = (DataView)sql1.Select(DataSourceSelectArguments.Empty); //this.form1.Controls.Add(sql1); }
//For Calendar ------------------------------------ public string[] getDaysAvailable(int id) { SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select Distinct(DayAvailable) From Availability Where Employee_Id='" + id + "'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); string[] days = new string[table.Rows.Count]; for (int ii = 0; ii < table.Rows.Count; ii++) { days[ii] = table.Rows[ii][0].ToString().Trim(); } return days; }
private GridDefault BuildGridFromSqlDataSource(SqlDataSource sds) { var result = new GridDefault(); OnRowHeadBinding(new RowHeadBindingEventArgs(result)); DataView dataView = null; if (!PagingDisabled) { if (GridDataSource.SqlDataSourceSelectCommandType == SqlDataSourceCommandType.StoredProcedure) { var nvc = new NameValueCollection(Request.QueryString); nvc.Remove("page"); var dataKey = Request.Url.AbsolutePath; if (nvc.Count > 0) { dataKey += "?" + nvc.NameValueToQueryString(false); } dataView = Cache[dataKey] as DataView; if (dataView == null) { dataView = sds.Select(DataSourceSelectArguments.Empty) as DataView; if (dataView == null) { dataView = new DataView(new DataTable()); } var expires = DateTime.Now; expires = expires.Add(new TimeSpan(0, 1, 0)); Cache.Add(dataKey, dataView, null, expires, System.Web.Caching.Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null); } var rowsCount = dataView.Table.AsEnumerable().Skip(GridDataSource.SqlDataSourceStartRowIndex).Take(GridDataSource.SqlDataSourceMaximumRows).Count(); for (var i = 0; i < rowsCount; i++) { OnRowDataBinding(new RowDataBindingEventArgs(i, dataView.Table.Rows[GridDataSource.SqlDataSourceStartRowIndex + i], result)); } result.Body.TotalRecords = dataView.Table.Rows.Count; } } if (dataView == null) { dataView = sds.Select(DataSourceSelectArguments.Empty) as DataView; for (var i = 0; i < dataView.Table.Rows.Count; i++) { OnRowDataBinding(new RowDataBindingEventArgs(i, dataView.Table.Rows[i], result)); } result.Body.TotalRecords = dataView.Table.Rows.Count > 0 && dataView.Table.Columns.Contains("TotalRecords") ? (Int32)dataView.Table.Rows[0]["TotalRecords"] : 0; if (result.Body.TotalRecords == 0 && PagingDisabled) { result.Body.TotalRecords = dataView.Table.Rows.Count; } } return(result); }
/// ========================================================================== /// <summary> /// Show grid even if datasource is empty /// <param name="grdView">GridView</param> /// ========================================================================== protected void EmptyGridFix(GridView grdView) { // normally executes after a grid load method if (grdView.Rows.Count == 0 && grdView.DataSource != null) { DataTable dt = null; // need to clone sources otherwise it will be indirectly adding to // the original source if (grdView.DataSource is DataSet) { dt = ((DataSet)grdView.DataSource).Tables[0].Clone(); } else if (grdView.DataSource is DataTable) { dt = ((DataTable)grdView.DataSource).Clone(); } else if (grdView.DataSource is SqlDataSource) { SqlDataSource sds = new SqlDataSource(); DataView dv = new DataView(); sds = (SqlDataSource)grdView.DataSource; dv = (DataView)sds.Select(DataSourceSelectArguments.Empty); dt = dv.ToTable().Clone(); /* * DataView dv = new DataView(); * DataTable dt = new DataTable(); * dv = mySQLDataSource.Select(DataSourceSelectArguments.Empty); * dt = dv.ToTable(); * */ } if (dt == null) { return; } dt.Rows.Add(dt.NewRow()); // add empty row grdView.DataSource = dt; grdView.DataBind(); // hide row grdView.Rows[0].Visible = false; grdView.Rows[0].Controls.Clear(); } // normally executes at all postbacks if (grdView.Rows.Count == 1 && grdView.DataSource == null) { bool bIsGridEmpty = true; // check first row that all cells empty for (int i = 0; i < grdView.Rows[0].Cells.Count; i++) { if (grdView.Rows[0].Cells[i].Text != string.Empty) { bIsGridEmpty = false; } } // hide row if (bIsGridEmpty) { grdView.Rows[0].Visible = false; grdView.Rows[0].Controls.Clear(); } } }
/// <summary> /// Mauricio Arias Olave. /// 25/04/2014. /// Mostrar la grilla con los resultados de la búsqueda. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_Buscar_Click(object sender, EventArgs e) { //Inicializar variables. String sqlConsulta = ""; String sqlWhere = ""; String sqlConsultaFinal = ""; try { #region Construcción de la consulta dependiendo de el nombre y número del plan/proyecto. if (txt_NombrePlan.Text.Trim() == "" && txt_NumeroPlan.Text.Trim() == "") { sqlConsulta = " SELECT DISTINCT Id_Contacto, Nombres, Apellidos, Email, Identificacion, o.NombreOperador" + ", NomGrupo, " + /*Se debe colocar las columnas para evitar que se "dañe el flujo" del código.*/ " '' AS Id_Proyecto, '' AS Id_Grupo, '' AS NomGrupo, '' AS NomProyecto " + " FROM Contacto c LEFT JOIN GrupoContacto gc " + " ON c.Id_Contacto = gc.CodContacto LEFT JOIN Grupo g on gc.CodGrupo = g.Id_Grupo" + " left join Operador o on c.codOperador = o.IdOperador"; } else { sqlConsulta = " SELECT DISTINCT Id_Contacto, Nombres, Apellidos, Email, Identificacion, o.NombreOperador" + ", NomProyecto, " + " Id_Proyecto, Id_Grupo, NomGrupo " + " FROM contacto c LEFT JOIN proyectocontacto pc " + " ON c.Id_Contacto = pc.CodContacto LEFT JOIN proyecto p " + " ON pc.CodProyecto = p.id_proyecto LEFT JOIN GrupoContacto gc " + " ON c.Id_Contacto = gc.CodContacto LEFT JOIN Grupo g " + " ON gc.CodGrupo = g.id_Grupo" + " left join Operador o on p.codOperador = o.IdOperador"; } #endregion /* * #region Evaluación del nombre del usuario digitado. * * if (txt_Nombres.Text.Trim() != "") * { * sqlWhere = " WHERE Nombres LIKE '%'+'" + txt_Nombres.Text.Trim() + "'+'%' "; * } * #endregion * #region Evaluación de los apellidos. * * if (txt_Apellidos.Text.Trim() != "") * { * if (sqlWhere == "") * { * sqlWhere = "WHERE Apellidos LIKE '%'+'" + txt_Apellidos.Text.Trim() + "'+'%' "; * } * else * { * sqlWhere = sqlWhere + " AND Apellidos LIKE '%'+'" + txt_Apellidos.Text.Trim() + "'+'%' "; * } * } * #endregion * #region Evaluación del correo electrónico. * * if (txt_Email.Text.Trim() != "") * { * if (sqlWhere == "") * { * sqlWhere = "WHERE Email LIKE '%'+'" + txt_Email.Text.Trim() + "'+'%' "; * } * else * { * sqlWhere = sqlWhere + " AND Email LIKE '%'+'" + txt_Email.Text.Trim() + "'+'%' "; * } * } * #endregion * #region Evaluación del número de identificación. * * if (txt_Identificacion.Text.Trim() != "") * { * if (sqlWhere == "") * { * sqlWhere = "WHERE Identificacion = " + txt_Identificacion.Text.Trim() + " "; * } * else * { * sqlWhere = sqlWhere + " AND Identificacion = " + txt_Identificacion.Text.Trim() + " "; * } * } * #endregion * #region Evaluación del nombre del proyecto. * * if (txt_NombrePlan.Text.Trim() != "") * { * if (sqlWhere == "") * { * sqlWhere = "WHERE NomProyecto LIKE '%'+'" + txt_NombrePlan.Text.Trim() + "'+'%' "; * } * else * { * sqlWhere = sqlWhere + " AND NomProyecto LIKE '%'+'" + txt_NombrePlan.Text.Trim() + "'+'%' "; * } * } * #endregion * #region Evaluación del número del proyecto. * * if (txt_NumeroPlan.Text.Trim() != "") * { * if (sqlWhere == "") * { * sqlWhere = "WHERE Id_Proyecto = " + txt_NumeroPlan.Text.Trim() + " "; * } * else * { * sqlWhere = sqlWhere + " AND Id_Proyecto = " + txt_NumeroPlan.Text.Trim() + " "; * } * } * #endregion * */ if (sqlWhere.Trim() == "") { //sqlWhere = "WHERE Nombres LIKE '%'+'Ninguno... .+''%'"; //Creo debe ser modificarlo y dejarse así: "LIKE '%'+' '+'%'" } //Consulta sqlConsultaFinal = sqlConsulta; // +" " + sqlWhere; //var dtEmpresas = consultas.ObtenerDataTable(sqlConsultaFinal, "text"); //La consulta estuvo bien armada y continúa el flujo; es decir, generar la grilla. //Actualización: No se pone la condicional IF porque si no hay datos, NO se debe mostrar la grilla //ni resultados "según el comportamiento del FONADE clásico". //Session["dtEmpresas"] = dtEmpresas; if (!String.IsNullOrEmpty(txt_Nombres.Text) || !String.IsNullOrEmpty(txt_Apellidos.Text) || !String.IsNullOrEmpty(txt_Email.Text) || !String.IsNullOrEmpty(txt_Identificacion.Text) || !String.IsNullOrEmpty(txt_NombrePlan.Text) || !String.IsNullOrEmpty(txt_NumeroPlan.Text)) { sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, " where "); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_Nombres.Text) ? string.Format(" + Nombres LIKE'%{0}%' ", txt_Nombres.Text) : string.Empty); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_Apellidos.Text) ? string.Format(" + Apellidos LIKE'%{0}%' ", txt_Apellidos.Text) : string.Empty); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_Email.Text) ? string.Format(" + Email LIKE'%{0}%' ", txt_Email.Text) : string.Empty); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_Identificacion.Text) ? string.Format(" + Identificacion IN ({0})", txt_Identificacion.Text) : string.Empty); if (!String.IsNullOrEmpty(txt_NombrePlan.Text) || !String.IsNullOrEmpty(txt_NumeroPlan.Text)) { sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_NombrePlan.Text) ? string.Format(" + NomProyecto LIKE'%{0}%'", txt_NombrePlan.Text) : string.Empty); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_NumeroPlan.Text) ? string.Format(" + Id_Proyecto IN({0})", txt_NumeroPlan.Text) : string.Empty); } sqlConsultaFinal = sqlConsultaFinal.IndexOf("+") > -1?sqlConsultaFinal.Remove(sqlConsultaFinal.IndexOf("+"), 1):sqlConsultaFinal; var ijn = sqlConsultaFinal.Split('+'); sqlConsultaFinal = ijn.Length >= 2 ? sqlConsultaFinal.Replace("+", " AND ") : sqlConsultaFinal.Replace("+", string.Empty); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Vldt", "alert('Especifique los parámetros de consulta.')", true); return; } SqlDataSource sqlds = new SqlDataSource(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString + ";Connect Timeout=120", sqlConsultaFinal) { DataSourceMode = SqlDataSourceMode.DataReader, ConflictDetection = ConflictOptions.OverwriteChanges, CancelSelectOnNullParameter = true, SelectCommandType = SqlDataSourceCommandType.Text, ID = "sqlDs" }; sqlds.DataBind(); //gv_ResultadosBusqueda.DataSource = dtEmpresas; //gv_ResultadosBusqueda.DataBind(); //gv_ResultadosBusqueda.DataSource = sqlds; //gv_ResultadosBusqueda.DataBind(); var dtEmpresas = new DataTable(); GridView1.DataSource = sqlds.Select(new DataSourceSelectArguments()); sqlds.DataBind(); GridView1.DataBind(); //Según el comportamiento del FONADE clásico, los campos son vaciados al terminar de consultar. txt_Nombres.Text = ""; txt_Apellidos.Text = ""; txt_Email.Text = ""; txt_Identificacion.Text = ""; txt_NombrePlan.Text = ""; txt_NumeroPlan.Text = ""; } catch { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Mensaje", "alert('Error en la consulta y/o procedimiento.')", true); return; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["login_data"] == null) { Response.Redirect("../index.aspx"); } else { login_data = (UserLoginData)Session["login_data"]; if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { divFail.Visible = false; if ((Session["save_data"] != null) && (Session["service_course"] != null)) { ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); available_data = (AvailableCourseData)Session["save_data"]; service_code = (bool)Session["service_course"]; if (service_code == true) { // ตรวจสอบกำหนดการ int diffDate = -1; config_data1 = new TeachExamConfig().getTeachExamConfig(); if (config_data1.Date_Stop != null) { diffDate = utlObj.getDiffDate(config_data1.Date_Stop, utlObj.getToday()); } string sql = ""; curr_year = available_data.Curr_Code.Substring(0, 4); curr_code = available_data.Curr_Code.Substring(4); lblFaculty.Text = "วิชาบริการศึกษา"; //available_data.Faculty_Code = "xx"; //available_data.Department_Code = "xxxx"; available_data.Major_Code = "xxxxxx"; lblCurri.Text = new Curriculum().getCurriculum(available_data.Curr_Code).Curr_ThaiName + " (" + curr_year + ")"; //วิชาการคณะ if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty); sql = "Select DISTINCT COURSECODE From TQF2SEC3PLANDETAIL Where CURRCODE='" + curr_code + "' AND YEARVERSION='" + curr_year + "' AND COURSECODE NOT Like '%x' AND ("; int ii = 0; foreach (string fac in faculty_authorized) { ii++; sql += "COURSECODE Like '" + fac + "%'"; if (faculty_authorized.Count != ii) { sql += " OR "; } } sql += ") Order By COURSECODE"; // lblCurri.Text = sql; } //วิชาการภาค else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); sql = "Select DISTINCT COURSECODE From TQF2SEC3PLANDETAIL Where CURRCODE='" + curr_code + "' AND YEARVERSION='" + curr_year + "' AND COURSECODE NOT Like '%x' AND ("; int ii = 0; foreach (string dep in department_authorized) { ii++; sql += "COURSECODE Like '" + dep + "%'"; if (department_authorized.Count != ii) { sql += " OR "; } } sql += ") Order By COURSECODE"; } oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); all_course.Clear(); foreach (DataRowView rowData in allData) { int diffExtDate = -1; config_data2 = new TeachExamConfig().getExtendTeachExamConfig(rowData["COURSECODE"].ToString().Substring(0, 4)); if (config_data2.Date_Stop != null) { diffExtDate = utlObj.getDiffDate(config_data2.Date_Stop, utlObj.getToday()); } if (diffDate >= 0) { if (course.checkStatus(rowData["COURSECODE"].ToString())) { all_course.Add(rowData["COURSECODE"].ToString()); } } else if (diffExtDate >= 0) { if (course.checkStatus(rowData["COURSECODE"].ToString())) { all_course.Add(rowData["COURSECODE"].ToString()); } } } } else if (service_code == false) { curr_year = available_data.Curr_Code.Substring(0, 4); curr_code = available_data.Curr_Code.Substring(4); lblFaculty.Text = new Faculty().getFaculty(available_data.Faculty_Code).Faculty_Thai; lblCurri.Text = curr_code + " " + new Curriculum().getCurriculum(available_data.Curr_Code).Curr_ThaiName + " (" + curr_year + ")"; string sql = ""; //วิชาการคณะ if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty); sql = "Select DISTINCT COURSECODE From TQF2SEC3PLANDETAIL Where CURRCODE='" + curr_code + "' AND YEARVERSION='" + curr_year + "' AND COURSECODE NOT Like '%x' AND ("; int ii = 0; foreach (string fac in faculty_authorized) { ii++; sql += "COURSECODE Like '" + fac + "%'"; if (faculty_authorized.Count != ii) { sql += " OR "; } } sql += ") Order By COURSECODE"; } //วิชาการภาค else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); sql = "Select DISTINCT COURSECODE From TQF2SEC3PLANDETAIL Where CURRCODE='" + curr_code + "' AND YEARVERSION='" + curr_year + "' AND COURSECODE NOT Like '%x' AND ("; int ii = 0; foreach (string dep in department_authorized) { ii++; sql += "COURSECODE Like '" + dep + "%'"; if (department_authorized.Count != ii) { sql += " OR "; } } sql += ") Order By COURSECODE"; } oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); all_course.Clear(); foreach (DataRowView rowData in allData) { if (course.checkStatus(rowData["COURSECODE"].ToString())) { all_course.Add(rowData["COURSECODE"].ToString()); } } } RadioButton[] radio = new RadioButton[all_course.Count]; int i = 0; // Head Table string[] ar = { "รหัสวิชา", "ชื่อวิชา", "หน่วยกิต", "เลือก" }; Table tb1 = new Table(); tb1.Attributes.Add("class", "table table-bordered table-hover"); tb1.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++) { // Create a new cell and add it to the row. TableHeaderCell cellHead = new TableHeaderCell(); cellHead.Attributes.Add("class", "text-center"); cellHead.Text = ar[cellCtr - 1]; tRowHead.Cells.Add(cellHead); } tb1.Rows.Add(tRowHead); foreach (string course_code in all_course) { TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; course_data = course.getCourse(course_code); TableCell cellCourse_Code = new TableCell(); cellCourse_Code.Text = course_data.Course_Code; tRowBody.Cells.Add(cellCourse_Code); TableCell cellCourse_Name = new TableCell(); cellCourse_Name.Text = course_data.Course_Thainame + "<br/>" + course_data.Course_Engname; tRowBody.Cells.Add(cellCourse_Name); TableCell cellCourse_Credit = new TableCell(); cellCourse_Credit.Text = Convert.ToString(course_data.Credit) + "(" + Convert.ToString(course_data.Theory) + "-" + Convert.ToString(course_data.Practice) + "-" + course_data.Self_Study.ToString() + ")"; cellCourse_Credit.Attributes.Add("class", "text-center"); tRowBody.Cells.Add(cellCourse_Credit); TableCell cellCourse_Radio = new TableCell(); radio[i] = new RadioButton(); radio[i].ID = course_data.Course_Code; cellCourse_Radio.Attributes.Add("class", "text-center"); radio[i].AutoPostBack = true; radio[i].GroupName = "course_group"; radio[i].CheckedChanged += new EventHandler(radioButtons_CheckedChanged); cellCourse_Radio.Controls.Add(radio[i]); tRowBody.Cells.Add(cellCourse_Radio); tb1.Rows.Add(tRowBody); i++; } TableRow row = new TableRow(); TableCell cell = new TableCell(); cell.Controls.Add(tb1); row.Cells.Add(cell); tblCourse.Rows.Add(row); //Disable Next button when page load btnNext.Disabled = true; } else { divShow.Visible = false; divFail.Visible = true; } } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
void exportFile(string what) { ExcelPackage pck = new ExcelPackage(); string shStartDate = webStartDate.SelectedValue; string exStartDate = webStartDate.SelectedItem.Text.Replace("/", "-"); string filename = string.Empty; string MainSheet = string.Empty; MainSheet = "Summary"; filename = "RS Week Ending " + exStartDate + " - " + what; using (pck) { if (ReportType == "payout") { string selectedOwner = string.Empty; if (userType == "Owner") { selectedOwner = userFullname; } else { selectedOwner = webOwner.SelectedValue; } ExcelWorksheet wss = pck.Workbook.Worksheets.Add(MainSheet); SqlDataSource SQLs = new SqlDataSource(); SQLs.ID = "SqlDataSource-SummarydashDivPre"; SQLs.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; SQLs.SelectParameters.Add("webStartDate", shStartDate); SQLs.SelectParameters.Add("webDuration", "14"); SQLs.SelectParameters.Add("webProgram", webProgram.SelectedValue); SQLs.SelectParameters.Add("webStoreName", webStoreName.SelectedValue); SQLs.SelectParameters.Add("webStoreNumber", "All"); SQLs.SelectParameters.Add("webOwner", selectedOwner); SQLs.SelectParameters.Add("UserType", userType); SQLs.SelectParameters.Add("userFullname", userFullname); SQLs.SelectParameters.Add("webLocation", webLocation.SelectedValue); SQLs.SelectParameters.Add("webTrainer", webTrainer.SelectedValue); if (webProgram.SelectedValue == "Chipio - Chip Repair") { SQLs.SelectParameters.Add("cols", "Chipio"); } else { SQLs.SelectParameters.Add("cols", "All"); } SQLs.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SQLs.Selecting += SQLSelecting; SQLs.SelectCommand = "spx_PAYOUTTrainerReports"; DataSourceSelectArguments argss = new DataSourceSelectArguments(); DataView DVs = (DataView)SQLs.Select(argss); DataTable DTs = DVs.ToTable(); wss.Cells["A1"].LoadFromDataTable(DTs, true); wss.Cells["A1:Z2000"].AutoFitColumns(); //wss.Column("A").Hidden = true; } if (what == "All") { foreach (string[] i in storeList) { //storeList = tbStoreNumber, tbStoreName, tbLocation, tbOwner, tbHub, tbProgram string SheetName = "#" + i[0] + " " + i[1] + " " + i[5]; string shStoreNumber = i[0]; string shStoreName = i[1]; string shLocation = i[2]; string shOwner = i[3]; string shHub = i[4]; string shProgram = i[5]; ExcelWorksheet ws; try { ws = pck.Workbook.Worksheets.Add(SheetName); } catch { string n = new Random().Next(1, 9).ToString(); ws = pck.Workbook.Worksheets.Add(SheetName + " " + n); } SqlDataSource SQL1 = new SqlDataSource(); SQL1.ID = "SqlDataSource1"; SQL1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; SQL1.SelectParameters.Add("webStartDate", shStartDate); SQL1.SelectParameters.Add("webDuration", "14"); SQL1.SelectParameters.Add("webProgram", shProgram); SQL1.SelectParameters.Add("webStoreNumber", shStoreNumber); SQL1.SelectParameters.Add("webStoreName", shStoreName); SQL1.SelectParameters.Add("webLocation", shLocation); SQL1.SelectParameters.Add("webOwner", shOwner); SQL1.SelectParameters.Add("UserType", userType); SQL1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SQL1.Selecting += SQLSelecting; SQL1.SelectCommand = "spx_PAYOUTQty"; SqlDataSource SQL2 = new SqlDataSource(); SQL2.ID = "SqlDataSource2"; SQL2.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; SQL2.SelectParameters.Add("webStartDate", shStartDate); SQL2.SelectParameters.Add("webDuration", "14"); SQL2.SelectParameters.Add("webProgram", shProgram); SQL2.SelectParameters.Add("webStoreNumber", shStoreNumber); SQL2.SelectParameters.Add("webStoreName", shStoreName); SQL2.SelectParameters.Add("webLocation", shLocation); SQL2.SelectParameters.Add("webOwner", shOwner); SQL2.SelectParameters.Add("UserType", userType); if (shProgram == "Chipio - Chip Repair") { SQL2.SelectParameters.Add("gross", "Chipio - Chip Repair"); } else { SQL2.SelectParameters.Add("gross", "All"); } SQL2.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SQL2.Selecting += SQLSelecting; SQL2.SelectCommand = "spx_PAYOUTRev"; DataSourceSelectArguments args1 = new DataSourceSelectArguments(); DataView DV1 = (DataView)SQL1.Select(args1); DataTable DT1 = DV1.ToTable(); DataSourceSelectArguments args2 = new DataSourceSelectArguments(); DataView DV2 = (DataView)SQL2.Select(args2); DataTable DT2 = DV2.ToTable(); int j1 = DV1.Table.Rows.Count + 12; int j2 = j1 + 1; ws.Cells["A1"].Value = "Store:"; ws.Cells["A1"].Style.Font.Bold = true; ws.Cells["B1"].Value = shStoreName; ws.Cells["A2"].Value = "Program:"; ws.Cells["A2"].Style.Font.Bold = true; ws.Cells["B2"].Value = shProgram; ws.Cells["A3"].Value = "Owner:"; ws.Cells["A3"].Style.Font.Bold = true; ws.Cells["B3"].Value = shOwner; ws.Cells["A4"].Value = "Hub:"; ws.Cells["A4"].Style.Font.Bold = true; ws.Cells["B4"].Value = shHub; ws.Cells["A5"].Value = "Whse #:"; ws.Cells["A5"].Style.Font.Bold = true; ws.Cells["B5"].Value = shStoreNumber; ws.Cells["A6"].Value = "Location:"; ws.Cells["A6"].Style.Font.Bold = true; ws.Cells["B6"].Value = shLocation; ws.Cells["A9"].Value = "Quantity"; ws.Cells["A9"].Style.Font.Bold = true; ws.Cells["A10"].LoadFromDataTable(DT1, true); ws.Cells["A" + j1.ToString()].Value = "Revenue"; ws.Cells["A" + j1.ToString()].Style.Font.Bold = true; ws.Cells["A" + j2.ToString()].LoadFromDataTable(DT2, true); ws.Cells["A1:Z2000"].AutoFitColumns(); Page.Controls.Remove(SQL1); Page.Controls.Remove(SQL2); } } Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment; filename=" + filename + ".xlsx"); Response.BinaryWrite(pck.GetAsByteArray()); Response.Flush(); Response.End(); } }
/// <summary> /// เรียกดูข้อมูลจากตาราง SYSUSER /// </summary> /// <param name="sql">SQL Command</param> /// <returns>ข้อมูลจากตาราง SYSUSER</returns> public List <SysUser> getSysUserManual(string sql) { List <SysUser> data = new List <SysUser>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { SysUser row = new SysUser(); row.IdCode = rowData["IDCODE"].ToString(); row.FacultyCode = rowData["FACULTYCODE"].ToString(); row.TitleNameCode = rowData["TITLENAMECODE"].ToString(); row.DepartmentCode = rowData["DEPARTMENTCODE"].ToString(); row.UserTypeCode = rowData["USERTYPECODE"].ToString(); row.ThName = rowData["THNAME"].ToString(); row.EnName = rowData["ENNAME"].ToString(); row.ThSurName = rowData["THSURNAME"].ToString(); row.EnSurName = rowData["ENSURNAME"].ToString(); row.UserName = rowData["USERNAME"].ToString(); row.Password = rowData["PASSWORD"].ToString(); row.Position = rowData["POSITION"].ToString(); row.Address = rowData["ADDRESS"].ToString(); row.Tel = rowData["TEL"].ToString(); row.Email = rowData["EMAIL"].ToString(); row.OpenStatus = rowData["OPENSTATUS"].ToString(); row.PassportCode = rowData["PASSSPORTCODE"].ToString(); row.Sex = rowData["SEX"].ToString(); row.AcademicPositionCode = rowData["ACADEMICPOSITIONCODE"].ToString(); row.DivisionCode = rowData["DIVISIONCODE"].ToString(); row.BirthDay = rowData["BIRTHDAY"].ToString(); row.BirthProvince = rowData["BIRTHPROVINCE"].ToString(); row.BirthPlace = rowData["BIRTHPLACE"].ToString(); row.Country = rowData["COUNTRY"].ToString(); row.Nationality = rowData["NATIONALITY"].ToString(); row.Ethnicity = rowData["ETHNICITY"].ToString(); row.Height = float.Parse(rowData["HEIGHT"].ToString()); row.Weight = float.Parse(rowData["WEIGHT"].ToString()); row.Marital = rowData["MARITAL"].ToString(); row.Occupation = rowData["OCCUPATION"].ToString(); row.MobileNumber = rowData["MOBILENUMBER"].ToString(); row.Talent = rowData["TALENT"].ToString(); row.HomeNumber = rowData["HOMENUMBER"].ToString(); row.HomeBuilding = rowData["HOMEBUILDING"].ToString(); row.HomeVillage = rowData["HOMEVILLAGE"].ToString(); row.HomeMoo = rowData["HOMEMOO"].ToString(); row.HomeSoi = rowData["HOMESOI"].ToString(); row.HomeRoad = rowData["HOMEROAD"].ToString(); row.HomeTumbol = rowData["HOMETUMBOL"].ToString(); row.HomeAmphur = rowData["HOMEAMPHUR"].ToString(); row.HomeProvince = rowData["HOMEPROVINCE"].ToString(); row.HomePostCode = rowData["HOMEPOSTCODE"].ToString(); row.OfficeName = rowData["OFFICENAME"].ToString(); row.OfficeNumber = rowData["OFFICENUMBER"].ToString(); row.OfficeBuilding = rowData["OFFICEBUILDING"].ToString(); row.OfficeVillage = rowData["OFFICEVILLAGE"].ToString(); row.OfficeMoo = rowData["OFFICEMOO"].ToString(); row.OfficeSoi = rowData["OFFICESOI"].ToString(); row.OfficeRoad = rowData["OFFICEROAD"].ToString(); row.OfficeTumbol = rowData["OFFICETUMBOL"].ToString(); row.OfficeAmphur = rowData["OFFICEAMPHUR"].ToString(); row.OfficeProvince = rowData["OFFICEPROVINCE"].ToString(); row.OfficePostCode = rowData["OFFICEPOSTCODE"].ToString(); row.Affiliation = rowData["AFFILIATION"].ToString(); row.GradLecturer = rowData["GRAD_LECTURER"].ToString(); row.ShortName = rowData["SHORT_NAME"].ToString(); data.Add(row); } return(data); }
protected void btnSearch_Click(object sender, EventArgs e) { Clear(); string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionStr); string sqlStatement = ""; string sqlStatement2 = ""; string sqlStatement3 = ""; if (txtPmid.Text != "" || txtPmcid.Text != "") { if (txtPmid.Text != "") { sqlStatement = "select p.*,pp.authorlist, lyn.description as final_confirm, pp.review_editorial" + " from publication p" + " inner join publication_processing pp on p.publication_id = pp.publication_id" + " left outer join l_yes_no lyn" + " on pp.final_confirm_id = lyn.l_yes_no_id" + " where p.pmid = " + txtPmid.Text; sqlStatement2 = "select pp.publication_program_id," + " lp.abbreviation as program," + " case when lfg.group_number >= 0 then" + " 'FG ' + convert(varchar,lfg.group_number) + '-' + lfg.description" + " else lfg.description end" + " as focus_group" + " from publication_program pp" + " inner join publication p" + " on pp.publication_id = p.publication_id" + " inner join l_program lp" + " on pp.l_program_id = lp.l_program_id" + " left outer join l_focus_group lfg" + " on pp.l_focus_group_id = lfg.l_focus_group_id" + " where p.pmid = " + txtPmid.Text; sqlStatement3 = "select" + " lr.description as resource" + " from publication_resource pr" + " inner join publication p" + " on pr.publication_id = p.publication_id" + " inner join l_resource lr" + " on pr.l_resource_id = lr.l_resource_id" + " where p.pmid = " + txtPmid.Text; } else if (txtPmcid.Text != "") { sqlStatement = "select p.*,pp.authorlist, lyn.description as final_confirm, pp.review_editorial" + " from publication p" + " inner join publication_processing pp on p.publication_id = pp.publication_id" + " left outer join l_yes_no lyn" + " on pp.final_confirm_id = lyn.l_yes_no_id" + " where p.pmcid = '" + txtPmcid.Text + "'"; sqlStatement2 = "select pp.publication_program_id," + " lp.abbreviation as program," + " case when lfg.group_number >= 0 then" + " 'FG ' + convert(varchar,lfg.group_number) + '-' + lfg.description" + " else lfg.description end" + " as focus_group" + " from publication_program pp" + " inner join publication p" + " on pp.publication_id = p.publication_id" + " inner join l_program lp" + " on pp.l_program_id = lp.l_program_id" + " left outer join l_focus_group lfg" + " on pp.l_focus_group_id = lfg.l_focus_group_id" + " where p.pmcid = '" + txtPmcid.Text + "'"; sqlStatement3 = "select" + " lr.description as resource" + " from publication_resource pr" + " inner join publication p" + " on pr.publication_id = p.publication_id" + " inner join l_resource lr" + " on pr.l_resource_id = lr.l_resource_id" + " where p.pmcid = '" + txtPmcid.Text + "'"; } SqlDataSource ds = new SqlDataSource(connectionStr, sqlStatement); dvPublication.DataSource = ds; DataSourceSelectArguments dssa = new DataSourceSelectArguments(); dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount); dssa.RetrieveTotalRowCount = true; DataView dv = (DataView)ds.Select(dssa); if (dv.Table.Rows.Count > 0) { dvPublication.DataBind(); btnEdit.Visible = true; } else { ErrorMessage.Text = "No pub in database. You can import it."; btnImport.Visible = true; } SqlDataSource ds2 = new SqlDataSource(connectionStr, sqlStatement2); gvProgram.DataSource = ds2; gvProgram.DataBind(); SqlDataSource ds3 = new SqlDataSource(connectionStr, sqlStatement3); gvResource.DataSource = ds3; gvResource.DataBind(); } else if (txtTitle.Text != "") { sqlStatement = "select p.publication_id," + " p.pmid," + " p.article_title" + " from publication p" + " where p.article_title like '%" + txtTitle.Text + "%'"; Helper.BindGridview(sqlStatement, gvPublication); } else if (txtLastName.Text != "") { sqlStatement = "select p.publication_id," + " p.pmid," + " p.article_title" + " from publication p" + " inner join publication_processing pp" + " on p.publication_id = pp.publication_id" + " where pp.authorlist like '%" + txtLastName.Text + "%'"; Helper.BindGridview(sqlStatement, gvPublication); } }
public string[] getDaysAvailable(int id) { string[] DaysAvailable2 = new string[5]; DaysAvailable2[0] = "Monday"; DaysAvailable2[1] = "Tuesday"; DaysAvailable2[2] = "Wednesday"; DaysAvailable2[3] = "Thursday"; DaysAvailable2[4] = "Friday"; DateTime now = DateTime.Today.AddDays(1); DateTime last = now.AddDays(7); DateTime[] allDays = new DateTime[7]; string[] bookingDates = new string[5]; int[] weekNumber = new int[5]; int counter3 = 0; for (int i = 0; i < allDays.Length; i++) { allDays[i] = now.AddDays(i); } string[] date = new string[5]; for (int i = 0; i < allDays.Length; i++) { for (int ii = 0; ii < DaysAvailable2.Length; ii++) { if (allDays[i].DayOfWeek.ToString() == DaysAvailable2[ii]) { try { date[counter3] = allDays[i].ToShortDateString(); bookingDates[counter3] = DaysAvailable2[ii]; weekNumber[counter3] = GetWeekNumber(allDays[i]); counter3++; ; } catch { } } } } string[] query = new string[5]; for (int i = 0; i < 5; i++) { query[i] = "(Week='" + weekNumber[i] + "' AND Day='" + bookingDates[i] + "')"; } SqlDataSource SqlDataSource3 = new SqlDataSource(); SqlDataSource3.ConnectionString = ConfigurationManager.ConnectionStrings["AdvisorBookingConnectionString"].ToString(); // SqlDataSource3.SelectCommand = "Select Distinct(Day) From AdvisorSchedules"; SqlDataSource3.SelectCommand = "Select Distinct(Day) From AdvisorSchedules Where Advisor_ID='" + id+ "' AND ( " + query[0] + ") OR " + query[1] + " OR " + query[2] + " OR " + query[3] + " OR " + query[4]; DataView view = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); string[] days = new string[table.Rows.Count]; for (int ii = 0; ii < table.Rows.Count; ii++) { days[ii] = table.Rows[ii][0].ToString().Trim(); } return days; }
protected void Button1_Click(object sender, EventArgs e) { // Data source control that works with Sql databases SqlDataSource sds = new SqlDataSource(); // Get connection string from application's default configuration sds.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); // Create parameters with specified names and values sds.SelectParameters.Add("Username", TypeCode.String, this.TextBox1.Text); sds.SelectParameters.Add("Password", TypeCode.String, this.TextBox2.Text); // Set the SQL string to retrieve data from the underlying database sds.SelectCommand = "SELECT * FROM [UserTable] WHERE [Username] = @Username AND [Password] = @Password"; // Retrieve data DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty); // Display error message and return if the number of record is zero if (dv.Count == 0) { this.Label1.ForeColor = System.Drawing.Color.Red; this.Label1.Text = "Login Failed!"; return; } // Create session variables this.Session["Username"] = dv[0].Row["UserType"].ToString(); this.Session["UserType"] = dv[0].Row["UserType"].ToString(); // Redirect to respective page based on user type if (this.Session["UserType"].ToString().Equals("user")) { Response.Redirect("MainPageUsers.aspx"); } else if (this.Session["UserType"].ToString().Equals("admin")) { Response.Redirect("MainPageAdmin.aspx"); } }
public string getWednesday(int advisor_Id) { string Wednesday = "-"; SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select (CONVERT(varchar, Time_Start, 100)+ '-'+CONVERT(varchar, Time_End, 100)) As Time From Availability Where DayAvailable='Wednesday' AND Employee_ID='" + advisor_Id + "'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); if (table.Rows.Count > 0) {Wednesday = table.Rows[0][0].ToString();} return Wednesday; }
//----------------------------------------Basics----------------------------- public string[] getDaysAvailable(int id) { SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select DaysAvailable From AdvisorSchedule Where Advisor_Id='" + id + "'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); string days = table.Rows[0][0].ToString(); string[] splitDays = days.Split(','); return splitDays; return splitDays; }
// V 1.0.0 public List <CurriculumGeneralData> getCurriculum_Degree(string degree_char) { List <CurriculumGeneralData> Curriculum_data = new List <CurriculumGeneralData>(); string degree_level = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); if (degree_char == "U") { degree_level = "01"; } else if (degree_char == "B") { degree_level = "02"; } else if (degree_char == "M") { degree_level = "03"; } else if (degree_char == "D") { degree_level = "04"; } else if (degree_char == "P") { degree_level = "05"; } oracleObj.SelectCommand = "Select * From CURRICULUM Where LEVELCODE = '" + degree_level + "' AND CURRCODE !='999999999' AND APPROVESTATUS='Y' Order By CURRCODE"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { CurriculumGeneralData Curriculum = new CurriculumGeneralData(); Curriculum.Curr_Code = rowData["CURRCODE"].ToString(); Curriculum.Curr_Year = rowData["YEARVERSION"].ToString(); Curriculum.Faculty_Code = rowData["FACULTYCODE"].ToString(); Curriculum.Department_Code = rowData["DEPARTMENTCODE"].ToString(); //Curriculum.Major_Code = rowData["DIVISIONCODE"].ToString(); Curriculum.Curr_ThaiName = rowData["CURRTHNAME"].ToString(); Curriculum.Curr_EngName = rowData["CURRENNAME"].ToString(); Curriculum.Degree_Level = rowData["LEVELCODE"].ToString(); if (Curriculum.Degree_Level == "01") { Curriculum.Degree_Char = "U"; } else if (Curriculum.Degree_Level == "02") { Curriculum.Degree_Char = "B"; } else if (Curriculum.Degree_Level == "03") { Curriculum.Degree_Char = "M"; } else if (Curriculum.Degree_Level == "04") { Curriculum.Degree_Char = "D"; } else if (Curriculum.Degree_Level == "05") { Curriculum.Degree_Char = "P"; } Curriculum_data.Add(Curriculum); } return(Curriculum_data); }
public DateTime[] getTaken(int advisor_Id, string date) { SqlDataSource SqlDataSource3 = new SqlDataSource(); SqlDataSource3.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource3.SelectCommand = "Select Time From Scheduling Where Advisor_Id='" + advisor_Id + "' AND Date='" + date + "'"; DataView view = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); // string[] slotsTaken = new string[table.Rows.Count]; DateTime[] slotsTaken = new DateTime[table.Rows.Count]; for (int ii = 0; ii < table.Rows.Count; ii++) { slotsTaken[ii] = DateTime.Parse(table.Rows[ii][0].ToString()); } // Label1.Text = slotsTaken[0].ToShortTimeString(); return slotsTaken; }
public int[] getAdvisorIDs() { SqlDataSource SqlDataSource3 = new SqlDataSource(); SqlDataSource3.ConnectionString = ConfigurationManager.ConnectionStrings["AdvisorBookingConnectionString"].ToString(); SqlDataSource3.SelectCommand = "Select Distinct(Advisor_ID) From AdvisorSchedules"; DataView view = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); // string[] slotsTaken = new string[table.Rows.Count]; int[] Employee_ID = new int[table.Rows.Count]; for (int ii = 0; ii < table.Rows.Count; ii++) { Employee_ID[ii] = Convert.ToInt32(table.Rows[ii][0].ToString()); } return Employee_ID; }
protected void Button1_Click(object sender, EventArgs e) { ListBox1.Items.Clear(); ListBox2.Items.Clear(); ListBox3.Items.Clear(); ListBox4.Items.Clear(); ListBox5.Items.Clear(); ListBox6.Items.Clear(); //SqlDataSource sql2 = new SqlDataSource(); //sql2.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; //sql2.SelectCommand = "select message from status_messages where id>=53234;"; //sql2.DataBind(); //DataView ict1 = (DataView)sql2.Select(DataSourceSelectArguments.Empty); //List<URL_data> URL_info = new List<URL_data>(); //if (ict1.Count > 0) //{ // for (int ix = 0; ix < 100; ix++) // { // ListBox5.Items.Add(ict1.Table.Rows[ix]["message"].ToString()); // List<URL_data> URL_info_new = new List<URL_data>(); // URL_info_new = ConvertUrlsToLinks_DIV(ict1.Table.Rows[ix]["message"].ToString()); // //SWITCHOFFSET(SYSDATETIMEOFFSET(), '+09:00') // //if ((DateTime.Now - dt).TotalDays < 14) // //{ // // Image img = new Image(); // // img.ImageUrl = "~/images/home_images/new.png"; // // pdn_list1.Controls.Add(img); // //} // for (int i = 0; i < URL_info_new.Count; i++) // { // URL_info.Add(URL_info_new[i]); // } // } // for (int i = 0; i < URL_info.Count; i++) // { // ListBox1.Items.Add(URL_info[i].url); // ListBox2.Items.Add(URL_info[i].title); // ListBox3.Items.Add(URL_info[i].des); // ListBox4.Items.Add(URL_info[i].image_url); // } //} SqlDataSource sql3 = new SqlDataSource(); sql3.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql3.SelectCommand = "select * from status_messages where id>=53234;"; sql3.DataBind(); DataView ict2 = (DataView)sql3.Select(DataSourceSelectArguments.Empty); List <URL_data> URL_info = new List <URL_data>(); if (ict2.Count > 0) { for (int ix = 600; ix < ict2.Count; ix++) { ListBox5.Items.Add(ict2.Table.Rows[ix]["message"].ToString()); List <URL_data> URL_info_new = new List <URL_data>(); URL_info_new = ConvertUrlsToLinks_DIV(ict2.Table.Rows[ix]["message"].ToString()); //SWITCHOFFSET(SYSDATETIMEOFFSET(), '+09:00') //if ((DateTime.Now - dt).TotalDays < 14) //{ // Image img = new Image(); // img.ImageUrl = "~/images/home_images/new.png"; // pdn_list1.Controls.Add(img); //} string indx = ict2.Table.Rows[ix]["year"].ToString() + "-" + ict2.Table.Rows[ix]["month"].ToString() + "-" + ict2.Table.Rows[ix]["day"].ToString() + " " + ict2.Table.Rows[ix]["hour"].ToString() + ":" + ict2.Table.Rows[ix]["minute"].ToString() + ":" + ict2.Table.Rows[ix]["second"].ToString(); DateTime indate = Convert.ToDateTime(indx); for (int i = 0; i < URL_info_new.Count; i++) { URL_info_new[i].update_time = indate.ToString("yyyy-MM-dd HH:mm:ss.fff"); } for (int i = 0; i < URL_info_new.Count; i++) { SqlDataSource sql2 = new SqlDataSource(); sql2.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql2.SelectCommand = "select id from status_messages_link_info where link like '" + URL_info_new[i].url + "';"; sql2.DataBind(); DataView ict1 = (DataView)sql2.Select(DataSourceSelectArguments.Empty); if (ict1.Count == 0) { SqlDataSource sql2_in = new SqlDataSource(); sql2_in.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql2_in.InsertCommand = "insert into status_messages_link_info(link,image_url,title,des,update_time)"; sql2_in.InsertCommand += " values(N'" + URL_info_new[i].url + "',N'" + URL_info_new[i].image_url + "',N'" + URL_info_new[i].title + "',N'" + URL_info_new[i].des + "','" + URL_info_new[i].update_time + "');"; sql2_in.Insert(); } URL_info.Add(URL_info_new[i]); } } for (int i = 0; i < URL_info.Count; i++) { ListBox1.Items.Add(URL_info[i].url); ListBox2.Items.Add(URL_info[i].title); ListBox3.Items.Add(URL_info[i].des); ListBox4.Items.Add(URL_info[i].image_url); ListBox6.Items.Add(URL_info[i].update_time); } } //ConvertUrlsToLinks(ict.Table.Rows[i]["message"].ToString()) }
public string getAdvisorImage(int advisor_Id) { SqlDataSource SqlDataSource3 = new SqlDataSource(); SqlDataSource3.ConnectionString = ConfigurationManager.ConnectionStrings["AdvisorBookingConnectionString"].ToString(); SqlDataSource3.SelectCommand = "Select Image From Advisor Where Employee_ID='" + advisor_Id + "'"; DataView view = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); // string[] slotsTaken = new string[table.Rows.Count]; string Employee_Image = ""; if (table.Rows.Count > 0) Employee_Image = table.Rows[0][0].ToString(); return Employee_Image; }
protected void Page_Load(object sender, EventArgs e) { //Finder IDet fra vores QueryString (?id=X) string ID = Request.QueryString["id"]; //Hvis der er uploadet et profilbillede vised dette og baggrunden gøres hvid if (System.IO.File.Exists(Server.MapPath("/Uploads/" + ID + "/profile.jpg"))) //Ser om der ligger et profilbillede i brugerens mappe { imgProfil.Visible = true; imgProfil.ImageUrl = "./Uploads/" + ID + "/profile.jpg"; //Gør billedet synligt og indsætter det billedeSkift.Attributes.Add("style", "background:color(white/" + ID + "/profile.jpg); "); } //Skifter bagrunden fra placeholder til hvid //Forbindelse til SQL Databasen SqlDataSource SqlDataSource1 = new SqlDataSource(); //Laver en SqlDataSource SqlDataSource1.ID = "SqlDataSource1"; //Giver den et ID this.Page.Controls.Add(SqlDataSource1); //Tilføjer den til siden SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["memorialtagConnectionString"].ConnectionString; //Vores connection string som er defineret i web.config SqlDataSource1.SelectCommand = "SELECT * FROM [Grav] WHERE ([GravID] = " + ID + ")"; //Vores SELECT statement //Error handling med try catch try { DataView test = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); //Laver et test dataview til vores template labFornavn.Text = test.Table.Rows[0][2].ToString(); //Tester om der er lagt data i vores dataview } catch { Response.Redirect("./default.aspx"); //Hvis ikke der ligger data i vores dataview ... } DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); //Laver det egentlige dataview der bruges //Indsætter teksten fra placeringen i vores dataview i de valgte textboxes labFuldeNavn.Text = dv.Table.Rows[0][2].ToString() + " " + dv.Table.Rows[0][3].ToString(); labKirkegård.Text = "Kirkegård: " + dv.Table.Rows[0][1].ToString(); labID.Text = "ID: " + dv.Table.Rows[0][0].ToString(); labFornavn.Text = dv.Table.Rows[0][2].ToString(); labEfternavn.Text = dv.Table.Rows[0][3].ToString(); DateTime føsdag = DateTime.Parse(dv.Table.Rows[0][4].ToString()); labFødselsdato.Text = føsdag.ToShortDateString(); tidslinjeFødselsår.Text = føsdag.Year.ToString(); DateTime dødsdag = DateTime.Parse(dv.Table.Rows[0][5].ToString()); labDødsdato.Text = dødsdag.ToShortDateString(); tidslinjeDødsår.Text = dødsdag.Year.ToString(); labFødeby.Text = dv.Table.Rows[0][6].ToString(); labSidsteBopæl.Text = dv.Table.Rows[0][7].ToString(); labStilling.Text = dv.Table.Rows[0][8].ToString(); labNærmestePårørende.Text = dv.Table.Rows[0][9].ToString(); btnLinkFB.PostBackUrl = dv.Table.Rows[0][10].ToString(); btnLinkMH.PostBackUrl = dv.Table.Rows[0][11].ToString(); labBiografi.Text = dv.Table.Rows[0][12].ToString(); labUddannelse.Text = dv.Table.Rows[0][13].ToString(); labKarriere.Text = dv.Table.Rows[0][14].ToString(); labBedrifter.Text = dv.Table.Rows[0][15].ToString(); //Collapser links, labels og boxes hvis de er tomme if (btnLinkFB.PostBackUrl == "") { btnLinkFB.Visible = false; } if (btnLinkMH.PostBackUrl == "") { btnLinkMH.Visible = false; } if (labBiografi.Text == "") { labBiografi.Visible = false && labBiografiOverskrift.Visible == false; } if (labUddannelse.Text == "") { labUddannelse.Visible = false && labUdannelseOverskrift.Visible == false; } if (labKarriere.Text == "") { labKarriere.Visible = false && labKarriereOverskrift.Visible == false; } if (labBedrifter.Text == "") { labBedrifter.Visible = false && labBedrifterOverskrift.Visible == false; } if (labBiografi.Text == "" && labUddannelse.Text == "" && labKarriere.Text == "" && labBedrifter.Text == "") { Biografi.Visible = false; } PopulateImages(); }
// V 1.0.0 public List <BankData> getBankData_AllDegree(string selected_date) { List <BankData> bankData = new List <BankData>(); string sql = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); sql = "Select * From BANK_DATA Where BANK_SUMDATE = '" + selected_date + "' "; oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { BankData bank_data = new BankData(); DegreeData degree_data = new DegreeData(); bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray(); bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray(); bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode)); bank_data.Bank_ShortName = bankcode_data.Bank_ShortName; bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName; bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray(); bank_data.Student_Name = rowData["STUDENT_NAME"].ToString(); bank_data.Student_ID = rowData["STUDENT_ID"].ToString(); bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString(); bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString(); bank_data.Semester = rowData["SEMESTER"].ToString(); bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString(); bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString(); bank_data.Payment_Time = rowData["PAYMENT_TIME"].ToString(); bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date); bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1); degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level); bank_data.Degree_Char = degree_data.Degree_Char; bank_data.Degree_ThaiName = degree_data.Degree_Thai; bank_data.DueDate = rowData["DUE_DATE"].ToString(); bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate); bank_data.SumDate = rowData["BANK_SUMDATE"].ToString(); bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate); bank_data.Status = rowData["STATUS"].ToString(); bankData.Add(bank_data); } sql = "Select * From GRAD_BANK_DATA Where BANK_SUMDATE = '" + selected_date + "' "; oracleObj.SelectCommand = sql; DataView allData2 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData2) { BankData bank_data = new BankData(); DegreeData degree_data = new DegreeData(); bank_data.Amount = rowData["AMOUNT"].ToString().ToCharArray(); bank_data.BankCode = rowData["BANK_CODE"].ToString().ToCharArray(); bankcode_data = bankcodeObj.getBankCode(new string(bank_data.BankCode)); bank_data.Bank_ShortName = bankcode_data.Bank_ShortName; bank_data.Bank_ThaiName = bankcode_data.Bank_ThaiName; bank_data.TrancCode = rowData["TRANSACTION_CODE"].ToString().ToCharArray(); bank_data.Student_Name = rowData["STUDENT_NAME"].ToString(); bank_data.Student_ID = rowData["STUDENT_ID"].ToString(); bank_data.Nation_Passport_ID = rowData["NATION_PASSPORT_ID"].ToString(); bank_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString(); bank_data.Semester = rowData["SEMESTER"].ToString(); bank_data.Paymenty_ID = rowData["PAYMENT_ID"].ToString(); bank_data.Payment_Date = rowData["PAYMENT_DATE"].ToString(); bank_data.ThaiPayment_Date = new utility().getThaiBirthDay(bank_data.Payment_Date); bank_data.Degree_Level = bank_data.Paymenty_ID.Substring(0, 1); degree_data = new DegreeAdmission().getDegreeAdmission(bank_data.Degree_Level); bank_data.Degree_Char = degree_data.Degree_Char; bank_data.Degree_ThaiName = degree_data.Degree_Thai; bank_data.DueDate = rowData["DUE_DATE"].ToString(); bank_data.ThaiDueDate = new utility().getThaiBirthDay(bank_data.DueDate); bank_data.SumDate = rowData["BANK_SUMDATE"].ToString(); bank_data.ThaiSumDate = new utility().getThaiBirthDay(bank_data.SumDate); bank_data.Status = rowData["STATUS"].ToString(); bankData.Add(bank_data); } return(bankData); }
private void executeQuery() { x = new SqlDataSource(); x.ConnectionString = @"Data Source=iii0.database.windows.net;Initial Catalog=prjTRK;Persist Security Info=True;User ID=iii;Password=P@ssw0rd"; x.SelectCommand = "Select *,convert(varchar(100),startDate,111) as SDate,convert(varchar(100),endDate,111) as EDate from Promotions where activityID ='" + activity.Text + "'"; DataView dv = x.Select(DataSourceSelectArguments.Empty) as DataView; //查完一定只有一筆, 所以Rows[0]選第一筆資料即可 titleInput.Text = dv.Table.Rows[0]["title"].ToString(); startDate.Text = dv.Table.Rows[0]["SDate"].ToString(); endDate.Text = dv.Table.Rows[0]["EDate"].ToString(); txtNewsContent.Text = dv.Table.Rows[0]["content"].ToString(); txtRemark.Text = dv.Table.Rows[0]["comment"].ToString(); picUP.ImageUrl = "~/pic/" + dv.Table.Rows[0]["picPath"].ToString(); }
public DateTime[] getTaken(int advisor_Id, string date) { SqlDataSource SqlDataSource3 = new SqlDataSource(); SqlDataSource3.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource3.SelectCommand = "Select Time From Appointment,Availability Where Appointment.Availability_Id=Availability.Availability_Id AND Employee_ID='" + advisor_Id + "' AND Date='" + date + "'"; DataView view = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); DateTime[] slotsTaken = new DateTime[table.Rows.Count]; for (int ii = 0; ii < table.Rows.Count; ii++) { slotsTaken[ii] = DateTime.Parse(table.Rows[ii][0].ToString()); } return slotsTaken; }
public static bool DuplicateProject(string projectID, string projectNewName) { SqlDataSource dataSource = new SqlDataSource(); // Super bad? Copy pasta from web.config dataSource.ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\sunspace_db.mdf;Integrated Security=True;Connect Timeout=30"; Project aProject = new Project(); System.Data.DataView selectProject = new System.Data.DataView(); string sqlSelect; string sqlInsert; List <string> tableNames = new List <string>(); int newProjectID; // New project ID for all the compenents of a project int tableCount; // Number of tables // Select the project sqlSelect = "SELECT project_type,"+ "installation_type," + "customer_id," + "user_id," + "date_created," + "status," + "revised_date," + "revised_user_id," + "msrp," + "project_notes," + "hidden," + "cut_pitch" + " FROM Projects" + " WHERE project_ID = " + projectID + ";"; dataSource.SelectCommand = sqlSelect; selectProject = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); Debug.WriteLine(selectProject[0].Row[0]); // Insert the new project with the duplicated data! sqlInsert = "INSERT INTO Projects(project_type, " + "installation_type, " + "customer_id, " + "user_id, " + "date_created, " + "status, " + "revised_date, " + "revised_user_id, " + "msrp, " + "project_notes, " + "hidden, " + "cut_pitch, " + "project_name " + ") VALUES ( '" + selectProject[0].Row[0] + "'," + "'" + selectProject[0].Row[1] + "'," + "'" + selectProject[0].Row[2] + "'," + "'" + selectProject[0].Row[3] + "'," + "'" + selectProject[0].Row[4] + "'," + "'" + selectProject[0].Row[5] + "'," + "'" + selectProject[0].Row[6] + "'," + "'" + selectProject[0].Row[7] + "'," + "'" + selectProject[0].Row[8] + "'," + "'" + selectProject[0].Row[9] + "'," + "'" + selectProject[0].Row[10] + "'," + "'" + selectProject[0].Row[11] + "'," + "'" + projectNewName + "' ); "; //+ //" WHERE project_ID = '" + projectID + "';"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); // Grab project id from the last insert! sqlSelect = "SELECT project_ID from Projects WHERE project_ID = IDENT_CURRENT('Projects');"; dataSource.SelectCommand = sqlSelect; selectProject = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); // Set new project id newProjectID = (int)selectProject[0].Row[0]; Debug.WriteLine(selectProject[0].Row[0]); // Get table count sqlSelect = "Select Count(*) From INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE 'project_id' AND TABLE_NAME <> 'projects'"; dataSource.SelectCommand = sqlSelect; selectProject = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); // Set table count tableCount = (int)selectProject[0].Row[0]; Debug.WriteLine(selectProject[0].Row[0]); // Essentially this gets a compenent table info and re-inserts it with the new project ID for (int index = 0; index < tableCount; index++) { // Get table names sqlSelect = "SELECT TABLE_NAME From INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE 'project_id' AND TABLE_NAME <> 'projects' ORDER BY TABLE_NAME ASC OFFSET " + index + " ROWS FETCH NEXT 1 ROWS ONLY"; dataSource.SelectCommand = sqlSelect; selectProject = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); tableNames.Add((string)selectProject[0].Row[0]); Debug.WriteLine("Table Name: " + selectProject[0].Row[0]); Debug.WriteLine("Table Count:" + tableNames.Count()); // Select rows with the old project id sqlSelect = "SELECT * FROM " + selectProject[0].Row[0] + " WHERE project_ID = " + projectID; dataSource.SelectCommand = sqlSelect; selectProject = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); // // If we actually need this table.. // if (selectProject.Count > 0) { Debug.WriteLine(selectProject[0].Row[0]); // Start the insert statement sqlInsert = "INSERT INTO " + tableNames[index] + " VALUES ("; // Inserts the values for (int index2 = 0; index2 < selectProject[0].Row.ItemArray.Count(); index2++) { Debug.WriteLine(selectProject[0].Row[index2]); if (index2 == 0) { sqlInsert += "'" + newProjectID + "', "; } else if (index2 != (selectProject[0].Row.ItemArray.Count() - 1)) { sqlInsert += "'" + selectProject[0].Row[index2] + "', "; } else { sqlInsert += "'" + selectProject[0].Row[index2] + "'"; } } // Close the insert sqlInsert += ");"; Debug.WriteLine(sqlInsert); // Actually insert the data dataSource.InsertCommand = sqlInsert; dataSource.Insert(); } } return(true); }
public int[] getAdvisorId(DateTime date) { string container; SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select AdvisorSchedule.Advisor_Id From AdvisorSchedule,Advisor_Master Where AdvisorSchedule.Advisor_Id=Advisor_Master.Advisor_Id AND StartDate < '" + date.ToShortDateString() + "' AND FinishDate > '" + date.ToShortDateString() + "' AND DaysAvailable Like '%" + date.DayOfWeek.ToString() + "%'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); int[] advisorId = new int[table.Rows.Count]; for (int i = 0; i < table.Rows.Count; i++) { container = table.Rows[i][0].ToString(); advisorId[i] = Convert.ToInt16(container); } return advisorId; //Label1.Text = Session["date"].ToString(); }
protected void Page_Init(object sender, EventArgs e) { //user photo and name user_photo //預かり日時 sandbox-container //預かり内容 report_content //預かり時の様子 report_list string selectdate = "", photo = "", username = "", howtoget_there = ""; string cutstr_h = "", cutstr_h1 = ""; int ind_h = 0; List <string> kidlist = new List <string>(); DateTime todate = new DateTime(); string week = ""; string constr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; string activationCode = !string.IsNullOrEmpty(Request.QueryString["ActivationCode"]) ? Request.QueryString["ActivationCode"] : Guid.Empty.ToString(); SqlDataSource sql_f = new SqlDataSource(); sql_f.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_f.SelectCommand = "select uid,supp_id,uiacdid"; sql_f.SelectCommand += " from user_information_store_week_appointment_check_check"; sql_f.SelectCommand += " where ActivationCode='" + activationCode + "';"; sql_f.DataBind(); DataView ict_f = (DataView)sql_f.Select(DataSourceSelectArguments.Empty); string id = "", supid = "", uiacdid = ""; for (int i = 0; i < ict_f.Count; i++) { id = ict_f.Table.Rows[i]["uid"].ToString(); supid = ict_f.Table.Rows[i]["supp_id"].ToString(); uiacdid = ict_f.Table.Rows[i]["uiacdid"].ToString(); } //now time string startd = DateTime.Now.Date.ToString("yyyy-MM-dd"); string starth = Convert.ToInt32(DateTime.Now.ToString("HH")).ToString(); string startm = DateTime.Now.Minute.ToString(); string starts = DateTime.Now.Second.ToString(); string start = startd + " " + starth + ":" + startm + ":" + starts; //now time if (Session["id"] != null) { if (Session["id"].ToString() == id.ToString()) { bool check_again = false; //select 定期 one day sql_f.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_f.SelectCommand = "select d.money_hour,d.hour,d.total_money,f.login_name,d.uisccid,a.id,d.uiswaid,d.uid,f.photo,f.username,a.type,a.check_success,d.start_date,d.end_date,d.start_hour,d.start_minute,d.end_hour,d.end_minute,d.howtoget_there"; sql_f.SelectCommand += " from user_information_appointment_check_deal as a"; sql_f.SelectCommand += " inner join user_information_appointment_check_connect_deal as b on a.id=b.uiacdid"; sql_f.SelectCommand += " inner join user_information_store_week_appointment_check as d on b.uiswacid=d.id"; sql_f.SelectCommand += " inner join user_login as f on f.id=a.uid "; sql_f.SelectCommand += " where a.type='1' and a.suppid='" + supid + "' and a.id='" + uiacdid + "' and check_success=4"; sql_f.SelectCommand += " order by DATEPART(day, d.start_date) asc,a.first_check_time asc,d.uid asc;"; sql_f.DataBind(); ict_f = (DataView)sql_f.Select(DataSourceSelectArguments.Empty); if (ict_f.Count > 0) { check_again = true; for (int i = 0; i < ict_f.Count; i++) { DateTime.TryParse(ict_f.Table.Rows[i]["start_date"].ToString(), out todate); if (todate.DayOfWeek == DayOfWeek.Monday) { week = "月曜日"; } else if (todate.DayOfWeek == DayOfWeek.Tuesday) { week = "火曜日"; } else if (todate.DayOfWeek == DayOfWeek.Wednesday) { week = "水曜日"; } else if (todate.DayOfWeek == DayOfWeek.Thursday) { week = "木曜日"; } else if (todate.DayOfWeek == DayOfWeek.Friday) { week = "金曜日"; } else if (todate.DayOfWeek == DayOfWeek.Saturday) { week = "土曜日"; } else if (todate.DayOfWeek == DayOfWeek.Sunday) { week = "日曜日"; } selectdate = "<br/><span style='font-size:large;color:#EA9494;'>単発</span><br/>"; selectdate += "<br/><span style='font-size:large;color:#EA9494;'>" + week + ", " + todate.Month + " 月 " + todate.Day + " 日, "; selectdate += ict_f.Table.Rows[i]["start_hour"].ToString() + ":" + ict_f.Table.Rows[i]["start_minute"].ToString() + "~" + ict_f.Table.Rows[i]["end_hour"].ToString() + ":" + ict_f.Table.Rows[i]["end_minute"].ToString() + "</span><br/>"; howtoget_there = "<br/><span>" + ict_f.Table.Rows[i]["howtoget_there"].ToString() + "</span><br/>"; } } //select 定期 more than one day SqlDataSource sql_f1 = new SqlDataSource(); sql_f1.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_f1.SelectCommand = "select a.id,f.login_name,d.uisccid,d.uiswaid,d.uid,f.photo,f.username,a.type,a.check_success,d.start_date,d.end_date,d.start_hour,d.start_minute,d.end_hour,d.end_minute,d.howtoget_there"; sql_f1.SelectCommand += " from user_information_appointment_check_deal as a"; sql_f1.SelectCommand += " inner join user_information_appointment_check_connect_deal as b on a.id=b.uiacdid"; sql_f1.SelectCommand += " inner join user_information_store_week_appointment_check as d on b.uiswacid=d.id"; sql_f1.SelectCommand += " inner join user_login as f on f.id=a.uid"; sql_f1.SelectCommand += " where a.type='2' and a.suppid='" + supid + "' and a.id='" + uiacdid + "' and check_success=4"; sql_f1.SelectCommand += " order by DATEPART(day, d.start_date) asc,a.first_check_time asc,a.id asc;"; sql_f1.DataBind(); DataView ict_f1 = (DataView)sql_f1.Select(DataSourceSelectArguments.Empty); if (ict_f1.Count > 0) { check_again = true; for (int ii = 0; ii < ict_f1.Count; ii++) { DateTime.TryParse(ict_f1.Table.Rows[ii]["start_date"].ToString(), out todate); if (todate.DayOfWeek == DayOfWeek.Monday) { week = "月曜日"; } else if (todate.DayOfWeek == DayOfWeek.Tuesday) { week = "火曜日"; } else if (todate.DayOfWeek == DayOfWeek.Wednesday) { week = "水曜日"; } else if (todate.DayOfWeek == DayOfWeek.Thursday) { week = "木曜日"; } else if (todate.DayOfWeek == DayOfWeek.Friday) { week = "金曜日"; } else if (todate.DayOfWeek == DayOfWeek.Saturday) { week = "土曜日"; } else if (todate.DayOfWeek == DayOfWeek.Sunday) { week = "日曜日"; } selectdate = "<br/><span style='font-size:large;color:#EA9494;'>定期</span><br/>"; selectdate += "<br/><span style='font-size:large;color:#EA9494;'>" + todate.Month + " 月 " + todate.Day + " 日 ~ "; DateTime.TryParse(ict_f1.Table.Rows[ii]["end_date"].ToString(), out todate); selectdate += todate.Month + " 月 " + todate.Day + " 日</span><br/>"; sql_f.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_f.SelectCommand = "select d.money_hour,d.hour,d.total_money,d.uisccid,g.week_of_day_jp,g.week_of_day,a.id,d.uiswaid,d.uid,f.photo,f.username,a.type,a.check_success,d.start_date,d.end_date,d.start_hour,d.start_minute,d.end_hour,d.end_minute,d.howtoget_there"; sql_f.SelectCommand += " from user_information_appointment_check_deal as a"; sql_f.SelectCommand += " inner join user_information_appointment_check_connect_deal as b on a.id=b.uiacdid"; sql_f.SelectCommand += " inner join user_information_store_week_appointment_check as d on b.uiswacid=d.id"; sql_f.SelectCommand += " inner join user_login as f on f.id=a.uid"; sql_f.SelectCommand += " inner join user_information_store_week_appointment as g on g.id=d.uiswaid"; sql_f.SelectCommand += " where a.id='" + uiacdid + "' and a.type='2' and a.suppid='" + supid + "'"; sql_f.SelectCommand += " order by DATEPART(day, d.start_date) asc,a.first_check_time asc,d.uid asc;"; sql_f.DataBind(); ict_f = (DataView)sql_f.Select(DataSourceSelectArguments.Empty); string temp_uiswaid = "", temp_uid = ""; bool check_same = false; if (ict_f.Count > 0) { for (int i = 0; i < ict_f.Count; i++) { check_same = false; if (i == 0) { temp_uiswaid = ict_f.Table.Rows[i]["uiswaid"].ToString(); temp_uid = ict_f.Table.Rows[i]["uid"].ToString(); check_same = true; } else { if (temp_uiswaid != ict_f.Table.Rows[i]["uiswaid"].ToString() || temp_uid != ict_f.Table.Rows[i]["uid"].ToString()) { temp_uiswaid = ict_f.Table.Rows[i]["uiswaid"].ToString(); temp_uid = ict_f.Table.Rows[i]["uid"].ToString(); check_same = true; } } if (check_same) { week = ict_f.Table.Rows[i]["week_of_day_jp"].ToString() + "曜日"; selectdate += "<br/><span style='font-size:large;color:#EA9494;'>" + week + ", "; selectdate += ict_f.Table.Rows[i]["start_hour"].ToString() + ":" + ict_f.Table.Rows[i]["start_minute"].ToString() + "~" + ict_f.Table.Rows[i]["end_hour"].ToString() + ":" + ict_f.Table.Rows[i]["end_minute"].ToString() + "</span><br/>"; } } } howtoget_there = "<br/><span>" + ict_f1.Table.Rows[ict_f1.Count - 1]["howtoget_there"].ToString() + "</span><br/><br/>"; } } sql_f1 = new SqlDataSource(); sql_f1.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_f1.SelectCommand = "select photo,username"; sql_f1.SelectCommand += " from user_login"; sql_f1.SelectCommand += " where id='" + supid + "';"; sql_f1.DataBind(); ict_f1 = (DataView)sql_f1.Select(DataSourceSelectArguments.Empty); if (ict_f1.Count > 0) { //user photo photo = "<div class='zoom-gallery'>"; cutstr_h = ict_f1.Table.Rows[0]["photo"].ToString(); ind_h = cutstr_h.IndexOf(@"/"); cutstr_h1 = cutstr_h.Substring(ind_h + 1, cutstr_h.Length - ind_h - 1); photo += "<a href='" + cutstr_h1 + "' data-source='" + cutstr_h1 + "' title='" + ict_f1.Table.Rows[0]["username"].ToString() + "' style='width:100px;height:100px;'>"; photo += "<img src='" + cutstr_h1 + "' width='100' height='100' />"; photo += "</a>"; photo += "</div>"; username = "******" + ict_f1.Table.Rows[0]["username"].ToString() + "</span><br/>"; } //user photo and name user_photo //預かり日時 sandbox-container //預かり内容 report_content //預かり時の様子 report_list string information_pan = ""; information_pan += @"<table width='100%' height='100%' style='background-color: #F5F5F5;'> <tr><td width='5%'></td><td width='90%'> "; //user photo information_pan += @"<table width='100%'> <tr><td width='10%'></td><td width='80%' align='center' valign='top'>" + photo + @" </td><td width='10%'></td></tr> </table>"; //user name information_pan += @"<table width='100%'> <tr><td width='10%'></td><td width='80%' align='center' valign='top'>"; information_pan += username; information_pan += @"<br/><br/></td><td width='10%'></td></tr> </table>"; user_photo.Controls.Add(new LiteralControl(information_pan)); sandboxcontainer.Controls.Add(new LiteralControl(selectdate)); report_content.Controls.Add(new LiteralControl(howtoget_there)); //string relist = ""; //sql_f1 = new SqlDataSource(); //sql_f1.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; //sql_f1.SelectCommand = "select content_success"; //sql_f1.SelectCommand += " from user_information_appointment_check_deal"; //sql_f1.SelectCommand += " where id='" + uiacdid + "';"; //sql_f1.DataBind(); //ict_f1 = (DataView)sql_f1.Select(DataSourceSelectArguments.Empty); //if (ict_f1.Count > 0) //{ // relist = "<span style='text-align: center;font-size:medium;'>" + ict_f1.Table.Rows[0]["content_success"].ToString() + "</span><br/>"; //} if (check_again) { button_pan.Controls.Add(new LiteralControl("<input type='button' id='buttonsub_" + uiacdid + "' value='評価を送付' onclick='report_create_success(this.id)' style='width: 100%;text-shadow: none;cursor: pointer;text-align: center;' class='file-upload'>")); } } else { Response.Redirect("main.aspx"); } } else { Response.Redirect("main.aspx"); } }
public bool getCheck(string stID) { int Student_Id = Convert.ToInt32(stID); DateTime date = DateTime.Now; SqlDataSource SqlDataSource3 = new SqlDataSource(); SqlDataSource3.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource3.SelectCommand = "Select Time From Scheduling Where Student_Id='" + Student_Id + "' AND Date>'" + date + "'"; DataView view = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); // string[] slotsTaken = new string[table.Rows.Count]; bool check=false; if (table.Rows.Count==0) {check=true;} return check; }
private void Initial_loadpageAD() { Literal ltlCarouselAD = (Literal)home.FindControl("ltlCarouselAD"); String strCarouselAD = ""; int countAD = 0; SqlDataSource sds_carousel = new SqlDataSource(); sds_carousel.DataSourceMode = SqlDataSourceMode.DataReader; sds_carousel.ConnectionString = str_Data_Source; sds_carousel.SelectCommand = "SELECT fId, fPic, fFirst, fSecond, fThird from t前台輪播"; System.Data.SqlClient.SqlDataReader sdr輪播 = (System.Data.SqlClient.SqlDataReader)sds_carousel.Select(DataSourceSelectArguments.Empty); if (sdr輪播.HasRows) { while (sdr輪播.Read()) { countAD++; if (countAD == 1) { strCarouselAD += "<div class='item active'>"; strCarouselAD += "<img class='img-responsive' src='" + sdr輪播["fPic"].ToString() + "' alt='slider' style='width:1600px;height:300px' />"; strCarouselAD += "<div class='slider-content'>"; strCarouselAD += "<div class='col-md-12 text-center'>"; strCarouselAD += "<h3 class='animated2 white'>"; strCarouselAD += "<span><strong>" + sdr輪播["fFirst"].ToString() + "</strong>" + sdr輪播["fSecond"].ToString() + "</span>"; strCarouselAD += "</h3><br />"; strCarouselAD += "<h4 class='animated3'>"; strCarouselAD += "<span>" + sdr輪播["fThird"].ToString() + "</span></h4></div></div></div>"; } if (countAD == 2) { strCarouselAD += "<div class='item'>"; strCarouselAD += "<img class='img-responsive' src='" + sdr輪播["fPic"].ToString() + "' alt='slider' style='width:1600px;height:300px' />"; strCarouselAD += "<div class='slider-content'>"; strCarouselAD += "<div class='col-md-12 text-center'>"; strCarouselAD += "<h3 class='animated4 white'>"; strCarouselAD += "<span><strong>" + sdr輪播["fFirst"].ToString() + "</strong>" + sdr輪播["fSecond"].ToString() + "</span>"; strCarouselAD += "</h3><br />"; strCarouselAD += "<h4 class='animated5'>"; strCarouselAD += "<span>" + sdr輪播["fThird"].ToString() + "</span></h4></div></div></div>"; } if (countAD == 3) { strCarouselAD += "<div class='item'>"; strCarouselAD += "<img class='img-responsive' src='" + sdr輪播["fPic"].ToString() + "' alt='slider' style='width:1600px;height:300px' />"; strCarouselAD += "<div class='slider-content'>"; strCarouselAD += "<div class='col-md-12 text-center'>"; strCarouselAD += "<h3 class='animated7 white'>"; strCarouselAD += "<span><strong>" + sdr輪播["fFirst"].ToString() + "</strong>" + sdr輪播["fSecond"].ToString() + "</span>"; strCarouselAD += "</h3><br />"; strCarouselAD += "<h4 class='animated8'>"; strCarouselAD += "<span>" + sdr輪播["fThird"].ToString() + "</span></h4></div></div></div>"; } } } ltlCarouselAD.Text = strCarouselAD; }
/// <summary> /// Handles the Click event of the btn_Buscar control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> protected void btn_Buscar_Click(object sender, EventArgs e) { //Inicializar variables. String sqlConsulta = ""; String sqlWhere = ""; String sqlConsultaFinal = ""; try { #region Construcción de la consulta dependiendo de el nombre y número del plan/proyecto. if (txt_NombrePlan.Text.Trim() == "" && txt_NumeroPlan.Text.Trim() == "") { sqlConsulta = " SELECT DISTINCT Id_Contacto, Nombres, Apellidos, Email, Identificacion, NomGrupo, " + /*Se debe colocar las columnas para evitar que se "dañe el flujo" del código.*/ " '' AS Id_Proyecto, '' AS Id_Grupo, '' AS NomGrupo, '' AS NomProyecto " + " FROM Contacto c LEFT JOIN GrupoContacto gc " + " ON c.Id_Contacto = gc.CodContacto LEFT JOIN Grupo g on gc.CodGrupo = g.Id_Grupo"; } else { sqlConsulta = " SELECT DISTINCT Id_Contacto, Nombres, Apellidos, Email, Identificacion, NomProyecto, " + " Id_Proyecto, Id_Grupo, NomGrupo " + " FROM contacto c LEFT JOIN proyectocontacto pc " + " ON c.Id_Contacto = pc.CodContacto LEFT JOIN proyecto p " + " ON pc.CodProyecto = p.id_proyecto LEFT JOIN GrupoContacto gc " + " ON c.Id_Contacto = gc.CodContacto LEFT JOIN Grupo g " + " ON gc.CodGrupo = g.id_Grupo"; } #endregion if (sqlWhere.Trim() == "") { } //Consulta sqlConsultaFinal = sqlConsulta; // +" " + sqlWhere; if (!String.IsNullOrEmpty(txt_Nombres.Text) || !String.IsNullOrEmpty(txt_Apellidos.Text) || !String.IsNullOrEmpty(txt_Email.Text) || !String.IsNullOrEmpty(txt_Identificacion.Text) || !String.IsNullOrEmpty(txt_NombrePlan.Text) || !String.IsNullOrEmpty(txt_NumeroPlan.Text)) { sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, " where "); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_Nombres.Text) ? string.Format(" + Nombres LIKE'%{0}%' ", txt_Nombres.Text) : string.Empty); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_Apellidos.Text) ? string.Format(" + Apellidos LIKE'%{0}%' ", txt_Apellidos.Text) : string.Empty); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_Email.Text) ? string.Format(" + Email LIKE'%{0}%' ", txt_Email.Text) : string.Empty); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_Identificacion.Text) ? string.Format(" + Identificacion IN ({0})", txt_Identificacion.Text) : string.Empty); if (!String.IsNullOrEmpty(txt_NombrePlan.Text) || !String.IsNullOrEmpty(txt_NumeroPlan.Text)) { sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_NombrePlan.Text) ? string.Format(" + NomProyecto LIKE'%{0}%'", txt_NombrePlan.Text) : string.Empty); sqlConsultaFinal = sqlConsultaFinal.Insert(sqlConsultaFinal.Length, !String.IsNullOrEmpty(txt_NumeroPlan.Text) ? string.Format(" + Id_Proyecto IN({0})", txt_NumeroPlan.Text) : string.Empty); } sqlConsultaFinal = sqlConsultaFinal.IndexOf("+") > -1 ? sqlConsultaFinal.Remove(sqlConsultaFinal.IndexOf("+"), 1) : sqlConsultaFinal; var ijn = sqlConsultaFinal.Split('+'); sqlConsultaFinal = ijn.Length >= 2 ? sqlConsultaFinal.Replace("+", " AND ") : sqlConsultaFinal.Replace("+", string.Empty); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Vldt", "alert('Especifique los parámetros de consulta.')", true); return; } SqlDataSource sqlds = new SqlDataSource(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString + ";Connect Timeout=120", sqlConsultaFinal) { DataSourceMode = SqlDataSourceMode.DataReader, ConflictDetection = ConflictOptions.OverwriteChanges, CancelSelectOnNullParameter = true, SelectCommandType = SqlDataSourceCommandType.Text, ID = "sqlDs" }; sqlds.DataBind(); var dtEmpresas = new DataTable(); GridView1.DataSource = sqlds.Select(new DataSourceSelectArguments()); sqlds.DataBind(); GridView1.DataBind(); //Según el comportamiento del FONADE clásico, los campos son vaciados al terminar de consultar. txt_Nombres.Text = ""; txt_Apellidos.Text = ""; txt_Email.Text = ""; txt_Identificacion.Text = ""; txt_NombrePlan.Text = ""; txt_NumeroPlan.Text = ""; } catch { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Mensaje", "alert('Error en la consulta y/o procedimiento.')", true); return; } }
//-------------------------------------Get Advisors By Date ----------------------------------------------------------- public string[] getAdvisorNames(DateTime date) { SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select Dept_Name,(Last_Name+', ' + First_Name) As Advisors From AdvisorSchedule,Advisor_Master,Department_Master Where AdvisorSchedule.Advisor_Id=Advisor_Master.Advisor_Id AND Advisor_Master.Dept_Id=Department_Master.Dept_Id AND StartDate < '" + date.ToShortDateString() + "' AND FinishDate > '" + date.ToShortDateString() + "' AND DaysAvailable Like '%" + date.DayOfWeek.ToString() + "%'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); string[] advisorNames = new string[table.Rows.Count]; for (int i = 0; i < table.Rows.Count; i++) { advisorNames[i] = table.Rows[i][0].ToString(); } return advisorNames; //Label1.Text = Session["date"].ToString(); }
// public string getMonday(int advisor_Id) // public string getTuesday(int advisor_Id) // public string getWednesday(int advisor_Id) // public string getThursday(int advisor_Id) // public string getFriday(int advisor_Id) public DateTime[] getSlots(int advisor_Id, string date) { DateTime advisorDateDateTime = DateTime.Parse(date); int week = GetWeekNumber(advisorDateDateTime); string day = advisorDateDateTime.DayOfWeek.ToString(); SqlDataSource SqlDataSource = new SqlDataSource(); SqlDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["AdvisorBookingConnectionString"].ToString(); SqlDataSource.SelectCommand = "Select StartTime,EndTime,AdvisorScheduleID From AdvisorSchedules Where Advisor_ID='" + advisor_Id + "' AND Day='" + day + "' And Week='" + week + "'"; DataView view = (DataView)SqlDataSource.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); DateTime[][] Slots = new DateTime[table.Rows.Count + 1][]; int[][] advisorSlotsAvailabilityID = new int[table.Rows.Count + 1][]; if (table.Rows.Count > 0) { for (int ii = 0; ii < table.Rows.Count; ii++) { DateTime start = DateTime.ParseExact(table.Rows[ii][0].ToString(), "HH:mm:ss", null); DateTime end = DateTime.Parse(table.Rows[ii][1].ToString()); double dbltime = ((end - start).TotalHours) * 2; int inttime = Convert.ToInt32(dbltime); DateTime[] advisorSlots = new DateTime[inttime]; int[] SlotsScheduleID = new int[inttime]; for (int i = 0; i < inttime; i++) { advisorSlots[i] = start; start = start.AddMinutes(30); SlotsScheduleID[i] = Convert.ToInt32(table.Rows[ii][2].ToString()); } Slots[ii] = advisorSlots; advisorSlotsAvailabilityID[ii] = SlotsScheduleID; } } Slots[table.Rows.Count] = new DateTime[0]; Slots[table.Rows.Count] = Slots[0]; advisorSlotsAvailabilityID[table.Rows.Count] = advisorSlotsAvailabilityID[0]; for (int i = 1; i < table.Rows.Count; i++) { if (table.Rows.Count > i) { Slots[table.Rows.Count] = Slots[table.Rows.Count].Concat(Slots[i]).ToArray(); advisorSlotsAvailabilityID[table.Rows.Count] = advisorSlotsAvailabilityID[table.Rows.Count].Concat(advisorSlotsAvailabilityID[i]).ToArray(); } } AllSlotsID = advisorSlotsAvailabilityID[table.Rows.Count]; AllSlots = Slots[table.Rows.Count]; Array.Sort(Slots[table.Rows.Count]); return Slots[table.Rows.Count]; }
public int[] getStudentIds() { SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["AdvisorBookingConnectionString"].ToString(); SqlDataSource2.SelectCommand = "Select Student_ID From Student"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); // string[] slotsTaken = new string[table.Rows.Count]; int[] Student_ID = new int[table.Rows.Count]; for (int ii = 0; ii < table.Rows.Count; ii++) { Student_ID[ii] = Convert.ToInt32(table.Rows[ii][0].ToString()); } return Student_ID; }
public DateTime[] getTaken(int advisor_Id, string date) { DateTime advisorDateDateTime = DateTime.Parse(date); int week = GetWeekNumber(advisorDateDateTime); string day = advisorDateDateTime.DayOfWeek.ToString(); //--------------------------------------- SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["AdvisorBookingConnectionString"].ToString(); SqlDataSource2.SelectCommand = "Select Appointment.Time_Start From Appointment,AdvisorSchedules Where Appointment.AdvisorScheduleID=AdvisorSchedules.AdvisorScheduleID AND Advisor_ID='" + advisor_Id + "' AND Day='" + day + "' And Week='" + week + "'"; DataView view2 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table2 = view2.ToTable(); DateTime[] slotsTaken = new DateTime[table2.Rows.Count]; for (int ii = 0; ii < table2.Rows.Count; ii++) { slotsTaken[ii] = DateTime.Parse(table2.Rows[ii][0].ToString()); } Array.Sort(slotsTaken); return slotsTaken; }
public DateTime[] getSlots(int advisor_Id, string date) { //inttime = total available time slots as int //doubletime = total available time slots as double SqlDataSource SqlDataSource = new SqlDataSource(); SqlDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource.SelectCommand = "Select DayStart,DayFinish From AdvisorSchedule Where Advisor_Id='" + advisor_Id + "'"; DataView view = (DataView)SqlDataSource.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); DateTime start = DateTime.Parse(table.Rows[0][0].ToString()); DateTime end = DateTime.Parse(table.Rows[0][1].ToString()); double dbltime = ((end - start).TotalHours) * 2; int inttime = Convert.ToInt32(dbltime); DateTime[] advisorSlots = new DateTime[inttime]; for (int i = 0; i < inttime; i++) { advisorSlots[i] = start; start = start.AddMinutes(30); } return advisorSlots; }
/* * This method provides the login functionality. * Checks if the username and password combination is valid. * Checks if the user is logging in for the first time. * Checks if the user has been locked out by the admininstrator * Checks if the user has been deleted by the administrator * Keeps track of unsuccessful attempts and locks the user out in case it exceeds counter */ protected void login_Click(object sender, EventArgs e) { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString; string pass = crypto.encryption_decryption.Encrypt(password.Text); sds.SelectParameters.Add("username", TypeCode.String, uname.Text); sds.SelectParameters.Add("password", TypeCode.String, pass); sds.SelectCommand = "SELECT * FROM [users] WHERE [username] = @username AND [password] = @password"; DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty); if (dv != null && dv.Count != 0) { user = dv[0].Row["username"].ToString(); int uid = Int32.Parse(dv[0].Row["userid"].ToString()); if ((dv[0].Row["IsDeleted"].ToString() == "0") && (dv[0].Row["IsLocked"].ToString() == "False") && (dv[0].Row["FirstTime"].ToString() == "False")) { Session["admin"] = dv[0].Row["admin"].ToString(); if (dv[0].Row["admin"].ToString() == "True") { lblmsg.Text = "Success"; this.Session["username"] = dv[0].Row["username"].ToString(); if (Session["username"] == null) { Console.WriteLine("??"); } Session["userid"] = dv[0].Row["userid"].ToString(); CreateLogEntry(Session["userid"].ToString()); Response.Redirect("~/Views/Page.aspx"); } else { lblmsg.Text = "Success"; this.Session["username"] = dv[0].Row["username"].ToString(); if (Session["username"] == null) { Console.WriteLine("??"); } Session["userid"] = dv[0].Row["userid"].ToString(); CreateLogEntry(Session["userid"].ToString()); Response.Redirect("~/Views/user.aspx"); } } else if (dv[0].Row["FirstTime"].ToString() == "True") { utility.utils.CreateLeaveEntry(uid); multiview.SetActiveView(view0); quef.Text = dv[0].Row["SecurityQuestion"].ToString(); } else if (dv[0].Row["IsLocked"].ToString() == "True") { lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Text = "You Have Been Locked Out"; } else { lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Text = "User No Longer Exists"; } } else { UpdateCounter(uname.Text); lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Text = "Invalid Username and Password Try again"; } }
public DataTable loadAdvisorsToGrid() { DateTime date = new DateTime(); date = DateTime.Now; SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select (Last_Name+', ' + First_Name) As Advisors,Dept_Name As Department,DaysAvailable As Avalability, (CONVERT(varchar, DayStart, 100)+ '-'+CONVERT(varchar, DayFinish, 100)) As Time, Advisor_Master.Advisor_Id As ID From AdvisorSchedule,Advisor_Master,Department_Master Where AdvisorSchedule.Advisor_Id=Advisor_Master.Advisor_Id AND Advisor_Master.Dept_Id=Department_Master.Dept_Id AND StartDate < '" + date.ToShortDateString() + "' AND FinishDate > '" + date.ToShortDateString() + "'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); return table; }
//Det der sker når siden indlæses protected void Page_Load(object sender, EventArgs e) { //Opretter en datasource som kan bruges under hele Page_Load SqlDataSource SqlDataSource1 = new SqlDataSource(); //Laver en SqlDataSource SqlDataSource1.ID = "SqlDataSource1"; //Giver den et ID this.Page.Controls.Add(SqlDataSource1); //Tilføjer den til siden SqlDataSource1.CancelSelectOnNullParameter = true; try { //Kigger om brugeren er logget ind if (HttpContext.Current.Session["Username"].ToString() != "") { //Forbinder til databasen for at kontrollere at brugernavnet eksisterer og kun findes en gang SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["memorialtagConnectionString"].ConnectionString; //Vores connection string som er defineret i web.config SqlDataSource1.SelectCommand = "SELECT COUNT(1) FROM LoginTabel WHERE Brugernavn= '" + HttpContext.Current.Session["Username"].ToString() + "' AND Adgangskode= '" + HttpContext.Current.Session["Password"].ToString() + "'"; //Vores SELECT statement DataView test = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); //Laver et test dataview til vores template int count = Convert.ToInt32(test.Table.Rows[0][0]); if (count == 1) { //Hiver brugernavnet fra vores sessions variabel og viser det som en overskrift string User = HttpContext.Current.Session["Username"].ToString(); HttpContext.Current.Session["Username"] = User; labUserOverskrift.Text = "Hej, " + User; //Vores forbindelse til SQL databasen SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["memorialtagConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = "SELECT [KundeTabel].[Fornavn], [KundeTabel].[Efternavn], [KundeTabel].[Telefon], [KundeTabel].[Mail], [LandNavn], [ByNavn], [KundeTabel].[Postnummer], [KundeTabel].[Vej], [KundeTabel].[KundeID], [TagTabel].[TagID], GravTabel.[GravID] FROM [KundeTabel] INNER JOIN LandTabel ON KundeTabel.LandID = LandTabel.LandID INNER JOIN ByTabel ON KundeTabel.Postnummer = ByTabel.Postnummer INNER JOIN TagTabel ON KundeTabel.KundeID = TagTabel.KundeID INNER JOIN GravTabel ON TagTabel.TagID = GravTabel.TagID WHERE [KundeTabel].[Mail] = '" + User + "'"; //Error handling med en try cath try { test = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); string TagID = test.Table.Rows[0]["TagID"].ToString(); string GravID = test.Table.Rows[0]["GravID"].ToString(); string KundeID = test.Table.Rows[0]["KundeID"].ToString(); if (test.Table.Rows[0]["Fornavn"].ToString() != null) { labFornavn.Text = test.Table.Rows[0]["Fornavn"].ToString(); } if (test.Table.Rows[0]["Efternavn"].ToString() != null) { labEfternavn.Text = test.Table.Rows[0]["Efternavn"].ToString(); } if (test.Table.Rows[0]["Telefon"].ToString() != null) { labTelefon.Text = test.Table.Rows[0]["Telefon"].ToString(); } if (test.Table.Rows[0]["Mail"].ToString() != null) { labEmail.Text = test.Table.Rows[0]["Mail"].ToString(); } if (test.Table.Rows[0]["LandNavn"].ToString() != null) { labLand.Text = test.Table.Rows[0]["LandNavn"].ToString(); } if (test.Table.Rows[0]["ByNavn"].ToString() != null) { labBy.Text = test.Table.Rows[0]["ByNavn"].ToString(); } if (test.Table.Rows[0]["Postnummer"].ToString() != null) { labPostnr.Text = test.Table.Rows[0]["Postnummer"].ToString(); } if (test.Table.Rows[0]["Vej"].ToString() != null) { labVej.Text = test.Table.Rows[0]["Vej"].ToString(); } if (test.Table.Rows[0]["KundeID"].ToString() != null) { kundeID.Text = "Kunde ID: " + test.Table.Rows[0]["KundeID"].ToString(); } //Ny SQL Select kommando på grav tabellen istedet for kunde tabellen SqlDataSource SqlDataSourceFrontPage = new SqlDataSource(); //Laver en SqlDataSource SqlDataSourceFrontPage.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["memorialtagConnectionString"].ConnectionString; //Vores connection string som er defineret i web.config SqlDataSourceFrontPage.ID = "SqlDataSourceFrontPage"; //Giver den et ID this.Page.Controls.Add(SqlDataSourceFrontPage); //Tilføjer den til siden SqlDataSourceFrontPage.SelectCommand = "SELECT [Fornavn], [Efternavn], [Fødselsdato], [Dødsdato], [GravTabel].[GravID] FROM[GravTabel] INNER JOIN TagTabel ON GravTabel.TagID = TagTabel.TagID WHERE KundeID = '" + KundeID + "'"; test = (DataView)SqlDataSourceFrontPage.Select(DataSourceSelectArguments.Empty); } catch { Response.Redirect("./Error.aspx"); } } } else { Response.Redirect("./Error.aspx"); } } catch { Response.Redirect("./Error.aspx"); } }
void exportFile() { ExcelPackage pck = new ExcelPackage(); string filename = string.Empty; filename = StoreName + " #" + StoreNumber + " - Week Ending " + Convert.ToDateTime(StartDate).AddDays(13).ToShortDateString().Replace("/", "-"); using (pck) { ExcelWorksheet ws = pck.Workbook.Worksheets.Add(filename); SqlDataSource SQL1 = new SqlDataSource(); SQL1.ID = "SqlDataSource1"; SQL1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; SQL1.SelectParameters.Add("webStartDate", StartDate); SQL1.SelectParameters.Add("webDuration", "14"); SQL1.SelectParameters.Add("webProgram", Program); SQL1.SelectParameters.Add("webStoreNumber", StoreNumber); SQL1.SelectParameters.Add("webStoreName", StoreName); SQL1.SelectParameters.Add("webLocation", Location); SQL1.SelectParameters.Add("webOwner", Owner); SQL1.SelectParameters.Add("UserType", userType); SQL1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SQL1.Selecting += SQLSelecting; SQL1.SelectCommand = "spx_PAYOUTQty"; SqlDataSource SQL2 = new SqlDataSource(); SQL2.ID = "SqlDataSource2"; SQL2.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; SQL2.SelectParameters.Add("webStartDate", StartDate); SQL2.SelectParameters.Add("webDuration", "14"); SQL2.SelectParameters.Add("webProgram", Program); SQL2.SelectParameters.Add("webStoreNumber", StoreNumber); SQL2.SelectParameters.Add("webStoreName", StoreName); SQL2.SelectParameters.Add("webLocation", Location); SQL2.SelectParameters.Add("webOwner", Owner); SQL2.SelectParameters.Add("UserType", userType); if (Program == "Chipio - Chip Repair") { SQL2.SelectParameters.Add("gross", "Chipio - Chip Repair"); } else { SQL2.SelectParameters.Add("gross", "All"); } SQL2.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SQL2.Selecting += SQLSelecting; SQL2.SelectCommand = "spx_PAYOUTRev"; DataSourceSelectArguments args1 = new DataSourceSelectArguments(); DataView DV1 = (DataView)SQL1.Select(args1); DataTable DT1 = DV1.ToTable(); DataSourceSelectArguments args2 = new DataSourceSelectArguments(); DataView DV2 = (DataView)SQL2.Select(args2); DataTable DT2 = DV2.ToTable(); int j1 = DV1.Table.Rows.Count + 12; int j2 = j1 + 1; ws.Cells["A1"].Value = "Store:"; ws.Cells["A1"].Style.Font.Bold = true; ws.Cells["B1"].Value = StoreName; ws.Cells["A2"].Value = "Program:"; ws.Cells["A2"].Style.Font.Bold = true; ws.Cells["B2"].Value = Program; ws.Cells["A3"].Value = "Owner:"; ws.Cells["A3"].Style.Font.Bold = true; ws.Cells["B3"].Value = Owner; ws.Cells["A4"].Value = "Hub:"; ws.Cells["A4"].Style.Font.Bold = true; ws.Cells["B4"].Value = Hub; ws.Cells["A5"].Value = "Whse #:"; ws.Cells["A5"].Style.Font.Bold = true; ws.Cells["B5"].Value = StoreNumber; ws.Cells["A6"].Value = "Location:"; ws.Cells["A6"].Style.Font.Bold = true; ws.Cells["B6"].Value = Location; ws.Cells["A9"].Value = "Quantity"; ws.Cells["A9"].Style.Font.Bold = true; ws.Cells["A10"].LoadFromDataTable(DT1, true); ws.Cells["A" + j1.ToString()].Value = "Revenue"; ws.Cells["A" + j1.ToString()].Style.Font.Bold = true; ws.Cells["A" + j2.ToString()].LoadFromDataTable(DT2, true); ws.Cells["A1:Z2000"].AutoFitColumns(); Page.Controls.Remove(SQL1); Page.Controls.Remove(SQL2); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment; filename=" + filename + ".xlsx"); Response.BinaryWrite(pck.GetAsByteArray()); Response.Flush(); Response.End(); } }
public List <BankCardData> getBankCard(string startSubmitDate, string endSubmitDate) { List <BankCardData> bankcardData = new List <BankCardData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); DataView allStudent = new DataView(); oracleObj.SelectCommand = "Select * From BANK_CARDSTUDENT,GRAD_STUDENT,GRAD_STUDENT_INFORMATION Where BANK_CARDSTUDENT.SUBMIT_DATE BETWEEN '" + startSubmitDate + "' And '" + endSubmitDate + "' And GRAD_STUDENT.student_id=bank_cardstudent.student_id AND GRAD_STUDENT_INFORMATION.student_id = GRAD_STUDENT.student_id Order By BANK_CARDSTUDENT.SUBMIT_DATE DESC"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { BankCardData bankcard_data = new BankCardData(); bankcard_data.StudentID = rowData["STUDENT_ID"].ToString(); bankcard_data.Student_ID = rowData["STUDENT_ID"].ToString(); bankcard_data.Degree_Admission = rowData["DEGREE_ADMISSION_CODE"].ToString(); bankcard_data.Faculty_Code = rowData["FACULTY_CODE"].ToString(); bankcard_data.DegreeAdmissionCode = rowData["DEGREE_ADMISSION_CODE"].ToString(); bankcard_data.DegreeChar = rowData["DEGREE_CHAR"].ToString(); bankcard_data.FacultyCode = rowData["FACULTY_CODE"].ToString(); bankcard_data.SubmitDate = rowData["SUBMIT_DATE"].ToString(); bankcard_data.BankStaffCode = rowData["BANK_STAFF_CODE"].ToString(); bankcard_data.Curri_Code = rowData["CURRI_CODE"].ToString(); bankcard_data.Study_Year = rowData["STUDY_YEAR"].ToString(); bankcard_data.Plan_Code = rowData["PLAN_CODE"].ToString(); bankcard_data.Project_Code = rowData["PROJECT_CODE"].ToString(); bankcard_data.Campus_Code = rowData["CAMPUS_CODE"].ToString(); bankcard_data.Learning_Cen_Code = rowData["LEARNING_CEN_CODE"].ToString(); //bankcard_data.Faculty_Code = rowData["FACULTY_CODE"].ToString(); bankcard_data.Department_Code = rowData["DEPARTMENT_CODE"].ToString(); bankcard_data.Major_Code = rowData["MAJOR_CODE"].ToString(); bankcard_data.Spec_Field_Code = rowData["SPEC_FIELD_CODE"].ToString(); //bankcard_data.Segment_Code = rowData["SEGMENT_CODE"].ToString(); //bankcard_data.Advisor_ID = rowData["ADVISOR_ID"].ToString(); //bankcard_data.Section_Code = rowData["SECTION_CODE"].ToString(); bankcard_data.Date_Admission = rowData["DATE_ADMISSION"].ToString(); bankcard_data.Semester_Admission = rowData["SEMESTER_ADMISSION"].ToString(); bankcard_data.Year_Admission = rowData["YEAR_ADMISSION"].ToString(); //bankcard_data.Degree_Admission = rowData["DEGREE_ADMISSION_CODE"].ToString(); bankcard_data.preDegree_Code = rowData["PRE_DEGREE_CODE"].ToString(); bankcard_data.preInstitution = rowData["PRE_INSTITUTION"].ToString(); bankcard_data.preAcademicYear = rowData["PRE_ACADEMICYEAR"].ToString(); bankcard_data.preGPA = float.Parse(rowData["PRE_GPA"].ToString()); bankcard_data.preQualification_Code = rowData["PRE_QUALIFICATION_CODE"].ToString(); bankcard_data.preMojor_Code = rowData["PRE_MOJOR_CODE"].ToString(); bankcard_data.Std_Category_Code = rowData["STD_CATEGORY_CODE"].ToString(); bankcard_data.Std_Photo = rowData["STD_PHOTO"].ToString(); bankcard_data.Maintaining_Fee = Convert.ToInt32(rowData["MAINTAINING_FEE"].ToString()); bankcard_data.Cooperative = rowData["COOPERATIVE_STATUS"].ToString(); bankcard_data.Study_Status = rowData["STUDY_STATUS"].ToString(); bankcard_data.Student_Status = rowData["STUDENT_STATUS"].ToString(); bankcard_data.Term_Of_Status = rowData["TERM_OF_STATUS"].ToString(); bankcard_data.Scholarship_Status = rowData["SCHOLARSHIP_STATUS"].ToString(); bankcard_data.Nation_ID = rowData["NATION_ID"].ToString(); bankcard_data.NationCard_Expire = rowData["NATIONCARD_EXPIRE"].ToString(); bankcard_data.Passport_ID = rowData["PASSPORT_ID"].ToString(); bankcard_data.PassportCard_Expire = rowData["PASSPORTCARD_EXPIRE"].ToString(); bankcard_data.Country_Code = rowData["COUNTRY_CODE"].ToString(); bankcard_data.Gender = rowData["GENDER"].ToString(); bankcard_data.Prefix_Code = rowData["PREFIX_CODE"].ToString(); bankcard_data.Title_ThaiName = rowData["TITLE_THAINAME"].ToString(); bankcard_data.First_ThaiName = rowData["FIRST_THAINAME"].ToString(); bankcard_data.Family_ThaiName = rowData["FAMILY_THAINAME"].ToString(); bankcard_data.Title_EngName = rowData["TITLE_ENGNAME"].ToString(); bankcard_data.First_EngName = rowData["FIRST_ENGNAME"].ToString(); bankcard_data.Family_EngName = rowData["FAMILY_ENGNAME"].ToString(); bankcard_data.DateOfBirth = rowData["DATE_OF_BIRTH"].ToString(); bankcard_data.Province_BirthTH = rowData["PROVINCE_BIRTH_TH"].ToString(); bankcard_data.Province_BirthOther = rowData["PROVINCE_BIRTH_OTHER"].ToString(); bankcard_data.Nationality_Code = rowData["NATIONALITY_CODE"].ToString(); bankcard_data.Ethnicity_Code = rowData["ETHNICITY_CODE"].ToString(); bankcard_data.Religion_Code = rowData["RELIGION_CODE"].ToString(); bankcard_data.Blood_Code = rowData["BLOOD_CODE"].ToString(); bankcard_data.Height = float.Parse(rowData["HEIGHT"].ToString()); bankcard_data.Weight = float.Parse(rowData["WEIGHT"].ToString()); bankcard_data.Marital_Code = rowData["MARITAL_CODE"].ToString(); bankcard_data.Militaly_Code = rowData["MILITARY_CODE"].ToString(); bankcard_data.Disability = rowData["DISABILITY"].ToString(); bankcard_data.Home_Phone = rowData["HOME_PHONE"].ToString(); bankcard_data.Mobile_Number = rowData["MOBILE_NUMBER"].ToString(); bankcard_data.Email = rowData["EMAIL"].ToString(); bankcard_data.Talent = rowData["TALENT"].ToString(); bankcard_data.Home_Number = rowData["HOME_NUMBER"].ToString(); bankcard_data.Home_Village = rowData["HOME_VILLAGE"].ToString(); bankcard_data.Home_Moo = Convert.ToInt32(rowData["HOME_MOO"].ToString()); bankcard_data.Home_Soi = rowData["HOME_SOI"].ToString(); bankcard_data.Home_Road = rowData["HOME_ROAD"].ToString(); bankcard_data.Home_Tumbol = rowData["HOME_TUMBOL"].ToString(); bankcard_data.Home_Amphur = rowData["HOME_AMPHUR"].ToString(); bankcard_data.Home_Province = rowData["HOME_PROVINCE"].ToString(); bankcard_data.Home_PostCode = rowData["HOME_POSTCODE"].ToString(); bankcard_data.Home_Country = rowData["HOME_COUNTRY"].ToString(); bankcard_data.Home_AddressExt = rowData["HOME_ADDRESS_EXT"].ToString(); bankcardData.Add(bankcard_data); } oracleObj.SelectCommand = "Select * From BANK_CARDSTUDENT,STUDENT,STUDENT_INFORMATION Where BANK_CARDSTUDENT.SUBMIT_DATE BETWEEN '" + startSubmitDate + "' And '" + endSubmitDate + "' And STUDENT.student_id=bank_cardstudent.student_id AND STUDENT_INFORMATION.student_id = STUDENT.student_id Order By BANK_CARDSTUDENT.SUBMIT_DATE DESC"; DataView allData2 = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData2) { BankCardData bankcard_data = new BankCardData(); bankcard_data.StudentID = rowData["STUDENT_ID"].ToString(); bankcard_data.Student_ID = rowData["STUDENT_ID"].ToString(); bankcard_data.Degree_Admission = rowData["DEGREE_ADMISSION_CODE"].ToString(); bankcard_data.Faculty_Code = rowData["FACULTY_CODE"].ToString(); bankcard_data.DegreeAdmissionCode = rowData["DEGREE_ADMISSION_CODE"].ToString(); bankcard_data.DegreeChar = rowData["DEGREE_CHAR"].ToString(); bankcard_data.FacultyCode = rowData["FACULTY_CODE"].ToString(); bankcard_data.SubmitDate = rowData["SUBMIT_DATE"].ToString(); bankcard_data.BankStaffCode = rowData["BANK_STAFF_CODE"].ToString(); bankcard_data.Curri_Code = rowData["CURRI_CODE"].ToString(); bankcard_data.Study_Year = rowData["STUDY_YEAR"].ToString(); bankcard_data.Plan_Code = rowData["PLAN_CODE"].ToString(); bankcard_data.Project_Code = rowData["PROJECT_CODE"].ToString(); bankcard_data.Campus_Code = rowData["CAMPUS_CODE"].ToString(); bankcard_data.Learning_Cen_Code = rowData["LEARNING_CEN_CODE"].ToString(); //bankcard_data.Faculty_Code = rowData["FACULTY_CODE"].ToString(); bankcard_data.Department_Code = rowData["DEPARTMENT_CODE"].ToString(); bankcard_data.Major_Code = rowData["MAJOR_CODE"].ToString(); bankcard_data.Spec_Field_Code = rowData["SPEC_FIELD_CODE"].ToString(); //bankcard_data.Segment_Code = rowData["SEGMENT_CODE"].ToString(); //bankcard_data.Advisor_ID = rowData["ADVISOR_ID"].ToString(); //bankcard_data.Section_Code = rowData["SECTION_CODE"].ToString(); bankcard_data.Date_Admission = rowData["DATE_ADMISSION"].ToString(); bankcard_data.Semester_Admission = rowData["SEMESTER_ADMISSION"].ToString(); bankcard_data.Year_Admission = rowData["YEAR_ADMISSION"].ToString(); //bankcard_data.Degree_Admission = rowData["DEGREE_ADMISSION_CODE"].ToString(); bankcard_data.preDegree_Code = rowData["PRE_DEGREE_CODE"].ToString(); bankcard_data.preInstitution = rowData["PRE_INSTITUTION"].ToString(); bankcard_data.preAcademicYear = rowData["PRE_ACADEMICYEAR"].ToString(); bankcard_data.preGPA = float.Parse(rowData["PRE_GPA"].ToString()); bankcard_data.preQualification_Code = rowData["PRE_QUALIFICATION_CODE"].ToString(); bankcard_data.preMojor_Code = rowData["PRE_MOJOR_CODE"].ToString(); bankcard_data.Std_Category_Code = rowData["STD_CATEGORY_CODE"].ToString(); bankcard_data.Std_Photo = rowData["STD_PHOTO"].ToString(); bankcard_data.Maintaining_Fee = Convert.ToInt32(rowData["MAINTAINING_FEE"].ToString()); bankcard_data.Cooperative = rowData["COOPERATIVE_STATUS"].ToString(); bankcard_data.Study_Status = rowData["STUDY_STATUS"].ToString(); bankcard_data.Student_Status = rowData["STUDENT_STATUS"].ToString(); bankcard_data.Term_Of_Status = rowData["TERM_OF_STATUS"].ToString(); bankcard_data.Scholarship_Status = rowData["SCHOLARSHIP_STATUS"].ToString(); bankcard_data.Nation_ID = rowData["NATION_ID"].ToString(); bankcard_data.NationCard_Expire = rowData["NATIONCARD_EXPIRE"].ToString(); bankcard_data.Passport_ID = rowData["PASSPORT_ID"].ToString(); bankcard_data.PassportCard_Expire = rowData["PASSPORTCARD_EXPIRE"].ToString(); bankcard_data.Country_Code = rowData["COUNTRY_CODE"].ToString(); bankcard_data.Gender = rowData["GENDER"].ToString(); bankcard_data.Prefix_Code = rowData["PREFIX_CODE"].ToString(); bankcard_data.Title_ThaiName = rowData["TITLE_THAINAME"].ToString(); bankcard_data.First_ThaiName = rowData["FIRST_THAINAME"].ToString(); bankcard_data.Family_ThaiName = rowData["FAMILY_THAINAME"].ToString(); bankcard_data.Title_EngName = rowData["TITLE_ENGNAME"].ToString(); bankcard_data.First_EngName = rowData["FIRST_ENGNAME"].ToString(); bankcard_data.Family_EngName = rowData["FAMILY_ENGNAME"].ToString(); bankcard_data.DateOfBirth = rowData["DATE_OF_BIRTH"].ToString(); bankcard_data.Province_BirthTH = rowData["PROVINCE_BIRTH_TH"].ToString(); bankcard_data.Province_BirthOther = rowData["PROVINCE_BIRTH_OTHER"].ToString(); bankcard_data.Nationality_Code = rowData["NATIONALITY_CODE"].ToString(); bankcard_data.Ethnicity_Code = rowData["ETHNICITY_CODE"].ToString(); bankcard_data.Religion_Code = rowData["RELIGION_CODE"].ToString(); bankcard_data.Blood_Code = rowData["BLOOD_CODE"].ToString(); bankcard_data.Height = float.Parse(rowData["HEIGHT"].ToString()); bankcard_data.Weight = float.Parse(rowData["WEIGHT"].ToString()); bankcard_data.Marital_Code = rowData["MARITAL_CODE"].ToString(); bankcard_data.Militaly_Code = rowData["MILITARY_CODE"].ToString(); bankcard_data.Disability = rowData["DISABILITY"].ToString(); bankcard_data.Home_Phone = rowData["HOME_PHONE"].ToString(); bankcard_data.Mobile_Number = rowData["MOBILE_NUMBER"].ToString(); bankcard_data.Email = rowData["EMAIL"].ToString(); bankcard_data.Talent = rowData["TALENT"].ToString(); bankcard_data.Home_Number = rowData["HOME_NUMBER"].ToString(); bankcard_data.Home_Village = rowData["HOME_VILLAGE"].ToString(); bankcard_data.Home_Moo = Convert.ToInt32(rowData["HOME_MOO"].ToString()); bankcard_data.Home_Soi = rowData["HOME_SOI"].ToString(); bankcard_data.Home_Road = rowData["HOME_ROAD"].ToString(); bankcard_data.Home_Tumbol = rowData["HOME_TUMBOL"].ToString(); bankcard_data.Home_Amphur = rowData["HOME_AMPHUR"].ToString(); bankcard_data.Home_Province = rowData["HOME_PROVINCE"].ToString(); bankcard_data.Home_PostCode = rowData["HOME_POSTCODE"].ToString(); bankcard_data.Home_Country = rowData["HOME_COUNTRY"].ToString(); bankcard_data.Home_AddressExt = rowData["HOME_ADDRESS_EXT"].ToString(); bankcardData.Add(bankcard_data); } return(bankcardData); }
protected void Button2_Click(object sender, EventArgs e) { if (Session["id"] == null) { ScriptManager.RegisterStartupScript(Button2, Button2.GetType(), "alert", "alert('Sorry you stay too long!')", true); Response.Redirect("home.aspx"); } else { string uid = Session["id"].ToString(); Session["id"] = uid; bool check_db = false; SqlDataSource sql_f = new SqlDataSource(); sql_f.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_f.SelectCommand = "select id from user_information_store"; sql_f.SelectCommand += " where uid='" + uid + "';"; sql_f.DataBind(); DataView ict_f = (DataView)sql_f.Select(DataSourceSelectArguments.Empty); if (ict_f.Count > 0) { check_db = true; } if (check_db) { string uisid = ict_f.Table.Rows[0]["id"].ToString(); string bank_name = bank_name_TextBox.Text.Replace("\'", "").Replace("\"", "").Replace("`", "").Trim(); string bank_name_detail = bank_name_detail_TextBox.Text.Replace("\'", "").Replace("\"", "").Replace("`", "").Trim(); string bank_number = bank_number_TextBox.Text.Replace("\'", "").Replace("\"", "").Replace("`", "").Trim(); string bank_person = bank_person_TextBox.Text.Replace("\'", "").Replace("\"", "").Replace("`", "").Trim(); int bank_type = 0, bank_type_detail = 0; bool check_type0_Image = false, check_type1_Image = false, check_type2_Image = false , check_bank_type = false, check_bank_type_detail = false, check_bank_name = false, check_bank_name_detail = false , check_bank_number = false, check_bank_person = false; if (type0_Image.ImageUrl.ToString() != "") { check_type0_Image = true; image_Label.Text = ""; } else { image_Label.Text = "This image not upload."; } if (type1_Image.ImageUrl.ToString() != "") { check_type1_Image = true; image_Label0.Text = ""; } else { image_Label0.Text = "This image not upload."; } if (type2_Image.ImageUrl.ToString() != "") { check_type2_Image = true; image_Label1.Text = ""; } else { image_Label1.Text = "This image not upload."; } //if (bank_type_RadioButtonList.SelectedIndex > -1) //{ // bank_type = bank_type_RadioButtonList.SelectedIndex; // check_bank_type = true; // bank_type_Label.Text = ""; //} //else //{ // bank_type_Label.Text = "Bank type no select."; //} //if (bank_type_detail_RadioButtonList.SelectedIndex > -1) //{ // bank_type_detail = bank_type_detail_RadioButtonList.SelectedIndex; // check_bank_type_detail = true; // bank_type_detail_Label.Text = ""; //} //else //{ // bank_type_detail_Label.Text = "Bank type detail no select."; //} //if (bank_name != "") //{ // check_bank_name = true; // bank_name_Label.Text = ""; //} //else //{ // bank_name_Label.Text = "Bank name have special word or not write."; //} //if (bank_name_detail != "") //{ // check_bank_name_detail = true; // bank_name_detail_Label.Text = ""; //} //else //{ // bank_name_detail_Label.Text = "Bank name detail have special word or not write."; //} //if (bank_number != "") //{ // try // { // int number = Convert.ToInt32(bank_number); // check_bank_number = true; // bank_number_Label.Text = ""; // } // catch (Exception ex) // { // bank_number_Label.Text = "Bank number is not number."; // return; // throw ex; // } //} //else //{ // bank_number_Label.Text = "Bank number have special word or not write."; //} //if (bank_person != "") //{ // check_bank_person = true; // bank_person_Label.Text = ""; //} //else //{ // bank_person_Label.Text = "Bank person have special word or not write."; //} //if (check_type0_Image && check_type1_Image && check_type2_Image && check_bank_person && // check_bank_number && check_bank_name_detail && check_bank_name && check_bank_type_detail && // check_bank_type) if (check_type0_Image && check_type1_Image && check_type2_Image) { //SqlDataSource sql_update = new SqlDataSource(); //sql_update.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; //sql_update.UpdateCommand = "update user_information_store"; //sql_update.UpdateCommand += " set bank_type='" + bank_type + "',bank_type_detail='" + bank_type_detail + "',bank_name='" + bank_name + "'"; //sql_update.UpdateCommand += ",bank_name_detail='" + bank_name_detail + "',bank_number='" + bank_number + "',bank_person='" + bank_person + "'"; //sql_update.UpdateCommand += " where id='" + uisid + "';"; //sql_update.Update(); sql_f = new SqlDataSource(); sql_f.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_f.SelectCommand = "select id from user_information_store_important_image"; sql_f.SelectCommand += " where uisid='" + uisid + "';"; sql_f.DataBind(); ict_f = (DataView)sql_f.Select(DataSourceSelectArguments.Empty); if (ict_f.Count == 0) { SqlDataSource sql_insert = new SqlDataSource(); sql_insert.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_insert.InsertCommand = "insert into user_information_store_important_image(uisid,type,filename)"; sql_insert.InsertCommand += " values('" + uisid + "','0','" + type0_Image.ImageUrl.ToString() + "');"; sql_insert.Insert(); sql_insert = new SqlDataSource(); sql_insert.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_insert.InsertCommand = "insert into user_information_store_important_image(uisid,type,filename)"; sql_insert.InsertCommand += " values('" + uisid + "','1','" + type1_Image.ImageUrl.ToString() + "');"; sql_insert.Insert(); sql_insert = new SqlDataSource(); sql_insert.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; sql_insert.InsertCommand = "insert into user_information_store_important_image(uisid,type,filename)"; sql_insert.InsertCommand += " values('" + uisid + "','2','" + type2_Image.ImageUrl.ToString() + "');"; sql_insert.Insert(); bank_name_TextBox.Text = ""; bank_name_detail_TextBox.Text = ""; bank_number_TextBox.Text = ""; bank_person_TextBox.Text = ""; type0_Image.ImageUrl = ""; type1_Image.ImageUrl = ""; type2_Image.ImageUrl = ""; bank_type_detail_RadioButtonList.SelectedIndex = -1; bank_type_RadioButtonList.SelectedIndex = -1; result_Label.Text = "Success registered."; Response.Redirect("registered_1_3.aspx"); } } else { result_Label.Text = "登録に失敗しました。"; } } else { result_Label.Text = "登録に失敗しました。"; } } }
public string getDepartment(int advisor_Id) { string department = "-"; SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select Dept_Name From Advisor,Department Where Advisor.Dept_Id=Department.Dept_Id AND Employee_ID='" + advisor_Id + "'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); if (table.Rows.Count > 0) { department = table.Rows[0][0].ToString(); } return department; }
protected void Register_Click(object sender, EventArgs e) { try { if (String.IsNullOrEmpty(email.Text) || String.IsNullOrEmpty(username.Text) || String.IsNullOrEmpty(password.Text) || String.IsNullOrEmpty(passwordConfirm.Text)) { return; } else if (password.Text == passwordConfirm.Text) { if (!(Regex.IsMatch(email.Text, @"^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@(([0-9a-zA-Z])+([-\w]*[0-9a-zA-Z])*\.)+[a-zA-Z]{2,9})$"))) //using Regex class to check if the input is an email { Label1.Text = "Your email format is not right, Please check again!"; } else if (!(Regex.IsMatch(Phone.Text, @"^[0-9]+"))) { Label1.Text = "Please enter a correct phone number!"; } else { String userName = Session["Username"].ToString(); SqlDataSource1.Update(); Server.Transfer("Default.aspx"); } } else Label1.Text = "Error, the password is not same!"; } catch (Exception ex) { if (String.IsNullOrEmpty(email.Text) || String.IsNullOrEmpty(username.Text) || String.IsNullOrEmpty(password.Text) || String.IsNullOrEmpty(passwordConfirm.Text)) { return; } else if (password.Text == passwordConfirm.Text) { string conString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\Yummy.mdf;Integrated Security=True"; string selectString = "SELECT * FROM tb_Userinfo WHERE Username='******'";//select string for search currency name correspond with the input SqlDataSource dsrc = new SqlDataSource(conString, selectString); DataView DV = (DataView)dsrc.Select(DataSourceSelectArguments.Empty); if (DV.Table.Rows.Count > 0) { Label1.Text = "This username has already existed! Please try a new one"; } else if (!(Regex.IsMatch(email.Text, @"^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@(([0-9a-zA-Z])+([-\w]*[0-9a-zA-Z])*\.)+[a-zA-Z]{2,9})$"))) //using Regex class to check if the input is an email { Label1.Text = "Your email format is not right, Please check again!"; } else if (!(Regex.IsMatch(Phone.Text, @"^[0-9]+"))) { Label1.Text = "Please enter a correct phone number!"; } else { String a = DropDownListSQ.SelectedValue; SqlDataSource1.Insert(); //int ID = (int) DV.Table.Rows[0][0]; //Console.Write(ID); Session["RegisterName"] = username.Text.Trim(); username.Text = String.Empty; email.Text = String.Empty; password.Text = String.Empty; passwordConfirm.Text = String.Empty; Label1.Text = "Hi, " + Call.Text.Trim() + "! Register Succeed! Please login"; Response.Redirect("~/WebSite2/Login.aspx"); } } else Label1.Text = "Error, the password is not same!"; } }
public string getName(int advisor_Id) { string advisorNames = "-"; SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlDataSource2.SelectCommand = "Select (Last_Name+', ' + First_Name) As Name From Advisor Where Employee_ID='" + advisor_Id + "'"; DataView view = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); DataTable table = view.ToTable(); if (table.Rows.Count > 0) { advisorNames = table.Rows[0][0].ToString(); } return advisorNames; }