public SessionLecturer Add(SessionLecturer obj)
{
obj.ValidationErrors.Clear();
try
{
String query = "INSERT INTO session_lecturer_tab (RefSessionId,RefLecturerId,ObjVersion)VALUES(" +
"'" + obj.RefSessionId + "'," +
"'" + obj.RefLecturerId + "'," +
"'0')";
if (ExcuteStatement(query))
{
//obj.ObjId = Get(obj.EmpNo).ObjId;
return(obj);
}
else
{
obj.ValidationErrors.Add("Error While adding..");
return(obj);
};
}
catch (Exception ex)
{
throw;
}
}
public SessionLecturer Get(int ObjId)
{
String query = "SELECT ObjId,ObjVersion,RefSessionId,RefLecturerId FROM session_lecturer_tab WHERE Objid=" + ObjId;
SessionLecturer obj = new SessionLecturer();
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
obj.ObjId = int.Parse(dataReader["ObjId"].ToString());
obj.ObjVersion = int.Parse(dataReader["ObjVersion"].ToString());
obj.RefSessionId = int.Parse(dataReader["RefSessionId"].ToString());
obj.RefLecturerId = int.Parse(dataReader["RefLecturerId"].ToString());
obj.Name = new LecturerAPI().Get(int.Parse(dataReader["RefLecturerId"].ToString())).Name;
}
dataReader.Close();
this.CloseConnection();
return(obj);
}
else
{
return(obj);
}
}
public SessionLecturer AddUpdate(SessionLecturer obj)
{
if (obj.ObjId.ToString() == "0")
{
return(Add(obj));
}
return(obj);
}
private Session Add(Session obj)
{
obj.ValidationErrors.Clear();
try
{
String query = "INSERT INTO session_tab (RefTagId,RefSubjectId,RefGroupId,RefSubGroupId,StudentCount,Duration,ObjVersion)VALUES(" +
"'" + obj.RefTagId + "'," +
"'" + obj.RefSubjectId + "'," +
"'" + obj.RefGroupId + "'," +
"'" + obj.RefSubGroupId + "'," +
"'" + obj.StudentCount + "'," +
"'" + obj.Duration + "'," +
"'0')";
if (ExcuteStatement(query))
{
obj.ObjId = GetMaxObjId();
foreach (DataRow item in obj.LecturerLst.Rows)
{
SessionLecturer sl = new SessionLecturer();
sl.RefSessionId = obj.ObjId;
sl.RefLecturerId = int.Parse(item["ObjId"].ToString());
new SessionLecturerAPI().Add(sl);
}
return(obj);
}
else
{
obj.ValidationErrors.Add("Error While adding..");
return(obj);
};
}
catch (Exception ex)
{
throw;
}
}
public List <SessionLecturer> GetAll()
{
string query = "SELECT ObjId,ObjVersion,RefSessionId,RefLecturerId FROM session_lecturer_tab ORDER BY ObjId DESC";
List <SessionLecturer> lst = new List <SessionLecturer>();
SessionLecturer obj;
if (this.OpenConnection() == true)
{
//Create Command
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
obj = new SessionLecturer();
obj.ObjId = int.Parse(dataReader["ObjId"].ToString());
obj.ObjVersion = int.Parse(dataReader["ObjVersion"].ToString());
obj.RefSessionId = int.Parse(dataReader["RefSessionId"].ToString());
obj.RefLecturerId = int.Parse(dataReader["RefLecturerId"].ToString());
obj.Name = new LecturerAPI().Get(int.Parse(dataReader["RefLecturerId"].ToString())).Name;
lst.Add(obj);
}
//close Data Reader
dataReader.Close();
//close Connection
this.CloseConnection();
//return list to be displayed
return(lst);
}
else
{
return(lst);
}
}
