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;
}
