protected void UpdateButton_Click(object sender, EventArgs e) { DropDownList ddl = (DropDownList)FormView1.FindControl("DropDownList1"); TextBox txtten = (TextBox)FormView1.FindControl("TenTPTextBox"); TextBox txtgia = (TextBox)FormView1.FindControl("DongiaTextBox"); TextBox txtslc = (TextBox)FormView1.FindControl("SoluongcoTextBox"); TextBox txtmota = (TextBox)FormView1.FindControl("MotaTextBox"); Image imgName = (Image)FormView1.FindControl("Image1"); Label lblmatp = (Label)FormView1.FindControl("MaTPLabel1"); SqlDataSource sqlUpdate = (SqlDataSource)FormView1.FindControl("sqlUpdateTP"); string urlAnh = fileanh; string ten = txtten.Text.Trim(); string gia = txtgia.Text.Trim(); string slc = txtslc.Text.Trim(); string mota = txtmota.Text.Trim(); string maloai = ddl.SelectedValue; string matp = lblmatp.Text; if (fileanh == null) { sqlUpdate.UpdateCommand = "UPDATE tblThucpham SET TenTP = N'" + ten + "', Dongia = '" + gia + "', Mota = N'" + mota + "', Soluongco = '" + slc + "' WHERE MaTP = '" + matp + "'"; sqlUpdate.Update(); Response.Redirect("Admin_Chitietthucpham.aspx?MaTP=" + matp); } else { sqlUpdate.UpdateCommand = "UPDATE tblThucpham SET TenTP = N'" + ten + "', Dongia = '" + gia + "', Mota = N'" + mota + "', Soluongco = '" + slc + "', urlAnh = '" + urlAnh + "' WHERE MaTP = '" + matp + "'"; sqlUpdate.Update(); Response.Redirect("Admin_Chitietthucpham.aspx?MaTP=" + matp); } }
protected void btnAddCatManJob_Click(object sender, EventArgs e) { string vettedCreateJobText = Regex.Replace(txtCreateJob.Text.ToLower(), @"[\s]+", ""); try { if (vettedCreateJobText != null && vettedCreateJobText != "" && vettedCreateJobText.Length <= 50) { sds.ConnectionString = Resources.ConnectionStrings.ATHENA; sds.SelectCommand = Resources.CatalogManagerSQLQueries.VerifyRegexSelect; DataSourceSelectArguments dssa = new DataSourceSelectArguments(); dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount); dssa.RetrieveTotalRowCount = true; DataView dv = (DataView)sds.Select(dssa); if (dv.Count == 0) { sds.InsertCommand = Resources.CatalogManagerSQLQueries.InsertCleanValues; sds.Insert(); sds.UpdateCommand = Resources.CatalogManagerSQLQueries.UpdateJobs; sds.Update(); } } txtCreateJob.Text = String.Empty; } catch (InvalidCastException ex) { } }
public string updateRoom(RoomData updateData, string old_campus, string old_building) { string response = ""; try { ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update ROOM Set ROOM_THAINAME='" + updateData.Room_ThaiName + "',ROOM_ENGNAME='" + updateData.Room_EngName + "',ROOM_TYPE_CODE='" + updateData.RoomType_Code + "',ROOM_CAPACITY=" + updateData.Room_CAPACITY + ",CAMPUS_CODE='" + updateData.Campus_Code + "',BUILDING_CODE='" + updateData.Building_Code + "',FACULTY_CODE='" + updateData.Faculty_Code + "',DEPARTMENT_CODE='" + updateData.Department_Code + "',AFFIATION_CODE='" + updateData.Affiation_Code + "',ROOM_STATUS='" + updateData.Room_Status + "' Where ROOM_CODE='" + updateData.Room_Code + "' AND CAMPUS_CODE='" + old_campus + "' AND BUILDING_CODE='" + old_building + "' "; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; oracleObj.UpdateCommand = "Update ROOM Set ROOM_TYPE_CODE='" + updateData.RoomType_Code + "',CAMPUS_CODE='" + updateData.Campus_Code + "',BUILDING_CODE='" + updateData.Building_Code + "',FACULTY_CODE='" + updateData.Faculty_Code + "',DEPARTMENT_CODE='" + updateData.Department_Code + "',AFFIATION_CODE='" + updateData.Affiation_Code + "',ROOM_STATUS='" + updateData.Room_Status + "' Where PARENT_ROOM_CODE='" + updateData.Room_Code + "' AND CAMPUS_CODE='" + old_campus + "' AND BUILDING_CODE='" + old_building + "' "; oracleObj.Update(); } } catch (Exception e) { response = e.Message.ToString() + " "; } } catch { HttpContext.Current.Session["response"] = "Unit Test:Room:updateRoom" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
protected void Button1_Click(object sender, EventArgs e) { string ID = Request.QueryString["id"]; SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ID = "SqlDataSource2"; this.Page.Controls.Add(SqlDataSource2); SqlDataSource2.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["memorialtagConnectionString"].ConnectionString; if (RadioButton1.Checked == true) { SqlDataSource2.UpdateCommand = "UPDATE [memorialtag].[dbo].[GravTabel] SET Valid = '1' where GravID ='" + ID + "'"; //SqlDataSource2.UpdateParameters.Add("Vaild", "1"); SqlDataSource2.Update(); } if (RadioButton2.Checked == true) { SqlDataSource2.UpdateCommand = "UPDATE [memorialtag].[dbo].[GravTabel] SET Valid = '0' where GravID ='" + ID + "'"; //SqlDataSource2.UpdateParameters.Add("Vaild", "1"); SqlDataSource2.Update(); } }
/// <summary> /// แก้ไขข้อมูลจากตาราง MAJOR /// </summary> /// <param name="updateData">Major Object</param> /// <returns>Success</returns> public string updateMajor(Major updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update MAJOR Set MAJORTHNAME = '" + updateData.MajorThName + "', MAJORENNAME = '" + updateData.MajorEnName + "' Where MAJORCODE = '" + updateData.MajorCode + "' And CURRCODE = '" + updateData.CurrCode + "' And YEARVERSION = '" + updateData.YearVersion + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateMajor: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public string updateWorkLoadConfig(WorkLoadConfigData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update WorkLoadConfig Set HourReference=" + updateData.HourReference + ", TotalCredit=" + updateData.TotalCredit + " Where LecturerType='" + updateData.LecturerType + "' And LecturerPosition='" + updateData.LecturerPosition + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:WorkLoadConfig:updateWorkLoadConfig" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public string updateAdmissionType(AdmissionTypeData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update ADMISSION_TYPE Set ADMISSIONTYPE_THAI = '" + updateData.AdmissionType_Thai + "', ADMISSIONTYPE_ENG='" + updateData.AdmissionType_Eng + "' Where ADMISSIONTYPE_CODE='" + updateData.AdmissionType_Code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง TQF2SEC3STRUCTUREGROUP /// </summary> /// <param name="updateData">TQF2Sec3StructureGroupCategory Object</param> /// <returns>Success</returns> public string updateTQF2Sec3StructureGroup(TQF2Sec3StructureGroup updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update TQF2SEC3STRUCTUREGROUP Set GROUPCREDITS = '" + updateData.GroupCredits + "', COURSEGROUPFLAG='" + updateData.CourseGroupFlag + "'Where CURRCODE = '" + updateData.CurrCode + "' And YEARVERSION = '" + updateData.YearVersion + "' And CURRFORMATCODE = '" + updateData.CurrFormatCode + "' And CURRTYPECODE = '" + updateData.CurrTypeCode + "' And MAJORCODE = '" + updateData.MajorCode + "' And CATEGORYCODE = '" + updateData.CategoryCode + "' And COURSEGROUPCODE = '" + updateData.CourseGroupCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateTQF2Sec3StructureGroup: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง CATEGORY /// </summary> /// <param name="updateData">Category Object</param> /// <returns>Success</returns> public string updateCategory(Category updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update CATEGORY Set CATEGORYTHNAME = '" + updateData.CategoryThName + "', CATEGORYENNAME = '" + updateData.CategoryEnName + "' Where CATEGORYCODE = '" + updateData.CategoryCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateCategory: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
protected void btn_delpic_Click1(object sender, EventArgs e) { m_FindControl_Control(FormView16, typeof(Image)); img1 = ((Image)contrl_temp); if (img1.ImageUrl.Substring(img1.ImageUrl.LastIndexOf(@"/") + 1).ToLower() != "defaultimg.png" && img1.ImageUrl.Substring(img1.ImageUrl.LastIndexOf(@"\") + 1).ToLower() != "defaultimg.png") { string str_expath = System.Web.Hosting.HostingEnvironment.MapPath("~"); string str_temp = str_expath + img1.ImageUrl.Substring(3, img1.ImageUrl.Length - 3); if (System.IO.File.Exists(str_temp)) { System.IO.File.Delete(str_temp); } SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = str_Data_Source; sds.UpdateCommand = "update T床位系統 set f照片 = null WHERE f照片 ='" + img1.ImageUrl + "'"; sds.Update(); Response.Redirect(this.Page.Request.UrlReferrer.ToString()); } }
public string setNewsID_to_FilesData(string files_id, string news_id) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; sql = "Update News_Files SET NEWS_ID='" + news_id + "' Where FILES_ID='" + files_id + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:News:setNewsID_to_FilesData" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource sqldatasource2 = new SqlDataSource(); sqldatasource2.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString(); sqldatasource2.UpdateParameters.Add("Order_date", TextBox1.Text); sqldatasource2.UpdateParameters.Add("Assign_numbers", TextBox2.Text); sqldatasource2.UpdateParameters.Add("Account_numbers", DropDownList1.Text); sqldatasource2.UpdateParameters.Add("Account_abstract", TextBox3.Text); sqldatasource2.UpdateParameters.Add("Income", TextBox4.Text); sqldatasource2.UpdateParameters.Add("Spend", TextBox5.Text); sqldatasource2.UpdateCommand = "Update [Account_Order_M] set Order_date=@Order_date, Account_numbers=@Account_numbers, Assign_numbers=@Assign_numbers, Account_abstract=@Account_abstract, Income=@Income, Spend=@Spend where Id="+Request["Id"]; int affraw_update = sqldatasource2.Update(); if (affraw_update == 0) { Label1.Text = "error"; } else { Label1.Text = "ok"; Button1.Visible = false; } sqldatasource2.Dispose(); }
//按鈕更新 protected void btnUpdate_Click(object sender, EventArgs e) { //壓縮圖片並存檔 CImageProess.get().UploadImage(FileUpload1, 資料夾路徑, CDictionary.SET_BRAND_PX); x = new SqlDataSource(); x.ConnectionString = CDictionary.CONN_URL; string sql = "UPDATE Company set "; if (!string.IsNullOrEmpty(txtContent.Text)) { sql += " name=N'" + txtName.Text + "', "; if (FileUpload1.HasFile) sql += " picBrandPath='" + CImageProess.imageName + "', "; sql += " manager=N'" + txtManager.Text + "', "; sql += " tel=N'" + txtPhone.Text + "', "; sql += " sparEmail=N'" + txtSpareEmail.Text + "', "; sql += " addr=N'" + txtAddress.Text + "', "; sql += " content=N'" + txtContent.Text + "' "; sql += "WHERE companyID='" + companyID + "'"; x.UpdateCommand = sql; x.Update(); } else return; Response.Write("<script>alert('更改資料成功!')</script>"); Response.Write("<script>location.href='companyCheck.aspx'</script>"); }
/// <summary> /// แก้ไขข้อมูลจากตาราง SERVICESTATUS /// </summary> /// <param name="updateData">ServiceStatus Object</param> /// <returns>Success</returns> public string updateServiceStatus(ServiceStatus updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update SERVICESTATUS Set SERVICESTATUSVALUE = '" + updateData.ServiceStatusValue + "', SERVICESTATUSNAME = '" + updateData.ServiceStatusName + "' Where SERVICESTATUSCODE = '" + updateData.ServiceStatusCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateServiceStatus: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public string updateMajor(MajorData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update MAJOR Set MAJOR_THAINAME = '" + updateData.Major_Thai + "', MAJOR_ENGNAME='" + updateData.Major_Eng + "', MAJOR_SHORTNAME='" + updateData.Major_ShortName + "', DEPARTMENT_CODE='" + updateData.Major_DepartmentCode + "', MAJOR_CODE_STUDENTID='" + updateData.Major_Code_StudentID + "', MAJOR_STATUS='" + updateData.Major_Status + "' Where MAJOR_CODE='" + updateData.Major_Code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:System Config: " + response; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public string updateConfig(SystemConfigData config_data) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update SYSTEM_CONFIG Set ACADEMIC_YEAR='" + config_data.AcademicYear + "',SEMESTER='" + config_data.Semester + "' "; try { oracleObj.UpdateCommand = sql; if (oracleObj.Update() == 1) { response = "OK"; } } catch { HttpContext.Current.Session["response"] = "Unit Test:SystemConfig:updateConfig" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง STUDENT_PROCEEDING /// เฉพาะข้อมูล STUDENT_PROCEEDING_TITLE, PROCEEDING_NAME, PROCEEDING_DB_LEVEL, PROCEEDING_DATE /// </summary> /// <param name="updateData">StudentEnglishTest Object</param> /// <returns>OK</returns> public string updateStudentProceeding(StudentProceedingData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update STUDENT_PROCEEDING Set STUDENT_PROCEEDING_TITLE = '" + updateData.StudentProceedingTitle + "', PROCEEDING_NAME = '" + updateData.ProceedingName + "', PROCEEDING_DB_LEVEL = '" + updateData.ProceedingDbLevel + "', PROCEEDING_DATE = '" + updateData.ProceedingDate + "' Where STUDENT_PROCEEDING_ID = '" + updateData.StudentProceedingId + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateStudentProceeding: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
// ไม่ใช้งาน public string updateSummerProject(ProjectData dataUpdate) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); ProjectData field = dataUpdate; string sql = "Update PROJECT_SUMMER SET THEORY_FEE=" + field.Project_Theory_Fee + ",PRACTICE_FEE=" + field.Project_Practice_Fee + ",THESIS_PROJ_FEE=" + field.Project_ThesisProject_Fee + ",PACKET_FEE=" + field.Project_Packet_Fee + ",NEW_REGIS_FEE=" + field.Project_NewRegister_Fee + ",CARD_FEE=" + field.Project_Card_Fee + ",STUDY_FACILITY_FEE=" + field.Project_StudyFacility_Fee + ",IT_FEE=" + field.Project_IT_Fee + ",HEALTH_FEE=" + field.Project_Health_Fee + ",LIBRARY_FEE=" + field.Project_Library_Fee + ",PROPERTIES_FEE=" + field.Project_Properties_Fee + ",ACCIDENT_FEE=" + field.Project_Accident_Fee + ",ACADEMIC_FEE=" + field.Project_Academic_Fee + ",STUDENT_STATUS_FEE=" + field.Project_StudentStatus_Fee + ",MAINTAINING_FEE=" + field.Project_Maintaining_Fee + ",MORAL_FEE=" + field.Project_Moral_Fee + ",ACTIVITY_FEE=" + field.Project_Activity_Fee + ",CHARGE=" + field.Project_Charge + ",QE_FEE=" + field.Project_QE_Fee + " Where PROJECT_CODE='" + field.Project_Code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง COURSEELECTIVE /// </summary> /// <param name="updateData">CourseElective Object</param> /// <returns>Success</returns> public string updateCourseElective(CourseElective updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update COURSEELECTIVE Set COURSEELECTIVETHNAME = '" + updateData.CourseElectiveThName + "', COURSEELECTIVEENNAME = '" + updateData.CourseElectiveEnName + "', CREDIT = '" + updateData.Credit + "' Where ID = '" + updateData.Id + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateCourseElective: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public string updateHourRefer(HourReferData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update HOUR_REFER_CONFIG Set HOUR_REF=" + updateData.HourRefer + " Where DEGREE_CHAR='" + updateData.Degree_Char + "' AND COURSE_TYPE='" + updateData.CourseType + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:HourRefer:updateHourRefer" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return response; }
protected void btnCheckout_Click1(object sender, EventArgs e) { if (String.IsNullOrEmpty(payment)) { lblPaymentWarning.Text = "Please Select any Payment Method to complete the buying Process."; cod.Focus(); } else { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.InsertCommand = "INSERT INTO [Order] ([cart_transid], [order_customerName], [order_total], [order_payment],[user_id]) VALUES (@cart_transid, @order_customerName, @order_total, @order_payment, @user_id)"; SqlDataSource1.InsertParameters.Add("cart_transid", Session["Tid"].ToString()); SqlDataSource1.InsertParameters.Add("order_customerName", customerName); SqlDataSource1.InsertParameters.Add("order_total", totalprice); SqlDataSource1.InsertParameters.Add("order_payment", payment.ToString()); SqlDataSource1.InsertParameters.Add("user_id", Session["Id"].ToString()); SqlDataSource1.Insert(); SqlDataSource1.UpdateCommand = @"UPDATE [Cart] SET [cart_status] = @cart_status WHERE [cart_transid] = @cart_transid "; SqlDataSource1.UpdateParameters.Add("cart_status", "Paid"); SqlDataSource1.UpdateParameters.Add("cart_transid", Session["Tid"].ToString()); SqlDataSource1.Update(); SqlDataSource1.Dispose(); Response.Redirect("thankyou.aspx"); } }
// V 1.0.0 public string updateExamTable(ExamTableData dataUpdate, string degree_char) { string TableName = getTableName(degree_char); string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update " + TableName + " Set EXAM_MID_ROOM='" + dataUpdate.ExamMid_Room + "',EXAM_MID_DAY='" + dataUpdate.ExamMid_Day + "',EXAM_MID_START_TIME='" + dataUpdate.ExamMid_StartTime + "',EXAM_MID_END_TIME='" + dataUpdate.ExamMid_EndTime + "',EXAM_FINAL_ROOM='" + dataUpdate.ExamFinal_Room + "',EXAM_FINAL_DAY='" + dataUpdate.ExamFinal_Day + "',EXAM_FINAL_START_TIME='" + dataUpdate.ExamFinal_StartTime + "',EXAM_FINAL_END_TIME='" + dataUpdate.ExamFinal_EndTime + "' Where ACADEMIC_YEAR='" + dataUpdate.AcademicYear + "' And SEMESTER='" + dataUpdate.Semester + "' And COURSE_CODE='" + dataUpdate.Course_Code + "' AND CURR_CODE='" + dataUpdate.Curr_Code + "' AND FAC_CODE='" + dataUpdate.Faculty_Code + "' AND DEP_CODE='" + dataUpdate.Department_Code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString() + sql; } return(response); }
public string updatePlan(PlanData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update CURRTYPE Set LEVELCODE = '" + updateData.plan_levalcode + "', CURRTYPENAME='" + updateData.plan_name + "' Where CURRTYPECODE='" + updateData.plan_code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:Plan: ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง LECTUREREXPRIENCE /// </summary> /// <param name="updateData">LecturerExprience Object</param> /// <returns>Success</returns> public string updateLecturerExprience(LecturerExprience updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update LECTUREREXPRIENCE Set SUBJECTNAME = '" + updateData.SubjectName + "', LECTURERTYPE = '" + updateData.LecturerType + "', BEGINYEAR = '" + updateData.BeginYear + "', ENDYEAR = '" + updateData.EndYear + "', QUITISSUE = '" + updateData.QuitIssue + "' Where EXPRIENCEID = '" + updateData.ExprienceId + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateLecturerExprience: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public string updateAcademicCalendar(AcademicCalendarData insertData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = ""; try { sql = "Update Academic_Calendar SET NRL_START_DATE='" + insertData.nrl_start_date + "',NRL_END_DATE='" + insertData.nrl_end_date + "',AD_START_DATE='" + insertData.ad_start_date + "',AD_END_DATE='" + insertData.ad_end_date + "',CH_START_DATE='" + insertData.ch_start_date + "',CH_END_DATE='" + insertData.ch_end_date + "',WT_START_DATE='" + insertData.wt_start_date + "',WT_END_DATE='" + insertData.wt_end_date + "',PP_START_DATE='" + insertData.pp_start_date + "',PP_END_DATE='" + insertData.pp_end_date + "',PPL_START_DATE='" + insertData.ppl_start_date + "',PPL_END_DATE='" + insertData.ppl_end_date + "',PT_START_DATE='" + insertData.pt_start_date + "',PT_END_DATE='" + insertData.pt_end_date + "',PTL_START_DATE='" + insertData.ptl_start_date + "',PTL_END_DATE='" + insertData.ptl_end_date + "',PR_START_DATE='" + insertData.pr_start_date + "',PR_END_DATE='" + insertData.pr_end_date + "',PRL_START_DATE='" + insertData.prl_start_date + "',PRL_END_DATE='" + insertData.prl_end_date + "',RE_START_DATE='" + insertData.re_start_date + "',RE_END_DATE='" + insertData.re_end_date + "',PS_START_DATE='" + insertData.ps_start_date + "',PS_END_DATE='" + insertData.ps_end_date + "',PSL_START_DATE='" + insertData.psl_start_date + "',PSL_END_DATE='" + insertData.psl_end_date + "' Where ACADEMIC_YEAR='" + insertData.academic_year + "' And SEMESTER='" + insertData.semester + "' And DEGREE_CHAR='" + insertData.degree + "'"; oracleObj.UpdateCommand = sql; if (oracleObj.Update() == 1) { response = "OK"; } } catch { HttpContext.Current.Session["response"] = "Unit Test:AcademicCalendar:insertAcademicCalender" + " ไม่สามารถดำเนินการได้ " + sql; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง DIVISION /// </summary> /// <param name="updateData">Department Object</param> /// <returns>Success</returns> public string updateDivision(Division updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update DIVISION Set DIVISIONTHNAME = '" + updateData.DivisionThName + "', DIVISIONENNAME = '" + updateData.DivisionEnName + "', DIVISIONENSHORTNAME = '" + updateData.DivisionEnShortName + "', DEPARTMENTCODE = '" + updateData.DepartmentCode + "', DIVISION_STATUS = '" + updateData.DivisionStatus + "', DIVISION_CODE_STUDENTID = '" + updateData.DivisionCodeStudent + "' Where DIVISIONCODE = '" + updateData.DivisionCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateDivision: " + exception; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง ENGLISH_DB /// </summary> /// <param name="updateData">EnglishDb Object</param> /// <returns>OK</returns> public string updateEnglishDb(EnglishDbData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Update ENGLISH_DB Set ENGLSIH_DB_NAME = '" + updateData.EnglishDbName + "' Where ENGLISH_DB_ID = '" + updateData.EnglishDbId + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateEnglishDb: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง CURRFORMAT /// </summary> /// <param name="updateData">CurrFormat Object</param> /// <returns>Success</returns> public string updateCurrFormat(CurrFormat updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update CURRFORMAT Set LEVELCODE = '" + updateData.LevelCode + "', CURRFORMATNAME = '" + updateData.CurrFormatName + "' Where CURRFORMATCODE = '" + updateData.CurrFormatCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateCurrFormat: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง ABOUTLECTURER /// </summary> /// <param name="updateData">AboutLecturer Object</param> /// <returns>Success</returns> public string updateAboutLecturer(AboutLecturer updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update ABOUTLECTURER Set YEARVERSION = '" + updateData.YearVersion + "', LECTIDENTITY = '" + updateData.LectIdentity + "', LOADTYPECODE = '" + updateData.LoadTypeCode + "', SEQUENCE = '" + updateData.Sequence + "', MAJORCODE = '" + updateData.MajorCode + "' Where CURRCODE = '" + updateData.CurrCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateAboutLecturer: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
public string cancelExtendStudent(string academic_year, string semester, string course_code, int sec_num, int subsec_num, string student_id, string lecturer_code) { string response = ""; string sql = ""; try { ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); sql = "Update EXTEND_AVAILABLE_STUDENT SET CANCEL_STATUS = '1', LECTURER_CANCEL='" + lecturer_code + "' Where ACADEMIC_YEAR = '" + academic_year + "' AND SEMESTER = '" + semester + "' AND COURSE_CODE = '" + course_code + "' AND SEC_NO = " + sec_num + " AND SUBSEC_NO = " + subsec_num + " AND STUDENT_ID = '" + student_id + "' AND CANCEL_STATUS='0' "; oracleObj.UpdateCommand = sql; if (oracleObj.Update() == 1) { response = "OK"; } else { // response = sql; } } catch (Exception err) { HttpContext.Current.Session["response"] = "Unit Test:ExtendAvailableStudent:insertExtendStudent" + " ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง COURSEELECTIVEMEMBER /// </summary> /// <param name="updateData">CourseElectiveMember Object</param> /// <returns>Success</returns> public string updateCourseElectiveMember(CourseElectiveMember updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update COURSEELECTIVEMEMBER Set COURSECODE = '" + updateData.CourseCode + "', COURSEELECTIVECODE = '" + updateData.CourseElectiveCode + "', FACULTYCODE = '" + updateData.FacultyCode + "', FACULTYOWNER = '" + updateData.FacultyOwner + "' Where COURSEELECTIVEMEMBERCODE = '" + updateData.CourseElectiveMemberCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateCourseElectiveMember: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// แก้ไขข้อมูลจากตาราง SUFLAGE /// </summary> /// <param name="updateData">SuFlage Object</param> /// <returns>Success</returns> public string updateSuFlage(SuFlage updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update SUFLAGE Set SUFLAGNAME = '" + updateData.SuFlageName + "', SUFLAGEENNAME = '" + updateData.SuFlageEnName + "' Where SUFLAGCODE = '" + updateData.SuFlagCode + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updateCourseFlag: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
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 Button1_Click(object sender, EventArgs e) { SqlDataSource sqldatasource2 = new SqlDataSource(); sqldatasource2.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString(); sqldatasource2.UpdateParameters.Add("Lottery", DropDownList1.Text); sqldatasource2.UpdateCommand = "Update [Account_Order_M] set Lottery=@Lottery where Id=" + Request["Id"]; int affraw_update = sqldatasource2.Update(); if (affraw_update == 0) { Label8.Text = "error"; } else { Label8.Text = "ok"; Button1.Visible = false; } sqldatasource2.Dispose(); }
public void set_seat() { 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[] Seat_R1 = {}; String[] Seat_R2 = {}; SqlDataSource seat = new SqlDataSource(); seat.ConnectionString = ConfigurationManager.ConnectionStrings["BusTicketConnectionString1"].ToString(); seat.UpdateCommand = "UPDATE [Seat] SET [Seat_Status] = @Seat_Status " +"WHERE [Route_has_Bus_ID] = @Route_has_Bus_ID AND [Seat_Name] = @Seat_Name"; 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() != "") { for (int i = 0; i < Seat_R1.Length; i++) { seat.UpdateParameters.Clear(); seat.UpdateParameters.Add("Seat_Status", "จอง"); seat.UpdateParameters.Add("Route_has_Bus_ID", Route1.ToString()); seat.UpdateParameters.Add("Seat_Name", Seat_R1[i]); seat.Update(); } } } if (Route2 != null) { if (Route2.ToString() != "") { for (int i = 0; i < Seat_R2.Length; i++) { seat.UpdateParameters.Clear(); seat.UpdateParameters.Add("Seat_Status", "จอง"); seat.UpdateParameters.Add("Route_has_Bus_ID", Route2.ToString()); seat.UpdateParameters.Add("Seat_Name", Seat_R2[i]); seat.Update(); } } } }