//Get list of workshop for the given programme and major public List <WorkshopVO> GetAllWorkshopForPgmMajor(string inprogrammeId, string inmajorId) { List <WorkshopVO> workshops = new List <WorkshopVO>(); try { DBConnection.conn.Open(); String query = "SELECT w.WorkshopId, w.WorkshopName FROM dbo.Workshop W JOIN dbo.ProgrammeWorkshop pw" + " ON pw.WorkshopID = w.WorkshopId WHERE pw.ProgrammeID=@ProgrammeId AND pw.MajorID=@MajorId"; SqlCommand cmd = new SqlCommand(query, DBConnection.conn); cmd.Parameters.AddWithValue("@ProgrammeId", inprogrammeId); cmd.Parameters.AddWithValue("@MajorId", inmajorId); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { WorkshopVO workshopVO; while (reader.Read()) { workshopVO = new WorkshopVO(); workshopVO.WorkshopId = Int32.Parse(reader[0].ToString()); workshopVO.WorkshopName = reader[1].ToString(); workshops.Add(workshopVO); } } } catch (SqlException e) { ExceptionUtility.LogException(e, "Error Page"); throw new CustomException(ApplicationConstants.UnhandledException + ": " + e.Message); } catch (Exception e) { ExceptionUtility.LogException(e, "Error Page"); throw new CustomException(ApplicationConstants.UnhandledException + ": " + e.Message); } finally { if (DBConnection.conn != null) { DBConnection.conn.Close(); } } return(workshops); }
private void AddNewRowToWorkshopGrid(int workshopId) { if (ViewState["CurrentTableWorkshop"] != null) { DataTable dtCurrentTable = (DataTable)ViewState["CurrentTableWorkshop"]; DataRow drCurrentRow = null; if (dtCurrentTable.Rows.Count > 0) { drCurrentRow = dtCurrentTable.NewRow(); //add new row to DataTable dtCurrentTable.Rows.Add(drCurrentRow); //Store the current data to ViewState ViewState["CurrentTableWorkshop"] = dtCurrentTable; for (int i = 0; i < dtCurrentTable.Rows.Count - 1; i++) { // Update the DataRow with the Selected Items if (i != dtCurrentTable.Rows.Count - 2) { } else { WorkshopBO workshopBO = new WorkshopBO(); WorkshopVO workshopVO = workshopBO.GetWorkshopForId(workshopId); dtCurrentTable.Rows[i]["Column1"] = workshopVO.WorkshopName; } } //Rebind the Grid with the current data gvWorkshop.DataSource = dtCurrentTable; gvWorkshop.DataBind(); } } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('ViewState is null ');", true); Response.Write("ViewState is null"); } //Set Previous Data on Postbacks SetPreviousDataInWorkShopGrid(); }
public List <WorkshopVO> GetILMPWorkshopForId(int ilmpId) { List <WorkshopVO> workshopNames = new List <WorkshopVO>(); try { DBConnection.conn.Open(); string query = "SELECT w.Workshopid,w.Workshopname from dbo.Ilmp i " + " inner join dbo.TemplateCourse tc on tc.TemplateID = i.TemplateId " + " inner join dbo.Workshop w on w.WorkshopID = tc.WorkshopID " + " where tc.WorkshopID!=0 and i.IlmpID=@IlmpID"; SqlCommand cmd = new SqlCommand(query, DBConnection.conn); cmd.Parameters.AddWithValue("@IlmpID", ilmpId); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { WorkshopVO workshop; while (reader.Read()) { workshop = new WorkshopVO(); workshop.WorkshopId = int.Parse(reader["Workshopid"].ToString()); workshop.WorkshopName = (reader["Workshopname"].ToString()); workshopNames.Add(workshop); } } } catch (SqlException ex) { ExceptionUtility.LogException(ex, "Error Page"); throw ex; } finally { if (DBConnection.conn != null) { DBConnection.conn.Close(); } } return(workshopNames); }
//Get workshop details for the given workshopid public WorkshopVO GetWorkshopForId(int inworkshopId) { WorkshopVO workshopVO = new WorkshopVO(); try { DBConnection.conn.Open(); string query = "SELECT WorkshopID,WorkshopName FROM dbo.Workshop WHERE WorkshopID=@WorkshopId"; SqlCommand cmd = new SqlCommand(query, DBConnection.conn); cmd.Parameters.AddWithValue("@WorkshopId", inworkshopId); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { workshopVO.WorkshopId = Int32.Parse(reader["WorkshopID"].ToString()); workshopVO.WorkshopName = reader["WorkshopName"].ToString(); } reader.Close(); } } catch (SqlException ex) { ExceptionUtility.LogException(ex, "Error Page"); throw new CustomException(ApplicationConstants.UnhandledException + ": " + ex.Message); } catch (Exception ex) { ExceptionUtility.LogException(ex, "Error Page"); throw new CustomException(ApplicationConstants.UnhandledException + ": " + ex.Message); } finally { if (DBConnection.conn != null) { DBConnection.conn.Close(); } } return(workshopVO); }