protected void top_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ImageButton action = (ImageButton)e.CommandSource;
string actionString = action.ID;
if (action.ID.Equals("join"))
{
try
{
student = new Student();
classmeet = new ClassMeeting();
listado = new Classlist();
Section section = new Section();
string id = ((Label)class_data.Items[e.Item.ItemIndex].FindControl("Id")).Text;
section.Id = Int32.Parse(((Label)class_data.Items[e.Item.ItemIndex].FindControl("section")).Text);
classmeet.Id = id;
student.Email = Session["Username"].ToString();
listado.ClassMeeting = classmeet;
listado.Student = student;
payment = new List <AraPayment>();
ReadAllPaymentByStudentCommand _cmd__ = new ReadAllPaymentByStudentCommand(student);
_cmd__.Execute();
payment = _cmd__.Payments;
bool flag = false;
foreach (AraPayment Payment in payment)
{
if (Payment.Section.Id == section.Id && Payment.RemainingClasses > 0)
{
Payment.Id = Payment.Id;
Payment.RemainingClasses = Payment.RemainingClasses - 1;
UpdateRemainingClassesCommand __cmd_ = new UpdateRemainingClassesCommand(Payment);
__cmd_.Execute();
CreateClasslistCommand _cmd_ = new CreateClasslistCommand(listado);
_cmd_.Execute();
flag = true;
}
}
if (flag == true)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "random", "alertme_succ()", true);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "random", "alertme_err_class()", true);
}
}
catch (Exception ex)
{
}
}
else if (action.ID.Equals("modify"))
{
try
{
}
catch (Exception ex)
{
}
}
}
public int UpdateClasslistComment(Classlist classlist)
{
conn = DAO.getConnection();
NpgsqlCommand command = new NpgsqlCommand(DAOClasslistResource.UpdateClasslistSP, conn);
NpgsqlTransaction transaction = conn.BeginTransaction();
NpgsqlParameter id = new NpgsqlParameter();
NpgsqlParameter classMeeting = new NpgsqlParameter();
NpgsqlParameter student = new NpgsqlParameter();
id.ParameterName = DAOClasslistResource.Id;
classMeeting.ParameterName = DAOClasslistResource.ClassId;
student.ParameterName = DAOClasslistResource.StudentId;
id.NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
classMeeting.NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Varchar;
student.NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Varchar;
id.Direction = ParameterDirection.Input;
classMeeting.Direction = ParameterDirection.Input;
student.Direction = ParameterDirection.Input;
id.Value = classlist.Id;
classMeeting.Value = classlist.ClassMeeting.Id;
student.Value = classlist.Student.Email;
command.Parameters.Add(id);
command.Parameters.Add(classMeeting);
command.Parameters.Add(student);
command.CommandType = CommandType.StoredProcedure;
int response = 500;
NpgsqlDataReader dr = command.ExecuteReader();
try
{
while (dr.Read())
{
response = dr.GetInt32(0);
}
dr.Close();
transaction.Commit();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(response);
}
public UpdateClasslistCommand(Classlist classlist)
{
this.classlist = classlist;
}
public DeleteClasslistCommand(Classlist classlist)
{
this.classlist = classlist;
}
public static string GetobjectInfo(Classlist @class, string Property)
{
ManagementObjectSearcher managementObjectSearcher =
new ManagementObjectSearcher("Select " + Property + " From " + @class);
ManagementObjectCollection managementObjectCollection = managementObjectSearcher.Get();
string result = null;
foreach (ManagementObject managementObject in managementObjectCollection.Cast<ManagementObject>())
{
result = managementObject[Property].ToString();
}
return result;
}
protected void Create_Class(object sender, EventArgs e)
{
student = new Student();
student.Email = Session["Username"].ToString();
payment = new List <AraPayment>();
ReadAllPaymentByStudentCommand _cmd_ = new ReadAllPaymentByStudentCommand(student);
_cmd_.Execute();
payment = _cmd_.Payments;
bool flag = false;
foreach (AraPayment Payment in payment)
{
if (Payment.Section.Id == Int32.Parse(list_section.SelectedValue) && Payment.RemainingClasses > 0)
{
Payment.Id = Payment.Id;
Payment.RemainingClasses = Payment.RemainingClasses - 1;
UpdateRemainingClassesCommand __cmd_ = new UpdateRemainingClassesCommand(Payment);
__cmd_.Execute();
topic = new Topic();
topic.Id = Int32.Parse(list_topics.SelectedValue);
ReadTopicCommand cmd_ = new ReadTopicCommand(topic);
cmd_.Execute();
topic = cmd_.Topic;
MeetingInJson meetingInJson = ZoomAPI.CreateMeeting(topic.Name, "2021-11-15T20:15:00"); //LLAMADA DE EJEMPLO
DateTime startTime = DateTime.Parse(fec_ini.Value, CultureInfo.GetCultureInfo("en-US"));
DateTime hourTime = DateTime.Parse(Hora.Value, System.Globalization.CultureInfo.CurrentCulture);
startTime = Convert.ToDateTime(startTime.ToShortDateString() + " " + hourTime.TimeOfDay);
DateTime createdAt = DateTime.Now;
section = new Section();
section.Id = Int32.Parse(list_section.SelectedValue);
teacher = new Teacher();
teacher.Email = "*****@*****.**";
ClassMeeting cm = new ClassMeeting(meetingInJson.id, meetingInJson.uuid, meetingInJson.host_id,
meetingInJson.host_email, meetingInJson.topic, 1,
meetingInJson.status, startTime, Int32.Parse(meetingInJson.duration),
meetingInJson.timezone, meetingInJson.agenda, createdAt, meetingInJson.start_url,
meetingInJson.join_url, meetingInJson.password, meetingInJson.h323_password, meetingInJson.pstn_password,
meetingInJson.encrypted_password, "Clase Creada", section, teacher);
CreateClassMeetingCommand cmd = new CreateClassMeetingCommand(cm);
cmd.Execute();
if (cmd.ClassMeeting.Code == 200)
{
listado = new Classlist(meetingInJson, student);
student = new Student();
classmeet = new ClassMeeting();
classmeet.Id = meetingInJson.id;
student.Email = Session["Username"].ToString();
listado.Student = student;
listado.ClassMeeting = classmeet;
CreateClasslistCommand _cmd = new CreateClasslistCommand(listado);
_cmd.Execute();
flag = true;
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "random", "alertme()", true);
}
}
}
if (flag == true)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "random", "alertme_succ()", true);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "random", "alertme_err_class()", true);
}
}
public List <Classlist> ReadClasslist(ClassMeeting classMeeting)
{
conn = DAO.getConnection();
Classlist readClasslist = new Classlist();
List <Classlist> classLists = new List <Classlist>();
int id;
try
{
conn = DAO.getConnection();
NpgsqlTransaction tran = conn.BeginTransaction();
NpgsqlCommand command = new NpgsqlCommand(DAOClasslistResource.ReadClasslistByClassSP, conn);
NpgsqlParameter parameter = new NpgsqlParameter();
parameter.ParameterName = DAOClasslistResource.Id;
parameter.NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Varchar;
parameter.Direction = ParameterDirection.Input;
parameter.Value = classMeeting.Id;
command.Parameters.Add(parameter);
command.CommandType = CommandType.StoredProcedure;
NpgsqlDataReader dr = command.ExecuteReader();
try
{
while (dr.Read())
{
id = dr.GetInt32(0);
String classId = dr.GetString(1);
DateTime classDate = dr.GetDateTime(2);
String classLink = dr.GetString(3);
String classComment = dr.GetString(4);
String studentEmail = dr.GetString(5);
String studentName = dr.GetString(6);
String studentLastname = dr.GetString(7);
Student student = new Student();
student.Email = studentEmail;
student.Name = studentName;
student.LastName = studentLastname;
classMeeting.StartTime = classDate;
classMeeting.JoinUrl = classLink;
classMeeting.Comment = classComment;
readClasslist = new Classlist(id, classMeeting, student);
classLists.Add(readClasslist);
}
dr.Close();
tran.Commit();
return(classLists);
}
catch (Exception ex)
{
throw ex;
}
}
catch (NpgsqlException ex2)
{
throw ex2;
}
finally
{
conn.Close();
}
}
