protected void saveSessionButton_Click(object sender, EventArgs e) { SessionMedel sessionMedel = new SessionMedel(); sessionMedel.SessionValue = sessionValueTextBox.Text; if (sessionValueTextBox.Text=="") { successStatusLabel.InnerText = "Please enter the session name."; } else { if (addSessionBll.IsSessionExist(sessionMedel)) { successStatusLabel.InnerText = ""; failStatusLabel.InnerText = "This session already exist"; } else { if (addSessionBll.SaveSession(sessionMedel) > 0) { failStatusLabel.InnerText = ""; successStatusLabel.InnerText = "Session saved"; GetAllSessionInGridView(); ClearTextBox(); } else { successStatusLabel.InnerText = ""; failStatusLabel.InnerText = "Session not saved"; } } } }
public int SaveSession(SessionMedel sessionMedel) { string query = String.Format("Insert into tblSession values(@sessionValue)"); int rowsAffected = 0; using (SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { SqlCommand cmd1 = new SqlCommand(query,con1); cmd1.Parameters.Clear(); cmd1.Parameters.AddWithValue("@sessionValue", sessionMedel.SessionValue); con1.Open(); rowsAffected = cmd1.ExecuteNonQuery(); con1.Close(); } return rowsAffected; }
public bool IsSessionExist(SessionMedel sessionMedel) { bool isSessionExist = false; string query = String.Format("Select * from tblSession where name=@name"); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { SqlCommand cmd = new SqlCommand(query,con); cmd.Parameters.Clear(); SqlParameter nameParameter = new SqlParameter("@name", sessionMedel.SessionValue); cmd.Parameters.Add(nameParameter); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { isSessionExist = true; } con.Close(); } return isSessionExist; }
public List<SessionMedel> GetAllSession() { List<SessionMedel> sessionMedels = new List<SessionMedel>(); string query = String.Format("spGetAllSession"); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = query; using (sqlConnection) { sqlConnection.Open(); SqlDataReader rdr = sqlCommand.ExecuteReader(); while (rdr.Read()) { SessionMedel sessionMedel = new SessionMedel(); sessionMedel.ID = Convert.ToInt32(rdr[0]); sessionMedel.SessionValue = rdr[1].ToString(); sessionMedels.Add(sessionMedel); } sqlConnection.Close(); } return sessionMedels; }
public List<SessionMedel> GetAllSession() { List<SessionMedel> sessionMedels = new List<SessionMedel>(); string query = String.Format("spGetAllSession"); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { SessionMedel sessionMedel = new SessionMedel(); sessionMedel.ID = Convert.ToInt32(rdr[0]); sessionMedel.SessionValue = rdr[1].ToString(); sessionMedels.Add(sessionMedel); } connection.Close(); } } return sessionMedels; }
public int SaveSession(SessionMedel sessionMedel) { return addSessionDal.SaveSession(sessionMedel); }
public bool IsSessionExist(SessionMedel sessionMedel) { return addSessionDal.IsSessionExist(sessionMedel); }
public List<SessionMedel> GetAllSessionIdByDepetId(int deptId) { List<SessionMedel> sessionMedels = new List<SessionMedel>(); string query = String.Format(@"select sessionId from tblStudentSemisterRegistration where deptId=@deptId"); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.Clear(); command.Parameters.AddWithValue("@deptId", deptId); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { SessionMedel sessionMedel = new SessionMedel(); sessionMedel.ID = Convert.ToInt32(rdr[0]); sessionMedels.Add(sessionMedel); } connection.Close(); } } return sessionMedels; }
public List<SessionMedel> GetAllSessionBySessionId(List<SessionMedel> sessionMedelsParameter) { List<SessionMedel> sessionMedels = new List<SessionMedel>(); string query = String.Format(@"select * from tblSession where id=@sessionId"); foreach (SessionMedel session in sessionMedelsParameter) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.Clear(); command.Parameters.AddWithValue("@sessionId", session.ID); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); while (rdr.Read()) { SessionMedel sessionMedel = new SessionMedel(); sessionMedel.ID = Convert.ToInt32(rdr[0]); sessionMedel.SessionValue = rdr[1].ToString(); sessionMedels.Add(sessionMedel); } connection.Close(); } } } return sessionMedels; }