public static string recycleAA(List <string> _arr)
{
SBObj _sbobj = new SBObj();
//_sbobj.QuestionID = Convert.ToInt32(_arr[0].ToString());
return(_sbobj.RecycleAA());
}
public static string updateQuestionaireNotAnswered(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.QuestionID = Convert.ToInt32(_arr[0].ToString());
return(_sbobj.UpdateQuestionaireNotAnswered());
}
public static string launchLiveQuestion(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.QuestionID = Convert.ToInt32(_arr[0].ToString());
return(_sbobj.LaunchLiveQuestion());
}
public static string insertChat(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.Message = _arr[0].ToString();
_sbobj.EID = _arr[1].ToString();
return(_sbobj.InsertChat());
}
public static string addAdmin(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.EID = _arr[0].ToString();
_sbobj.Capability = _arr[1].ToString();
_sbobj.Project = _arr[2].ToString();
return(_sbobj.AddAdmin());
}
public static string addQuestionaire(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.Question = _arr[0].ToString();
_sbobj.Answer = _arr[1].ToString();
_sbobj.Difficulty = _arr[2].ToString();
return(_sbobj.AddQuestionaire());
}
public static string addActivity(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.Title = _arr[0].ToString();
_sbobj.Description = _arr[1].ToString();
_sbobj.Date = Convert.ToDateTime(_arr[2].ToString());
return(_sbobj.AddActivity());
}
public static string insertRegistration(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.EID = _arr[0].ToString();
_sbobj.Capability = _arr[1].ToString();
_sbobj.Project = _arr[2].ToString();
return(_sbobj.InsertRegistration());
}
public static string updateCorrect(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.QuestionID = Convert.ToInt32(_arr[0].ToString());
_sbobj.GuestAnswer = _arr[1].ToString();
_sbobj.EID = _arr[2].ToString();
return(_sbobj.UpdateCorrect());
}
public static string updateQuestionaire(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.QuestionID = Convert.ToInt32(_arr[0].ToString());
_sbobj.Question = _arr[1].ToString();
_sbobj.Answer = _arr[2].ToString();
_sbobj.Difficulty = _arr[3].ToString();
return(_sbobj.UpdateQuestionaire());
}
public static string updateAdmin(List <string> _arr)
{
SBObj _sbobj = new SBObj();
_sbobj.UserNo = Convert.ToInt32(_arr[0].ToString());
_sbobj.EID = _arr[1].ToString();
_sbobj.Capability = _arr[2].ToString();
_sbobj.Project = _arr[3].ToString();
_sbobj.Type = _arr[4].ToString();
return(_sbobj.UpdateAdmin());
}
protected void btnLogin_Click(object sender, EventArgs e)
{
SBObj _sbobj = new SBObj();
Session["errMSG"] = "";
Session["lanid"] = txtUserName.Text;
if (txtUserName.Text == "")
{
Session["errMSG"] = "Invalid EID";
malingmensahe.ForeColor = System.Drawing.Color.Red;
malingmensahe.Text = "Invalid EID";
}
else
{
try
{
if (Session["errMSG"].ToString().Equals(string.Empty))
{
DataTable dt = new DataTable();
dt = _sbobj.getLoginDetails((string)Session["lanid"]).Tables[0];
if (dt.Rows.Count == 0)
{
Session["errMSG"] = "Something Went Wrong";
Response.Redirect("~/Login.aspx");
}
else
{
DataSet ds = new DataSet();
ds = _sbobj.getLoginDetails((string)Session["lanid"]);
foreach (DataRow drow in ds.Tables[0].Rows)
{
Session["Type"] = drow["Type"].ToString();
Session["lanid"] = drow["EID"].ToString();
Response.Redirect("~/Default.aspx");
Response.Cookies["lanid"].Expires = DateTime.Now.AddHours(1);
//Response.Cookies["lanid"].Value = txtUserName.Text.Trim();
}
}
}
else
{
}
}
catch (Exception)
{
//Response.Redirect("~/Login.aspx");
//malingmensahe.ForeColor = System.Drawing.Color.Red;
//malingmensahe.Text = "Invalid EID";
//throw;
}
}
}
public static string loadTop3(Int32 userno)
{
SBObj _sbobj = new SBObj();
_sbobj.UserNo = userno;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_sbobj.LoadTop3());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string checkifAnswered(Int32 questid)
{
SBObj _sbobj = new SBObj();
_sbobj.QuestionID = questid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_sbobj.CheckifAnswered());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string getActiveQuestion(Int32 questid)
{
SBObj _sbobj = new SBObj();
_sbobj.QuestionID = questid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_sbobj.GetActiveQuestion());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string displayQuestionairesModal(Int32 questid)
{
SBObj _sbobj = new SBObj();
_sbobj.QuestionID = questid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_sbobj.DisplayQuestionairesModal());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string displayMakeAdmin(Int32 questid)
{
SBObj _sbobj = new SBObj();
_sbobj.UserNo = questid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_sbobj.DisplayMakeAdmin());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string alertCorrectAnswer(Int32 questid)
{
SBObj _sbobj = new SBObj();
_sbobj.QuestionID = questid;
DataSet ds = new DataSet();
try
{
ds.Tables.Add(_sbobj.AlertCorrectAnswer());
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
public static string displayChat(List <string> _arr)
{
DataTable dummy = new DataTable();
SBObj _sbobj = new SBObj();
DataSet ds = new DataSet();
try
{
dummy.Merge(_sbobj.DisplayChat());
ds.Tables.Add(dummy);
}
catch (Exception ex)
{
}
return(ds.GetXml());
}
