// <snippet3>
public bool Delete()
{
if (ID.Equals(DBNull.Value))
{
// The Employee object is not persisted.
return(true);
}
else
{
// The Employee object is persisted.
// Use the SqlDataSource control as a convenient wrapper for
// the ADO.NET code needed to delete a record from the database.
ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["NorthwindConnection"];
SqlDataSource sds = new SqlDataSource();
try {
sds.ConnectionString = cts.ConnectionString;
sds.DeleteParameters.Add(new Parameter("empID", TypeCode.Int32, this.ID.ToString()));
sds.DeleteCommand = "DELETE FROM [Order Details] " +
"WHERE OrderID IN (SELECT OrderID FROM Orders WHERE EmployeeID=@empID)";
sds.Delete();
sds.DeleteCommand = "DELETE FROM Orders WHERE EmployeeID=@empID";
sds.Delete();
sds.DeleteCommand = "DELETE FROM EmployeeTerritories WHERE EmployeeID=@empID";
sds.Delete();
sds.DeleteCommand = "DELETE FROM Employees WHERE EmployeeID=@empID";
sds.Delete();
return(true);
}
finally {
// Clean up resources.
sds.Dispose();
}
}
}
public string delProject(string project_code)
{
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_NewStdPayment;
log_data.Username = loginData.User_ID;
log_data.Message = "Delete ";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string response = "";
try
{
// if (oracleObj.Delete() > 0)
// {
oracleObj.DeleteCommand = "Delete From PROJECT_ADDITIONAL Where PROJECT_CODE='" + project_code + "'";
if (oracleObj.Delete() > 0)
{
log_data.Message += " Project_Addition With:" + project_code;
oracleObj.DeleteCommand = "Delete From PROJECT Where PROJECT_CODE='" + project_code + "'";
if (oracleObj.Delete() > 0)
{
log_data.Message += " ,PROJECT With:" + project_code;
oracleObj.DeleteCommand = "Delete From PROJECT_CONFIG Where PROJECT_CODE='" + project_code + "'";
if (oracleObj.Delete() > 0)
{
log_data.Message += " ,PROJECT_CONFIG With:" + project_code;
response = "OK";
log_data.StatusCode = log_data.LogStatus_SUCCESS;
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
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 deleteWorkLoadConfig(string lecturer_type, string lecturer_position)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From WorkLoadConfig Where LecturerType='" + lecturer_type + "' And LecturerPosition='" + lecturer_position + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:WorkLoadConfig:deleteWorkLoadConfig" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง TQF2SEC3STRUCTUREGROUP
/// </summary>
/// <param name="CurrCode">รหัสหลักสูตร(Curriculum)</param>
/// <returns>Success</returns>
public string deleteTQF2Sec3StructureGroup(string CurrCode)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From TQF2SEC3STRUCTUREGROUP Where CURRCODE ='" + CurrCode + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteTQF2Sec3StructureGroup: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
public string deleteRegistrationConfig(string student_year, string degree_char, string section)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Delete From REGISTRATION_CONFIG Where STUDENT_YEAR_ADMISSION=" + student_year + " AND DEGREE_CHAR='" + degree_char + "' AND SECTION='" + section + "'";
try
{
oracleObj.DeleteCommand = sql;
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
HttpContext.Current.Session["response"] = "Unit Test:RegistrationConfig:deleteRegistrationConfig" + " ไม่สามารถดำเนินการได้" + sql;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
public string deleteHourRefer(string degree_char, string course_type)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From HOUR_REFER_CONFIG Where DEGREE_CHAR='" + degree_char + "' AND COURSE_TYPE='" + course_type + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:HourRefer:deleteHourRefer" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return response;
}
/// <summary>
/// ลบข้อมูลจากตาราง LECTUREREXPRIENCE
/// </summary>
/// <param name="sql">SQL Command</param>
/// <returns>Success</returns>
public string deleteLecturerExprienceManual(string sql)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteLecturerExprienceManual: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง ENGLISH_DB
/// </summary>
/// <param name="EnglishDbId">รหัสมาตรฐานภาษาอังกฤษ</param>
/// <returns>OK</returns>
public string deleteEnglishDb(string EnglishDbId)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From ENGLISH_DB Where ENGLISH_DB_ID ='" + EnglishDbId + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteEnglishDb: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง STUDENT_PROCEEDING
/// </summary>
/// <param name="StudentEnglishTestId">รหัสผลการสอบภาษาอังกฤษ</param>
/// <returns>OK</returns>
public string deleteStudentProceeding(string StudentProceedingId)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From STUDENT_PROCEEDING Where STUDENT_PROCEEDING_ID ='" + StudentProceedingId + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteStudentProceeding: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
//if user decides to delete account
protected void ButtonDelete_Click(object sender, EventArgs e)
{
//check is password has been entered
if (tboxCurrentPW.Text == "")
{
LabelError.Text = "You need to enter your password in order to delete your account";
divChange.Visible = true;
divCurrent.Visible = false;
return;
}
//check if password is correct
if (password_validaton())
{
SqlDataSource objDS = new SqlDataSource();
objDS.ProviderName = ConfigurationManager.ConnectionStrings["ConnectionString_myDatabase"].ProviderName;
objDS.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString_myDatabase"].ConnectionString;
//deleted the account and goes to logout, this will null the session values
objDS.DeleteCommand = "DELETE FROM [Forum_User]" +
"WHERE [pk_User_ID]=[?]";
objDS.DeleteParameters.Add("pk_Thread_ID", Session["pk_User_ID"].ToString());
objDS.Delete();
Response.Redirect("Logout.aspx");
}
else
{
LabelError.Text = "You entered your password incorrectly";
divChange.Visible = true;
divCurrent.Visible = false;
}
}
public string deleteVerificationRegis(string AcademicYear, string Semester, string Student_ID, string Course_Code, string degree_char)
{
string TableName = getTableName(degree_char);
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From " + TableName + " Where ACADEMIC_YEAR='" + AcademicYear + "' And SEMESTER='" + Semester + "' And STUDENT_ID='" + Student_ID + "' And COURSE_CODE='" + Course_Code + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString() + " ";
}
return(response);
}
// V1.0.0
public string deleteConfigNewStudentReg(string academic_year, string semester, string degree_char, string faculty_code)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Delete From CONFIG_NEWSTD_REG Where ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And FACULTY_CODE='" + faculty_code + "' AND DEGREE_CHAR='" + degree_char + "' ";
try
{
oracleObj.DeleteCommand = sql;
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:ConfigNewStudentReg:deleteConfigNewStudentReg" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
public string deleteAddWorkLoad(string academic_year, string semester, string lecturer_id)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Delete AddWorkLoad Where ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And LECTURER='" + lecturer_id + "' ";
try
{
oracleObj.DeleteCommand = sql;
if (oracleObj.Delete() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:AddWorkLoad:deleteAddWorkLoad" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง QUALIFICATIONDETAIL
/// </summary>
/// <param name="sql">sql</param>
/// <returns>Success</returns>
public string deleteQualificationDetailManual(string sql)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
//string sql = "Delete From QUALIFICATIONDETAIL Where UUIDNUMBER ='" + UUIDNumber + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteQualificationDetail: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง QUALIFICATIONDETAIL
/// </summary>
/// <param name="LectIdentity">เลขประจำตัวประชาชน(SysUser)</param>
/// <param name="QualificationDegree">ชื่อคุณวุฒิ</param>
/// <param name="Year">ปีที่จบการศึกษา</param>
/// <param name="Academy">สถาบันที่สำเร็จการศึกษา</param>
/// <returns>Success</returns>
public string deleteQualificationDetail(string LectIdentity, string QualificationDegree, string Year, string Academy)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From QUALIFICATIONDETAIL Where LECTIDENTITY ='" + LectIdentity + "' And QUALIFICATIONDEGREE ='" + QualificationDegree + "' And YEAR ='" + Year + "' And ACADEMY ='" + Academy + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteQualificationDetail: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
// V1.0.0
public string deleteConfig(string delete_id)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
try
{
oracleObj.DeleteCommand = "Delete From STUDENT_ID_CONFIG Where ID=" + delete_id;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (oracleObj.Delete() == 1)
{
response = "OK";
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:StudentIDConfig:deleteConfig" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
public string deleteAcademicCalendar(string academic_year, string semester, string degree_char)
{
string response = "";
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "Delete From Academic_Calendar Where ACADEMIC_YEAR='" + academic_year + "' AND SEMESTER='" + semester + "' AND DEGREE_CHAR='" + degree_char + "'";
try
{
oracleObj.DeleteCommand = sql;
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
HttpContext.Current.Session["response"] = "Unit Test:AcademicCalendar:deleteAcademicCalendar" + " ไม่สามารถดำเนินการได้" + sql;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
// V 1.0.0
public string deleteLecturerTable(LecturerTableData delete_data, string degree_char)
{
string response = "";
try
{
string TableName = getTableName(degree_char);
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From " + TableName + " Where ACADEMIC_YEAR='" + delete_data.AcademicYear + "' And SEMESTER='" + delete_data.Semester + "' And COURSE_CODE='" + delete_data.Course_Code + "' And SEC_NO=" + delete_data.Sec_No + " And SUBSEC_NO=" + delete_data.SubSec_No + " And ROOM_CODE='" + delete_data.Room_Code + "' And BUILDING_CODE='" + delete_data.Building_Code + "' And CAMPUS_CODE='" + delete_data.Campus_Code + "' And TEACHING_DAY='" + delete_data.Teaching_Day + "' And TEACHING_START_TIME='" + delete_data.Teaching_Start_Time + "' And TEACHING_END_TIME='" + delete_data.Teaching_End_Time + "' ";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:LecturerTable:deleteLecturerTable" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง DIVISION
/// </summary>
/// <param name="DivisionCode">รหัสสาขา</param>
/// <returns>Success</returns>
public string deleteDivision(string DivisionCode)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From DIVISION Where DIVISIONCODE ='" + DivisionCode + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteDivision: " + exception;
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
public string deleteCampus(string CampusCode)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From CAMPUS Where CAMPUS_CODE ='" + CampusCode + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:System Config:Delete Campus" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง LECTUREREXPRIENCE
/// </summary>
/// <param name="LectIdentity">บัตรประจำตัวประชาชน</param>
/// <returns>Success</returns>
public string deleteLecturerExprience(string LectIdentity)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From LECTUREREXPRIENCE Where LECTIDENTITY ='" + LectIdentity + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteLecturerExprience: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง TQF2SEC4SUB1
/// </summary>
/// <param name="T2S4Sub1No">รหัสการพัฒนาคุณลักษณะพิเศษของนักศึกษา</param>
/// <returns>Success</returns>
public string deleteTQF2Sec4Sub1(string T2S4Sub1No)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From TQF2SEC4SUB1 Where T2S4SUB1NO ='" + T2S4Sub1No + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteTQF2Sec4Sub1: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
public string deletePlan(string plan_code)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From CURRTYPE Where CURRTYPECODE ='" + plan_code + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
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>
/// ลบข้อมูลจากตาราง SERVICESTATUS
/// </summary>
/// <param name="ServiceStatusCode">A=ทุกคณะ/วิทยาลัย, O=ภายในคณะ/วิทยาลัย</param>
/// <returns>Success</returns>
public string deleteServiceStatus(string ServiceStatusCode)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From SERVICESTATUS Where SERVICESTATUSCODE ='" + ServiceStatusCode + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteServiceStatus: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
public string deleteMajor(string Major_Code)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From MAJOR Where MAJOR_CODE ='" + Major_Code + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
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);
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataSource SqlDataSource2 = new SqlDataSource();
SqlDataSource2.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
try
{
SqlDataSource2.DeleteCommand = "delete [Account_Order_M] where id=" + Request["Id"];
int affraw = SqlDataSource2.Delete();
if (affraw == 0)
{
Label8.Text = "error";
Button1.Visible = false;
}
else
{
Label8.Text = "ok";
Button1.Visible = false;
}
}
catch (Exception ex2)
{
Response.Write(ex2.ToString());
}
finally
{
SqlDataSource2.Dispose();
}
}
/// <summary>
/// ลบข้อมูลจากตาราง COURSEELECTIVEMEMBER
/// </summary>
/// <param name="CourseElectiveCode">รหัสวิชา xxx</param>
/// <param name="FacultyCode">รหัสคณะ</param>
/// <returns>Success</returns>
public string deleteCourseElectiveMemberManual(string sql)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
//string sql = "Delete From COURSEELECTIVEMEMBER Where COURSEELECTIVECODE ='" + CourseElectiveCode + "' And FACULTYCODE='" + FacultyCode + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteCourseElectiveMember: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
/// <summary>
/// ลบข้อมูลจากตาราง CURRFORMAT
/// </summary>
/// <param name="CurrFormatCode">รหัสรูปแบบหลักสูตร</param>
/// <returns>Success</returns>
public string deleteCurrFormat(string CurrFormatCode)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From CURRFORMAT Where CURRFORMATCODE ='" + CurrFormatCode + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteCurrFormat: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string myMessage = null;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox myCheckBox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
Label myID = (Label)GridView1.Rows[i].FindControl("Label1");
if (myCheckBox.Checked == true)
{
myMessage = myMessage + myID.Text + "or[P_id]=";
}
}
int index = myMessage.LastIndexOf("or[P_id]=");
if (index > 0)
{
myMessage = myMessage.Substring(0, index);
}
//lblMsg.Text += myMessage;
SqlDataSource sds = new SqlDataSource();
sds.ConnectionString = @"Data Source=.;Initial Catalog=Guardian_Angel;Integrated Security=True";
sds.DeleteCommand = "delete NPGrouping where [N_id]=" + DetailsView1.Rows[0].Cells[1].Text + "and ([P_id]=" + myMessage + ")";
sds.Delete();
Response.Redirect(Request.Url.ToString());
}
/// <summary>
/// ลบข้อมูลจากตาราง COURSEELECTIVE
/// </summary>
/// <param name="CourseElectiveCode">รหัสวิชา</param>
/// <param name="Id">Primary Key</param>
/// <returns>Success</returns>
public string deleteCourseElective(string Id)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Delete From COURSEELECTIVE Where ID ='" + Id + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "Success";
}
}
catch (Exception e)
{
string exception = e.Message;
HttpContext.Current.Session["response"] = "deleteCourseElective: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
return(response);
}
// V 1.0.0
public string deleteSubCredit2(string academic_year, string semester, string course_code, int sec_no, int subsec_no, string teach_day, string teach_start, string teach_end, string degree_char)
{
string response = "";
try
{
string TableName = getTableName(degree_char);
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From " + TableName + " Where ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And COURSE_CODE='" + course_code + "' And SEC_NO=" + sec_no + " And SUBSEC_NO=" + subsec_no + " And TEACHING_DAY = '" + teach_day + "' And TEACHING_START_TIME = '" + teach_start + "' And TEACHING_END_TIME = '" + teach_end + "'";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:SubCredit:deleteSubCredit" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
protected void delete_seat(String Route_has_Bus_ID)
{
SqlDataSource seat = new SqlDataSource();
seat.ConnectionString =
ConfigurationManager.ConnectionStrings["BusTicketConnectionString1"].ToString();
seat.DeleteCommand = "DELETE FROM [Seat] WHERE Route_has_Bus_ID = " + Route_has_Bus_ID;
seat.Delete();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataSource SqlDataSource2 = new SqlDataSource();
SqlDataSource2.ConnectionString=WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
try
{
//update
//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 [Joural_Order_M] set Order_date=@Order_date, Assign_numbers=@Assign_numbers, Account_numbers=@Account_numbers, Account_abstract=@Account_abstract, Income=@Income, Spend=@Spend where Id=" + Request["Id"];
//update
SqlDataSource2.DeleteCommand = "delete [Account_Order_M] where Id=" + Request["Id"];
//delete table Joural_Order_M content
//SqlDataSource2.DeleteParameters.Add("Order_date", Label1.Text);
//SqlDataSource2.DeleteParameters.Add("Assign_numbers", Label2.Text);
//SqlDataSource2.DeleteParameters.Add("Account_numbers", Label3.Text);
//SqlDataSource2.DeleteParameters.Add("Account_abstract", TextBox3.Text);
//SqlDataSource2.DeleteParameters.Add("Income", TextBox4.Text);
//SqlDataSource2.DeleteParameters.Add("Spend", TextBox5.Text);
//delete table Joural_Order_M content
int affraw = SqlDataSource2.Delete();
if (affraw == 0)
{
Label1.Text = "Error";
}
else
{
Label1.Text = "Delete OK";
Button1.Visible = false;
}
}
catch (Exception ex2)
{
Response.Write("error" + ex2.ToString());
}
finally
{
SqlDataSource2.Dispose();
}
}
