protected void SectionSaveButton_Click(object sender, EventArgs e) { try { DepartmentEntry aDepartmentEntry = new DepartmentEntry(); txtFacultyId.Text = aDepartmentEntryManager.GetDepartmentAutoId(); aDepartmentEntry.DeptId = txtFacultyId.Text.Trim(); aDepartmentEntry.DeptName = txtFacultyName.Text.Trim(); aDepartmentEntry.CollegeName = ddlCourseName.SelectedValue; aDepartmentEntryManager.SaveDepartmentInformation(aDepartmentEntry); RefreshAll(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ale", "alert('Record(s) is/are created suceessfullly...!!');", true); } catch (FormatException fex) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('" + fex.Message + "');", true); } catch (Exception ex) { if (ex.Message.Contains("Database")) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Database Maintain Error. Contact to the Software Provider..!!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('There is some problem to do the task. Try again properly.!!');", true); } } }
public void UpdateDepartmentInformation(DepartmentEntry aDepartmentEntry) { string connectionString = DataManager.OraConnString(); string updateQuery = @"UPDATE [Department_Info] SET [DeptName] = '" + aDepartmentEntry.DeptName + "',[CollegeId] = '" + aDepartmentEntry.CollegeName + "' WHERE [DeptId]='" + aDepartmentEntry.DeptId + "'"; DataManager.ExecuteNonQuery(connectionString, updateQuery); }
public void DeleteDepartmentInformation(DepartmentEntry aDepartmentEntry) { string connectionString = DataManager.OraConnString(); string deleteQuery = @"DELETE FROM [Department_Info] WHERE [DeptId]='" + aDepartmentEntry.DeptId + "' "; DataManager.ExecuteNonQuery(connectionString, deleteQuery); }
public void SaveDepartmentInformation(DepartmentEntry aDepartmentEntry) { string connectionString = DataManager.OraConnString(); string insertQuery = @"INSERT INTO [Department_info] ( [DeptId] ,[DeptName] ,[CollegeId]) VALUES('" + aDepartmentEntry.DeptId + "','" + aDepartmentEntry.DeptName + "','" + aDepartmentEntry.CollegeName + "')"; DataManager.ExecuteNonQuery(connectionString, insertQuery); }