protected void DetailsView_Route_has_Bus_ItemInserted(object sender, DetailsViewInsertedEventArgs e) { DropDownList BS = (DropDownList)DetailsView_Route_has_Bus.FindControl("DropDownList5"); SqlDataSource seat = new SqlDataSource(); seat.ConnectionString = ConfigurationManager.ConnectionStrings["BusTicketConnectionString1"].ToString(); String count_seat = get_seat_count(BS.SelectedValue).ToString(); String command = ""; String Route_has_Bus_ID = get_Route_has_Bus_ID_Last().ToString(); command = get_insert_command(count_seat, Route_has_Bus_ID); if (command != "") { String insertCommand = "INSERT INTO [Seat] " + " (Route_has_Bus_ID, Seat_Number, Seat_Name, Seat_Status) " + " VALUES " + command + ";"; seat.InsertCommand = insertCommand; seat.Insert(); } Response.Redirect(Request.RawUrl); }
private void excuteNonQuery(string sql) { SqlDataSource 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.InsertCommand = sql; x.Insert(); Response.Redirect("~/windowCompany/companyCheck.aspx"); }
protected void Page_Load(object sender, EventArgs e) { ArrayList al = (ArrayList)Session["AnswerList"]; if (al == null) { Response.Redirect("Exam.aspx"); } resultGrid.DataSource = al; resultGrid.DataBind(); // Save the results into the database. try { if (IsPostBack == false) { double questions = al.Count; double correct = 0.0; for (int i = 0; i < al.Count; i++) { Answer a = (Answer)al[i]; if (a.Result == Answer.ResultValue.Correct) correct++; } double score = (correct / questions) * 100; SqlDataSource userExamDataSource = new SqlDataSource(); userExamDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["OnlineExamConnectionString"].ToString(); userExamDataSource.InsertCommand = "INSERT INTO [StudentExam] ([ExamID], [DateTimeComplete], [Score], [Username]) VALUES (@ExamID, @DateTimeComplete, @Score, @Username)"; userExamDataSource.InsertParameters.Add("ExamID", Session["ExamID"].ToString()); userExamDataSource.InsertParameters.Add("DateTimeComplete", DateTime.Now.ToString()); userExamDataSource.InsertParameters.Add("Score", score.ToString()); userExamDataSource.InsertParameters.Add("Username", Session["Student"].ToString()); int rowsAffected = userExamDataSource.Insert(); } } catch(Exception){ errorLabel.Text ="There was a problem saving your quiz results into our database. Therefore, the results from this quiz will not be displayed on the list on the main menu."; } }
/// <summary> /// เพิ่มข้อมูลลงตาราง DIPLOMA /// </summary> /// <param name="dataInsert">Diploma Object</param> /// <returns>Success</returns> public string insertDiploma(Diploma dataInsert) { string response = ""; int sleepTime = 5000; string DiplomaCode = dataInsert.DiplomaCode; for (int i = 0; i < 10; i++) { if (getDiploma(DiplomaCode).DiplomaCode != null) { Thread.Sleep(sleepTime); DiplomaCode = new utility().getMaxID("DIPLOMACODE", "DIPLOMA"); sleepTime += 5000; } else { dataInsert.DiplomaCode = DiplomaCode; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into DIPLOMA (YEARVERSION, DIPLOMACODE, CURRCODE, DOMAINTHNAME, DOMAINENNAME, DOMAINTHSHORTNAME, DOMAINENSHORTNAME) values ('" + dataInsert.YearVersion + "','" + dataInsert.DiplomaCode + "','" + dataInsert.CurrCode + "','" + dataInsert.DomainThName + "','" + dataInsert.DomainEnName + "','" + dataInsert.DomainThShortName + "','" + dataInsert.DomainEnShortName + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertDiploma: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง PROCEEDING_DB /// </summary> /// <param name="dataInsert">EnglishDb Object</param> /// <returns>OK</returns> public string insertProceedingDb(ProceedingDbData dataInsert) { string response = ""; int sleepTime = 5000; string ProceedingDbId = dataInsert.ProceedingDbId; for (int i = 0; i < 10; i++) { if (getProceedingDb(ProceedingDbId).ProceedingDbId != null) { Thread.Sleep(sleepTime); ProceedingDbId = getMaxIdProceedingDb(); sleepTime += 5000; } else { dataInsert.ProceedingDbId = ProceedingDbId; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Insert into PROCEEDING_DB (PROCEEDING_DB_ID, PROCEEDING_DB_TITLE, PROCEEDING_DB_LEVEL) values ('" + dataInsert.ProceedingDbId + "','" + dataInsert.ProceedingDbTitle + "','" + dataInsert.ProceedingDbLevel + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertProceedingDb: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
protected void Page_Load(object sender, EventArgs e) { ArrayList al = (ArrayList)Session["AnswerList"]; GridView1.DataSource = al; GridView1.DataBind(); //save the result into DB if (IsPostBack == false) { //calculate score double questions = al.Count; double correct = 0.0; for (int i = 0; i < al.Count; i++) { Answer a = (Answer)al[i]; if (a.Result == Answer.ResultValue.Correct) { correct++; } } double score = (correct / questions) * 100; SqlDataSource test = new SqlDataSource(); // test.ConnectionString = ConfigurationManager.ConnectionStrings["Data Source=DESKTOP-V5N37D7;Initial Catalog=OnlineQuiz;Integrated Security=True"].ToString(); test.ConnectionString = @"Data Source=ASUS\SQLEXPRESS;Initial Catalog=OnlineQuiz;Integrated Security=True"; test.InsertCommand = "INSERT INTO [UserQuiz]([QuizID],[DateTimeCompleted],[CorrectAnswerCount],[UserName],[Score]) values(@QuizID,@DateTimeCompleted,@CorrectAnswerCount,@UserName,@Score)"; test.InsertParameters.Add("QuizID", Session["QuizID"].ToString()); test.InsertParameters.Add("DateTimeCompleted", DateTime.Now.ToString()); test.InsertParameters.Add("CorrectAnswerCount", "12"); test.InsertParameters.Add("UserName", User.Identity.Name); test.InsertParameters.Add("Score", score.ToString()); // test.Insert(); int rowsAffected = test.Insert(); if (rowsAffected == 0) { //now we have to notify that insertion did not work LabelError.Text = "there was a problem in saving the data. because of this problem this quiz's result will not be displayed in the main menu"; } } }
/// <summary> /// เพิ่มข้อมูลลงตาราง TQF2SEC4SUB1 /// </summary> /// <param name="dataInsert">TQF2Sec4Sub1 Object</param> /// <returns>Success</returns> public string insertTQF2Sec4Sub1(TQF2Sec4Sub1 dataInsert) { string response = ""; int sleepTime = 5000; string T2S4Sub1No = dataInsert.T2S4Sub1No; for (int i = 0; i < 10; i++) { if (getTQF2Sec4Sub1(T2S4Sub1No).T2S4Sub1No != null) { Thread.Sleep(sleepTime); T2S4Sub1No = new TQF.TQFUtility().getMaxID("T2S4SUB1NO", "TQF2SEC4SUB1"); sleepTime += 5000; } else { dataInsert.T2S4Sub1No = T2S4Sub1No; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into TQF2SEC4SUB1 (T2S4SUB1NO, CURRCODE, DOMAINTYPECODE, DETAILTYPE, DETAIL, YEARVERSION) values ('" + dataInsert.T2S4Sub1No + "','" + dataInsert.CurrCode + "','" + dataInsert.DomainTypeCode + "','" + dataInsert.DetailType + "','" + dataInsert.Detail + "','" + dataInsert.YearVersion + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertTQF2Sec4Sub1: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง STUDENT_ENGLISH_TEST /// </summary> /// <param name="dataInsert">StudentEnglishTest Object</param> /// <returns>OK</returns> public string insertStudentEnglishTest(StudentEnglishTestData dataInsert) { string response = ""; int sleepTime = 5000; string StudentEnglishTestId = dataInsert.StudentEnglishTestId; for (int i = 0; i < 10; i++) { if (getStudentEnglishTest(StudentEnglishTestId).StudentEnglishTestId != null) { Thread.Sleep(sleepTime); StudentEnglishTestId = getMaxIdStudentEnglishTest(); sleepTime += 5000; } else { dataInsert.StudentEnglishTestId = StudentEnglishTestId; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Insert into STUDENT_ENGLISH_TEST (STUDENT_ENGLISH_TEST_ID, STUDENT_ID, ENGLISH_DB_ID, STUDENT_ENGLISH_TEST_SCORE) values ('" + dataInsert.StudentEnglishTestId + "','" + dataInsert.StudentId + "','" + dataInsert.EnglishDbId + "','" + dataInsert.StudentEnglishTestScore + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertStudentEnglishTest: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง STUDENT_JOURNAL /// </summary> /// <param name="dataInsert">StudentEnglishTest Object</param> /// <returns>OK</returns> public string insertStudentJournal(StudentJournalData dataInsert) { string response = ""; int sleepTime = 5000; string StudentJournalId = dataInsert.StudentJournalId; for (int i = 0; i < 10; i++) { if (getStudentJournal(StudentJournalId).StudentJournalId != null) { Thread.Sleep(sleepTime); StudentJournalId = getMaxIdStudentJournal(); sleepTime += 5000; } else { dataInsert.StudentJournalId = StudentJournalId; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Insert into STUDENT_JOURNAL (STUDENT_JOURNAL_ID,STUDENT_ID,STUDENT_JOURNAL_TITLE,JOURNAL_NAME,JOURNAL_YEAR,JOURNAL_VOLUM,JOURNAL_LEVEL,PROCEEDING_DB_ID) values ('" + dataInsert.StudentJournalId + "','" + dataInsert.StudentId + "','" + dataInsert.StudentJournalTitle + "','" + dataInsert.JournalName + "','" + dataInsert.JournalYear + "','" + dataInsert.JournalVolum + "','" + dataInsert.JournalLevel + "','" + dataInsert.ProceedingDbId + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertStudentJournal: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง TQF1 /// </summary> /// <param name="dataInsert"></param> /// <returns></returns> public string insertTQF1(TQF1 dataInsert) { string response = ""; int sleepTime = 5000; string NumTQF1 = dataInsert.NumTQF1; for (int i = 0; i < 10; i++) { if (getTQF1(NumTQF1).NumTQF1 != null) { Thread.Sleep(sleepTime); NumTQF1 = new TQF.TQFUtility().getMaxID("NUMTQF1", "TQF1"); sleepTime += 5000; } else { dataInsert.NumTQF1 = NumTQF1; break; } } ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into TQF1 (NUMTQF1, YEAR, LEVELCODE, MAJORNAME, FILENAME) values ('" + dataInsert.NumTQF1 + "','" + dataInsert.Year + "','" + dataInsert.LevelCode + "','" + dataInsert.TQF1Major + "','" + dataInsert.FileName + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertTQF1: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
private void addAssessItemContentStyle(CContent content, int ID_Item) { try { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = connectionString; sds.InsertCommand = "dbo.addAssessItemContentStyle"; sds.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sds.InsertParameters.Add(new Parameter("ID_Item", DbType.Int32, ID_Item.ToString())); sds.InsertParameters.Add(new Parameter("Score", DbType.Int32, content.score.ToString())); sds.InsertParameters.Add(new Parameter("Content", DbType.String, content.content)); sds.Insert(); } catch (Exception ex) { message = ex.Message; } }
protected void btnOK_Click(object sender, EventArgs e) { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = @"Data Source=.;Initial Catalog=Guardian_Angel;Integrated Security=True"; sds.InsertCommand = getInsertSql(); sds.Insert(); lblMsg.Visible = true; lblMsg.Text = "新預約【" + tbxClinic.Text + "】資料新增成功!"; btnOK.Enabled = false; //跳出訊息告知新增成功 //Response.Write("<script language=javascript>alert('資料新增成功!將返回資料頁')</script>"); //Response.Redirect("GaCare.aspx"); }
public void InsertTest1() { SqlDataSource ds = CreateDataSource(); ds.SelectCommand = "SELECT * FROM Table1 WHERE UserName = ?"; ds.SelectParameters.Add(new Parameter("UserName", TypeCode.String, "newuser")); ds.InsertCommand = "INSERT INTO Table1 (UserId, UserName, Description) VALUES (?, ?, ?)"; ds.InsertParameters.Add(new Parameter("UserId", TypeCode.Int32, "15")); ds.InsertParameters.Add(new Parameter("UserName", TypeCode.String, "newuser")); ds.InsertParameters.Add(new Parameter("Description", TypeCode.String, "newuser")); int records = ds.Insert(); DataView dataView = (DataView)ds.Select(new DataSourceSelectArguments()); Assert.AreEqual(1, dataView.Count); Assert.AreEqual(1, records); }
}//(方法)刪除舊資料 private void saveNotice() { DateTime dt1 = DateTime.UtcNow; string dateTime = dt1.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss.f"); //string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.f"); initOid = Request.Form["dataOid"].ToString(); SqlDataSource sql = new SqlDataSource(); /*換資料庫的連結*/ sql.ConnectionString = @"Data Source=.;Initial Catalog=Guardian_Angel;Integrated Security=True;"; string strNotice = "insert into Accident" + "(A_style,A_date,A_status,O_id)values('3','" + dateTime + "','1','" + initOid + "')"; sql.InsertCommand = strNotice; sql.Insert(); }//(方法)儲存異常狀況記錄
/* Add the time when an employee starts working on a repair */ protected void UpdateMethod() { /* connect to the dataset */ SqlDataSource table = SqlDataSource1; /* Get ID of repair_details table */ string repairID = Request.QueryString["repairID"]; /* get current date and time */ string currentDate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); /* get employeeID */ string employeeID = employees.Select("empLogin = '******'")[0]["ID"].ToString(); /* make a sql command to update start time where ID=ID */ string query = "INSERT INTO repair_progress(employeeID, repairID, startDate) VALUES(" + employeeID.ToString() + ", " + repairID.ToString() + ", '" + currentDate.ToString() + "');"; /* send sql command to database */ table.InsertCommand = query; table.Insert(); /* refresh page */ }
protected void Button1_Click(object sender, EventArgs e) { var NewItem = new SqlDataSource(); NewItem.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; NewItem.InsertCommandType = SqlDataSourceCommandType.Text; NewItem.InsertCommand = "INSERT INTO Rooms_To_Rent VALUES (@Room_Name, @Image, @Image2, @Image3, @Description, @Price, @Seller, @Status, @where)"; NewItem.InsertParameters.Add("Room_Name", TextBox1.Text.ToString()); NewItem.InsertParameters.Add("Image", TextBox2.Text.ToString()); NewItem.InsertParameters.Add("Image2", TextBox3.Text.ToString()); NewItem.InsertParameters.Add("Image3", TextBox4.Text.ToString()); NewItem.InsertParameters.Add("Description", TextBox5.Text.ToString()); NewItem.InsertParameters.Add("Price", TextBox6.Text.ToString()); NewItem.InsertParameters.Add("Seller", TextBox7.Text.ToString()); NewItem.InsertParameters.Add("Status", TextBox8.Text.ToString()); NewItem.InsertParameters.Add("where", TextBox9.Text.ToString()); NewItem.Insert(); }
/// <summary> /// Table OTHER_AUTHORIZED_SYSTEM /// </summary> /// <param name="dataInsert"></param> /// <returns></returns> public string insertOtherAuthorizedSystem(UserAuthorizedSystemData dataInsert) { string response = ""; UserLoginData loginData = new UserLoginData(); loginData = (UserLoginData)HttpContext.Current.Session["login_data"]; LogData log_data = new LogData(); log_data.ModuleCode = new LogData().Module_Setting; log_data.Username = loginData.User_ID; log_data.Message = "Insert OtherAuthorizedSystem with: " + dataInsert.Other_Users_Group_Id + ", " + dataInsert.Other_User_Id + ", " + dataInsert.Other_Authorized_Code; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into OTHER_AUTHORIZED_SYSTEM (USERS_GROUP_ID, USER_ID, OTHER_AUTHORIZED_CODE) Values ('" + dataInsert.Other_Users_Group_Id + "','" + dataInsert.Other_User_Id + "','" + dataInsert.Other_Authorized_Code + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; log_data.StatusCode = log_data.LogStatus_SUCCESS; } else { log_data.StatusCode = log_data.LogStatus_FAILED; } } catch (Exception e) { response = e.Message.ToString() + " "; log_data.StatusCode = log_data.LogStatus_ERROR; log_data.Message += " [" + e.ToString() + "]"; } new Log().WriteLog(log_data); return(response); }
public string insertEScholarshipLoan(ScholarshipEstduentLoan dataInsert) { string response = ""; UserLoginData loginData = new UserLoginData(); loginData = (UserLoginData)HttpContext.Current.Session["login_data"]; LogData log_data = new LogData(); log_data.ModuleCode = new LogData().Module_Scholarship; log_data.Username = loginData.User_ID; log_data.Message = "Insert ScholarshipEstduentLoan with: " + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDENT_ID + ", " + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_SCHOLARSHIP_CODE; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into SCHOLARSHIP_ESTUDENT_LOAN(STUDENT_ID, NATION_ID, CONTRACT_NUMBER, CONFIRMATION_NUMBER, DATE_APPROVE, LOAN_STUDY, LOAN_ETC, LOAN_LIVE, LOAN_TOTAL, SCHOLARSHIP_CODE, STUDY_YEAR, ACADEMIC_YEAR, SEMESTER) Values('" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDENT_ID + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_NATION_ID + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_CONTRACT_NUMBER + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_CONFIRMATION_NUMBER + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_DATE_APPROVE + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_STUDY + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_ETC + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_LIVE + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_TOTAL + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_SCHOLARSHIP_CODE + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDY_YEAR + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_ACADEMIC_YEAR + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_SEMESTER + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; log_data.StatusCode = log_data.LogStatus_SUCCESS; } else { log_data.StatusCode = log_data.LogStatus_FAILED; } } catch (Exception e) { response = e.Message.ToString() + " "; log_data.StatusCode = log_data.LogStatus_ERROR; log_data.Message += " [" + e.ToString() + "]"; } new Log().WriteLog(log_data); return(response); }
/// <summary> /// Table USERS_FACULTY_AUTHORIZED /// </summary> /// <param name="dataInsert"></param> /// <returns></returns> public string insertFacultyAuthorized(UserAuthorizedData dataInsert) { string response = ""; UserLoginData loginData = new UserLoginData(); loginData = (UserLoginData)HttpContext.Current.Session["login_data"]; LogData log_data = new LogData(); log_data.ModuleCode = new LogData().Module_Setting; log_data.Username = loginData.User_ID; log_data.Message = "Insert FacultyAuthorized with: " + dataInsert.Faculty_Authorized_User_Id + ", " + dataInsert.Faculty_Authorized_Faculty_Code + ", " + dataInsert.Faculty_Authorized_Allow_Status; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into USERS_FACULTY_AUTHORIZED (USER_ID, FACULTY_CODE, ALLOW_STATUS) Values ('" + dataInsert.Faculty_Authorized_User_Id + "','" + dataInsert.Faculty_Authorized_Faculty_Code + "','" + dataInsert.Faculty_Authorized_Allow_Status + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; log_data.StatusCode = log_data.LogStatus_SUCCESS; } else { log_data.StatusCode = log_data.LogStatus_FAILED; } } catch (Exception e) { response = e.Message.ToString() + " "; log_data.StatusCode = log_data.LogStatus_ERROR; log_data.Message += " [" + e.ToString() + "]"; } new Log().WriteLog(log_data); return(response); }
// V 1.0.0 public string[] updateAvailableStudent(List <AvailableStudentData> available_student, AvailableStudentData old_available_student, string degree_char) { string TableName = getTableName(degree_char); string[] response = new string[available_student.Count]; int i = 0; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); if (deleteAvailableStudent(old_available_student, degree_char) == "OK") { foreach (AvailableStudentData data in available_student) { string sql = "Insert Into " + TableName + "(ACADEMIC_YEAR,SEMESTER,COURSE_CODE,SEC_NO,COURSE_TYPE,CURR_CODE,STD_CATEGORY_CODE,STD_GROUP_CODE,SECTION_CODE,STUDENT_YEAR,SUBSEC_NO,FACULTY_CODE) Values('" + data.AcademicYear + "','" + data.Semester + "','" + data.Course_Code + "'," + data.Sec_No + ",'" + data.Course_Type + "','" + data.Curr_Code + "','" + data.Student_Category_Code + "','" + data.Student_Group_Code + "','" + data.Section_Code + "'," + data.Student_Year + "," + data.SubSec_No + ",'" + data.Faculty_Code + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response[i] = "OK"; } } catch (Exception e) { response[i] = e.Message.ToString() + " "; } i++; } } else { for (int j = 0; j < response.Length; j++) { response[j] = "Can't Update"; } } return(response); }
public string insertUsers(UsersInfo dataInsert) { string response = ""; UserLoginData loginData = new UserLoginData(); loginData = (UserLoginData)HttpContext.Current.Session["login_data"]; LogData log_data = new LogData(); log_data.ModuleCode = new LogData().Module_Setting; log_data.Username = loginData.User_ID; log_data.Message = "Insert UsersInfo with: " + dataInsert.USERS_INFO_USER_ID; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into USERS_INFO(USER_ID, NATIONAL_ID, OFFICIAL_ID, TITLE_THAINAME, FIRST_THAINAME, FAMILY_THAINAME, TITLE_ENGNAME, FIRST_ENGNAME, FAMILY_ENGNAME, FACULTY_ID, DEPARTMENT_ID, INTERNAL_PHONE, EXTERNAL_PHONE, OTHEROFFICE_CODE, STATUS, PASSWORD) Values('" + dataInsert.USERS_INFO_USER_ID + "','" + dataInsert.USERS_INFO_NATIONAL_ID + "','" + dataInsert.USERS_INFO_OFFICIAL_ID + "','" + dataInsert.USERS_INFO_TITLE_THAINAME + "','" + dataInsert.USERS_INFO_FIRST_THAINAME + "','" + dataInsert.USERS_INFO_FAMILY_THAINAME + "','" + dataInsert.USERS_INFO_TITLE_ENGNAME + "','" + dataInsert.USERS_INFO_FIRST_ENGNAME + "','" + dataInsert.USERS_INFO_FAMILY_ENGNAME + "','" + dataInsert.USERS_INFO_FACULTY_ID + "','" + dataInsert.USERS_INFO_DEPARTMENT_ID + "','" + dataInsert.USERS_INFO_INTERNAL_PHONE + "','" + dataInsert.USERS_INFO_EXTERNAL_PHONE + "','" + dataInsert.OTHEROFFICE_CODE + "','" + dataInsert.STATUS + "','" + dataInsert.PASSWORD + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; log_data.StatusCode = log_data.LogStatus_SUCCESS; } else { log_data.StatusCode = log_data.LogStatus_FAILED; } } catch (Exception e) { response = e.Message.ToString() + " "; log_data.StatusCode = log_data.LogStatus_ERROR; log_data.Message += " [" + e.ToString() + "]"; } new Log().WriteLog(log_data); return(response); }
public string insertScholarshipType(ScholarshipTypeData dataInsert) { string response = ""; UserLoginData loginData = new UserLoginData(); loginData = (UserLoginData)HttpContext.Current.Session["login_data"]; LogData log_data = new LogData(); log_data.ModuleCode = new LogData().Module_Scholarship; log_data.Username = loginData.User_ID; log_data.Message = "Insert ScholarshipType with: " + dataInsert.Type_Code; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into SCHOLARSHIP_TYPE(TYPE_CODE,TYPE_THAINAME,TYPE_ENGNAME,TYPE_CATALOG) Values('" + dataInsert.Type_Code + "','" + dataInsert.Type_Thai + "','" + dataInsert.Type_Eng + "','" + dataInsert.Type_Catalog + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; log_data.StatusCode = log_data.LogStatus_SUCCESS; } else { log_data.StatusCode = log_data.LogStatus_FAILED; } } catch (Exception e) { response = e.Message.ToString() + " "; log_data.StatusCode = log_data.LogStatus_ERROR; log_data.Message += " [" + e.ToString() + "]"; } new Log().WriteLog(log_data); return(response); }
public string insertScholarship(Scholarship dataInsert) { string response = ""; UserLoginData loginData = new UserLoginData(); loginData = (UserLoginData)HttpContext.Current.Session["login_data"]; LogData log_data = new LogData(); log_data.ModuleCode = new LogData().Module_Scholarship; log_data.Username = loginData.User_ID; log_data.Message = "Insert Scholarship with: " + dataInsert.SCHOLARSHIP_SCHOLARSHIP_CODE; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Insert Into SCHOLARSHIP(ACADEMIC_YEAR, SEMESTER, SCHOLARSHIP_CODE, SCHOLARSHIP_THAINAME, SCHOLARSHIP_ENGNAME, SCHOLARSHIP_IN_OUT, SCHOLARSHIP_TYPE, SCHOLARSHIP_SOURCE, NEW_REGIS_FEE, PROPERTIES_FEE, STUDY_FACILITY_FEE, IT_FEE, LIBRARY_FEE, HEALTH_FEE, ACTIVITY_FEE, CREDIT_3000, ACCIDENT_FEE, ACADEMIC_FEE_BACHELOR, SPECIAL_PROJECT_FEE, SCHOLAR_FEE_COMMENT, MULTIPLE_SCHOLARSHIP, ACADEMIC_FEE_MASTER, FINE_FEE, THEORY_PRACTICE_FEE, THESIS_FEE, SCHOLARSHIP_STATUS) Values('" + dataInsert.SCHOLARSHIP_ACADEMIC_YEAR + "','" + dataInsert.SCHOLARSHIP_SEMESTER + "','" + dataInsert.SCHOLARSHIP_SCHOLARSHIP_CODE + "','" + dataInsert.SCHOLARSHIP_SCHOLARSHIP_THAINAME + "','" + dataInsert.SCHOLARSHIP_SCHOLARSHIP_ENGNAME + "','" + dataInsert.SCHOLARSHIP_SCHOLARSHIP_IN_OUT + "','" + dataInsert.SCHOLARSHIP_SCHOLARSHIP_TYPE + "','" + dataInsert.SCHOLARSHIP_SCHOLARSHIP_SOURCE + "','" + dataInsert.SCHOLARSHIP_NEW_REGIS_FEE + "','" + dataInsert.SCHOLARSHIP_PROPERTIES_FEE + "','" + dataInsert.SCHOLARSHIP_STUDY_FACILITY_FEE + "','" + dataInsert.SCHOLARSHIP_IT_FEE + "','" + dataInsert.SCHOLARSHIP_LIBRARY_FEE + "','" + dataInsert.SCHOLARSHIP_HEALTH_FEE + "','" + dataInsert.SCHOLARSHIP_ACTIVITY_FEE + "','" + dataInsert.SCHOLARSHIP_CREDIT_3000 + "','" + dataInsert.SCHOLARSHIP_ACCIDENT_FEE + "','" + dataInsert.SCHOLARSHIP_ACADEMIC_FEE_BACHELOR + "','" + dataInsert.SCHOLARSHIP_SPECIAL_PROJECT_FEE + "','" + dataInsert.SCHOLARSHIP_SCHOLAR_FEE_COMMENT + "','" + dataInsert.SCHOLARSHIP_MULTIPLE_SCHOLARSHIP + "','" + dataInsert.SCHOLARSHIP_ACADEMIC_FEE_MASTER + "','" + dataInsert.SCHOLARSHIP_FINE_FEE + "','" + dataInsert.SCHOLARSHIP_THEORY_PRACTICE_FEE + "','" + dataInsert.SCHOLARSHIP_THESIS_FEE + "','" + dataInsert.SCHOLARSHIP_SCHOLARSHIP_STATUS + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; log_data.StatusCode = log_data.LogStatus_SUCCESS; } else { log_data.StatusCode = log_data.LogStatus_FAILED; } } catch (Exception e) { response = e.Message.ToString() + " "; log_data.StatusCode = log_data.LogStatus_ERROR; log_data.Message += " [" + e.ToString() + "]"; } new Log().WriteLog(log_data); return(response); }
/// <summary> /// เพิ่มข้อมูลลงตาราง DIVISIONEXTENSION /// </summary> /// <param name="dataInsert">DivisionExtension Object</param> /// <returns>Success</returns> public string insertDivisionExtension(DivisionExtension dataInsert) { string response = ""; //int sleepTime = 5000; //string DivisionNo = dataInsert.DivisionNo; //for (int i = 0; i < 10; i++) //{ // if (getDivisionExtension(DivisionNo).DivisionNo != null) // { // Thread.Sleep(sleepTime); // DivisionNo = new utility().getMaxID("DIVISIONNO", "DIVISIONEXTENSION"); // sleepTime += 5000; // } // else // { // dataInsert.DivisionNo = DivisionNo; // break; // } //} ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into DIVISIONEXTENSION (CURRCODE, YEARVERSION, DIVISIONNO, DIVISIONCODE) values ('" + dataInsert.CurrCode + "','" + dataInsert.YearVersion + "','" + dataInsert.DivisionNo + "','" + dataInsert.DivisionCode + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertDivisionExtension: " + exception; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public void chendulieunguoidung() { SqlDataSource sqldata = new SqlDataSource(); KetNoi chuoiketnoi = new KetNoi(); sqldata.ConnectionString = chuoiketnoi.ConnectionString(); sqldata.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.InsertCommand = "NguoiDung_Insert"; sqldata.InsertParameters.Add("HoTen", Nguoidung.Hoten.ToString()); sqldata.InsertParameters.Add("TenDangNhap", Nguoidung.Tendangnhap.ToString()); sqldata.InsertParameters.Add("DiaChi", Nguoidung.Diachi.ToString()); sqldata.InsertParameters.Add("MaDienThoai", Nguoidung.Madienthoai.ToString()); sqldata.InsertParameters.Add("SoDienThoai", Nguoidung.Sodienthoai.ToString()); sqldata.InsertParameters.Add("SoFax", Nguoidung.Sofax.ToString()); sqldata.InsertParameters.Add("Email", Nguoidung.Email.ToString()); sqldata.InsertParameters.Add("IDKieuNguoiDung", Nguoidung.Idkieunguoidung.ToString()); sqldata.InsertParameters.Add("MatKhau", Nguoidung.Matkhau.ToString()); sqldata.Insert(); }
/// <summary>新增身分角色到資料庫</summary> public void addRole(CRole role) { try { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = connectionString; sds.InsertCommand = "dbo.addRole"; sds.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sds.InsertParameters.Add(new Parameter("ID_Role", DbType.String, role.id)); sds.InsertParameters.Add(new Parameter("RoleName", DbType.String, role.name)); sds.Insert(); message = "add success"; } catch (Exception ex) { message = ex.Message; } }
// event handler to insert the book protected void bookInsertButton_Click(object sender, ImageClickEventArgs e) { try { SqlDataSource.InsertParameters["BookCode"].DefaultValue = bookCodeTextBox.Text; SqlDataSource.InsertParameters["PublisherCode"].DefaultValue = publisherCodeTextBox.Text; SqlDataSource.InsertParameters["Type"].DefaultValue = bookTypeTextBox.Text; SqlDataSource.InsertParameters["Title"].DefaultValue = bookTitleTextBox.Text; SqlDataSource.InsertParameters["Price"].DefaultValue = bookPriceTextBox.Text; SqlDataSource.Insert(); status.ForeColor = System.Drawing.Color.Green; status.Text = "[Input Good!]"; Response.Redirect("BookTable.aspx"); } catch { status.ForeColor = System.Drawing.Color.Red; status.Text = "[Exception caught, check input!]"; } }
//新增用藥時間送出 protected void btnSendTime_Click(object sender, EventArgs e) { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = @"Data Source=.;Initial Catalog=Guardian_Angel;Integrated Security=True;"; String hourSet = DropDownList1.SelectedItem.ToString(); String minuteSet = DropDownList2.SelectedItem.ToString(); sds.InsertCommand = "insert [dbo].[Time] ([N_id],[T_hour],[T_minute]) values (" + nid + "," + hourSet + "," + minuteSet + ")"; sds.Insert(); DropDownList1.Visible = false; DropDownList2.Visible = false; lblHour.Visible = false; lblMinute.Visible = false; btnAddTime.Enabled = true; btnSendTime.Visible = false; lblHour.Visible = false; lblMinute.Visible = false; Response.Redirect("OldMedicine_ViewAndUpdate.aspx"); }
}//(方法)新增資料進RS資料表 //修改資料相關 private void UpdateEC() { initEidint = Convert.ToInt32(Session["Eid"].ToString()); //修改sql字串 string sqlUpdateEC = "update Emergency_Contact set " + "E_name='" + tbName.Text + "', E_phone='" + tbPhone.Text + "',E_email='" + tbEmail.Text + "' where E_id = " + initEidint; SqlDataSource sql = new SqlDataSource(); //選擇連結的資料庫 sql.ConnectionString = @"Data Source=.;Initial Catalog=Guardian_Angel;Integrated Security=True;"; //要輸入的sql指令(修改資料) sql.InsertCommand = sqlUpdateEC; //執行輸入 sql.Insert(); }//(方法)修改資料進EC資料表
}//(方法)從EC資料表檢索資料 //新增資料相關 private void InsertEC() { int priorityInt = Convert.ToInt32(Session["newPriority"].ToString()); //sql指令 資料存入Emergency_contact資料庫的指令碼 string sqlInsertEC = "insert into Emergency_Contact" + "(E_name,E_phone,E_email,priority)values('" + tbName.Text + "', '" + tbPhone.Text + "', '" + tbEmail.Text + "', '" + priorityInt + "')"; SqlDataSource sql = new SqlDataSource(); //選擇連結的資料庫 sql.ConnectionString = @"Data Source=.;Initial Catalog=Guardian_Angel;Integrated Security=True;"; //要輸入的sql指令(存入名字電話信箱,之後查詢Eid) sql.InsertCommand = sqlInsertEC; //執行輸入 sql.Insert(); }//(方法)新增資料進EC資料表
protected void Button10_Click(object sender, EventArgs e) { SqlDataSource P1_SqlDataSource_Save = (SqlDataSource)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("P1_SqlDataSource_Save"); P1_SqlDataSource_Save.Insert(); HiddenField HiddenField_Visited_StafEmpId0 = (HiddenField)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("HiddenField_Visited_StafEmpId0"); HiddenField HiddenField_Vehicle_Requisition_Id0 = (HiddenField)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("HiddenField_Vehicle_Requisition_Id0"); GridView GridView9 = (GridView)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("GridView9"); SqlDataSource SqlDataSource2 = (SqlDataSource)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("SqlDataSource2"); for (int i = 0; i < GridView9.Rows.Count; i++) { HiddenField HiddenField_Visited_StafEmpId = (HiddenField)GridView9.Rows[i].FindControl("HiddenField_Visited_StafEmpId"); HiddenField HiddenField_Vehicle_Requisition_Id = (HiddenField)GridView9.Rows[i].FindControl("HiddenField_Vehicle_Requisition_Id"); CheckBox CheckBox1 = (CheckBox)GridView9.Rows[i].FindControl("CheckBox1"); if (CheckBox1.Checked) { HiddenField_Visited_StafEmpId0.Value = HiddenField_Visited_StafEmpId.Value; HiddenField_Vehicle_Requisition_Id0.Value = HiddenField_Vehicle_Requisition_Id.Value; SqlDataSource2.Insert(); } } GridView GridView8 = (GridView)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("GridView8"); HiddenField HiddenField_VFType_Id0 = (HiddenField)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("HiddenField_VFType_Id0"); HiddenField HiddenField_VF_Current = (HiddenField)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("HiddenField_VF_Current"); SqlDataSource P1A_SqlDataSource_CurrentFuel = (SqlDataSource)P1_GridViewAllreadyReservedV.Rows[Convert.ToInt32(P1_HiddenField_SelectedRow.Value)].FindControl("P1A_SqlDataSource_CurrentFuel"); for (int j = 0; j < GridView8.Rows.Count; j++) { HiddenField HiddenField_VFType_Id = (HiddenField)GridView8.Rows[j].FindControl("HiddenField_VFType_Id"); TextBox TextBox1 = (TextBox)GridView8.Rows[j].FindControl("TextBox1"); HiddenField_VFType_Id0.Value = HiddenField_VFType_Id.Value; HiddenField_VF_Current.Value = TextBox1.Text; P1A_SqlDataSource_CurrentFuel.Insert(); } P1_GridViewAllreadyReservedV.DataBind(); }
/// <summary>新增使用者到資料庫</summary> public void addUser(CUser user) { try { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = connectionString; sds.InsertCommand = "dbo.addUser"; sds.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sds.InsertParameters.Add(new Parameter("UserName", DbType.String, user.name)); sds.InsertParameters.Add(new Parameter("ID_Role", DbType.String, user.role_id)); sds.InsertParameters.Add(new Parameter("UserAccount", DbType.String, user.account)); sds.InsertParameters.Add(new Parameter("UserPassword", DbType.String, user.password)); sds.Insert(); message = "add success"; } catch (Exception ex) { message = ex.Message; } }
/// <summary>新增住民到資料庫</summary> public void addPatient(CPatient patient) { try { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = connectionString; sds.InsertCommand = "dbo.addPatient"; sds.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sds.InsertParameters.Add(new Parameter("PatientName", DbType.String, patient.name)); sds.InsertParameters.Add(new Parameter("PatientIDCard", DbType.String, patient.idcard)); sds.InsertParameters.Add(new Parameter("PatientBirthday", DbType.Date, patient.birthday.ToShortDateString())); sds.InsertParameters.Add(new Parameter("PatientPhotoPath", DbType.String, patient.photoPath)); sds.Insert(); message = "add success"; } catch (Exception ex) { message = ex.Message; } }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.InsertParameters.Add("Order_date", TextBox1.Text); SqlDataSource1.InsertParameters.Add("Assign_numbers", TextBox2.Text); SqlDataSource1.InsertParameters.Add("Account_numbers", DropDownList1.Text); SqlDataSource1.InsertParameters.Add("Account_abstract", TextBox3.Text); SqlDataSource1.InsertParameters.Add("Income", TextBox4.Text); SqlDataSource1.InsertParameters.Add("Spend", TextBox5.Text); SqlDataSource1.InsertCommand = "Insert into Account_Order_M(Order_date,Assign_numbers,Account_numbers,Account_abstract,Income,Spend) values(@Order_date,@Assign_numbers,@Account_numbers,@Account_abstract,@Income,@Spend)"; int affraw = SqlDataSource1.Insert(); if (affraw == 0) { Label1.Text = "Error"; } else { Label1.Text = "OK"; Button1.Visible = false; } SqlDataSource1.Dispose(); }
protected void DetailsView_Route_has_Bus_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { String Route_has_Bus_ID = DetailsView_Route_has_Bus.SelectedValue.ToString(); DropDownList D_Bus_ID_NEW = (DropDownList)DetailsView_Route_has_Bus.FindControl("DropDownList3"); DropDownList D_Bus_ID_OLD = (DropDownList)DetailsView_Route_has_Bus.FindControl("DropDownList7"); String Bus_ID_NEW = D_Bus_ID_NEW.SelectedValue; String Bus_ID_OLD = D_Bus_ID_OLD.SelectedValue; if (Bus_ID_NEW != Bus_ID_OLD) { delete_seat(Route_has_Bus_ID); SqlDataSource seat = new SqlDataSource(); seat.ConnectionString = ConfigurationManager.ConnectionStrings["BusTicketConnectionString1"].ToString(); String count_seat = get_seat_count(Bus_ID_NEW).ToString(); String command = ""; command = get_insert_command(count_seat, Route_has_Bus_ID); if (command != "") { String insertCommand = "INSERT INTO [Seat] " + " (Route_has_Bus_ID, Seat_Number, Seat_Name, Seat_Status) " + " VALUES " + command + ";"; seat.InsertCommand = insertCommand; seat.Insert(); } } }
protected void Button_Submit_Click(object sender, EventArgs e) { String Route1 = Request.QueryString["Route1"]; String Route2 = Request.QueryString["Route2"]; String Seat_Q_R1 = Request.QueryString["S_R1"]; String Seat_Q_R2 = Request.QueryString["S_R2"]; String R1 = ""; String R2 = ""; String[] Seat_R1 = { }; String[] Seat_R2 = { }; if (Seat_Q_R1 != null) { if (Seat_Q_R1.ToString() != "") { Seat_R1 = Seat_Q_R1.Split('_'); } } if (Seat_Q_R2 != null) { if (Seat_Q_R2.ToString() != "") { Seat_R2 = Seat_Q_R2.Split('_'); } } if (Route1 != null) { if (Route1.ToString() != "") { R1 = Route1; } } if (Route2 != null) { if (Route2.ToString() != "") { R2 = Route2; } } set_seat(); // set Seat to จอง SqlDataSource Res = new SqlDataSource(); Res.ConnectionString = ConfigurationManager.ConnectionStrings["BusTicketConnectionString1"].ToString(); Res.InsertCommand = "INSERT INTO [Reservation] ([Member_UserName], [Res_Name], " +"[Res_Sex], [Res_Phone], [Res_R1], [Res_Price_R1], [Res_R2], [Res_Price_R2], " + "[Res_Serviece_Price], [Res_Sum_Price], [Res_Status], [Res_Seat_Name_R1], [Res_Seat_Name_R2]) " +"VALUES (@Member_UserName, @Res_Name, @Res_Sex, @Res_Phone, @Res_R1, " + "@Res_Price_R1, @Res_R2, @Res_Price_R2, @Res_Serviece_Price, @Res_Sum_Price, @Res_Status, @Res_Seat_Name_R1, @Res_Seat_Name_R2)"; Res.InsertParameters.Clear(); Res.InsertParameters.Add("Member_UserName", User.Identity.Name.ToString()); Res.InsertParameters.Add("Res_Name", TextBox_Name.Text + " " + TextBox_LastName.Text); Res.InsertParameters.Add("Res_Sex", RadioButtonList_Sex.SelectedValue); Res.InsertParameters.Add("Res_Phone", TextBox_Phone.Text); Res.InsertParameters.Add("Res_R1", R1); Res.InsertParameters.Add("Res_R2", R2); Res.InsertParameters.Add("Res_Seat_Name_R1", (String)Session["Seat_R1"]); Res.InsertParameters.Add("Res_Seat_Name_R2", (String)Session["Seat_R2"]); Res.InsertParameters.Add("Res_Price_R1", Label_price_R1.Text); Res.InsertParameters.Add("Res_Price_R2", Label_price_R2.Text); Res.InsertParameters.Add("Res_Serviece_Price", Label_serviece_price_SUM.Text); Res.InsertParameters.Add("Res_Sum_Price", Label_price_SUM_ALL.Text); Res.InsertParameters.Add("Res_Status", "ค้างชำระ"); Res.Insert(); int ID = get_Res_ID_Last(); SqlDataSource Res_Seat = new SqlDataSource(); Res_Seat.ConnectionString = ConfigurationManager.ConnectionStrings["BusTicketConnectionString1"].ToString(); Res_Seat.InsertCommand = "INSERT INTO [Res_Seat] ([Res_ID], [Seat_ID]) " + "VALUES (@Res_ID, @Seat_ID)"; if (Route1 != null) { if (Route1.ToString() != "") { for (int i = 0; i < Seat_R1.Length; i++) { Res_Seat.InsertParameters.Clear(); Res_Seat.InsertParameters.Add("Res_ID", ID.ToString()); int Sead_ID = get_Seat_ID(Route1, Seat_R1[i]); Res_Seat.InsertParameters.Add("Seat_ID", Sead_ID.ToString()); Res_Seat.Insert(); } } } if (Route2 != null) { if (Route2.ToString() != "") { for (int i = 0; i < Seat_R2.Length; i++) { Res_Seat.InsertParameters.Clear(); Res_Seat.InsertParameters.Add("Res_ID", ID.ToString()); int Sead_ID = get_Seat_ID(Route2, Seat_R2[i]); Res_Seat.InsertParameters.Add("Seat_ID", Sead_ID.ToString()); Res_Seat.Insert(); } } } Response.Redirect("~/Members/Ticket.aspx?res_id="+ID.ToString()+""); }