protected void btnDeleteSection_Click(object sender, EventArgs e)
{
Sections sec = new Sections();
Question ques=new Question ();
Assessment ass = new Assessment();
AnswerDetail ansDetail = new AnswerDetail();
CVTCMenu menu=new CVTCMenu ();
QuestionResponse qr=new QuestionResponse ();
int sectOID = Convert.ToInt32(Request.QueryString["soid"].ToString());
int AssOID = sec.GetAssessmentOIDBySectionOID(sectOID);
if (ass.GetAssessmentStatusByOID(Convert.ToInt32(AssOID)) == 1)
{
LabelMessage.Text = "This group can not be deleted.It has been Locked";
return;
}
else
{
string menuURL = "pg/assessment/section.aspx?soid=" + sectOID + "";
//Delete from AnswerDetails and Question Table by SectionOID
bool DeleteFromAnswerDetail=ansDetail.DeleteAnswerDetailBySectionOID(sectOID);
Collection<Question> qList = new Collection<Question>();
qList = ques.GetQuestionOIDBySectionOID(sectOID);
foreach (Question q in qList )
{
qr.DeleteQuestionBySectionOID(q.QuestionOID);
}
bool DeleteFromQuestion = ques.DeleteQuestionBySectionOID(sectOID);
bool DeleteFromMenu = menu.DeleteMenuByMenuURL(menuURL);
bool DeleteFromSection = sec.DeleteSectionBySectionOID(sectOID);
if (DeleteFromSection && DeleteFromMenu)
{
InitializeQuestion(sectOID);
LabelMessage.Text = "This question group has been deleted successfully";
}
else
{
LabelMessage.Text = "This question group can not be deleted.Please try again..";
}
ButtonRefresh_Click(null, null);
}
}
public static string GetMenu()
{
CVTCMenu menu = new CVTCMenu();
Collection<CVTCMenu> MenuList = menu.GetAllMenu();
// //{ id: "1", Name: "Main Menu", MenuId: "1", MenuName: "Menu1",
// // level: "0", parent: "", isLeaf: false, expanded: false
// // },
//string data="[ ";
//foreach (CVTCMenu m in MenuList)
//{
// data += "{ id:'" + m.OID + "', Name:'" + m.NameMenu + "', MenuId:'" + m.MenuID + "', level:'" + m.MenuLevel + "', parent:'" + m.Parent + "', isLeaf:'"+m.IsLeave+"',expanded:'"+m.IsExpanded+"'},";
//}
//data = data.Substring(0,data.Length-1);
//data+=" ] ";
//string data = "[{ id: '1', Name: 'Main Menu', MenuId: '1', level: '0', parent: '', isLeaf: 'false', expanded: 'false'}]";
//return data;
//object o = new object();
//o=(object)data;
//return MenuList;
//return MenuList.se
return menu.BuildJQGridResults(MenuList,10,1,2);
}
//(Collection<CVTCMenu> menuList)
public bool SaveAssessmentMenuItem(CVTCMenu m)
{
bool result = false;
try
{
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
//foreach (CVTCMenu m in menuList)
{
command.Connection = connection;
command.CommandText = "{CALL Menu_insert(?,?,?,?,?,?,?)}";
command.CommandType = CommandType.StoredProcedure;
OdbcParameter paramNameMenu = new OdbcParameter("@NameMenu", OdbcType.VarChar, 50);
paramNameMenu.Value = m.NameMenu;
command.Parameters.Add(paramNameMenu);
OdbcParameter paramMenuID = new OdbcParameter("@MenuID", OdbcType.Int);
paramMenuID.Value = m.MenuID;
command.Parameters.Add(paramMenuID);
OdbcParameter paramURL = new OdbcParameter("@URL", OdbcType.VarChar, 100);
paramURL.Value = m.URL;
command.Parameters.Add(paramURL);
OdbcParameter paramMenuLevel = new OdbcParameter("@MenuLevel", OdbcType.Int);
paramMenuLevel.Value = m.MenuLevel;
command.Parameters.Add(paramMenuLevel);
OdbcParameter paramParent = new OdbcParameter("@Parent", OdbcType.Int);
paramParent.Value = m.Parent;
command.Parameters.Add(paramParent);
OdbcParameter paramIsLeaf = new OdbcParameter("@IsLeaf", OdbcType.Int);
paramIsLeaf.Value = m.IsLeave=="true"?1:0;
command.Parameters.Add(paramIsLeaf);
OdbcParameter paramIsExpanded = new OdbcParameter("@IsExpanded", OdbcType.Int);
paramIsExpanded.Value = m.IsExpanded == "true" ? 1 : 0;
command.Parameters.Add(paramIsExpanded);
//command.Parameters.Add("@OID", OdbcType.Int);
//command.Parameters["@OID"].Direction = ParameterDirection.Output;
connection.Open();
int n = command.ExecuteNonQuery();
//string t_return = command.Parameters["@OID"].Value.ToString();
if (n == 1)
result = true;
else
result = false;
connection.Close();
}
//Do some Coding here
}
}
//result = true;
}
catch (Exception ex)
{
result = false;
}
return result;
}
public CVTCMenu GetMenuByOID(int OID)
{
CVTCMenu menu=null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
//command.Connection = connection;
////command.CommandText = "UPDATE dbo.Users SET " + "UserName='******', " + " FirstName='" + firstName + "', " + " MiddleName='" + middleName + "'," + "LastName='" + lastName + "'," + "EmailID='" + emailID + "'" + " where UserID='" + userid + "' ";
//command.CommandText = "INSERT INTO Users (UserName, FirstName, LastName, MiddleName, EmailID) VALUES (" + "'" + userName + "','" + firstName + "','" + lastName + "','" + middleName + "','" + emailID + "')";
//connection.Open();
//command.ExecuteNonQuery();
command.Connection = connection;
command.CommandText = "{CALL Menu_ByOID(?)}";
command.CommandType = CommandType.StoredProcedure;
OdbcParameter paramODI = new OdbcParameter("@MOID", OdbcType.Int);
paramODI.Value = OID;
command.Parameters.Add(paramODI);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
if (dataReader.Read())
{
menu = new CVTCMenu();
menu.OID = (int)dataReader["OID"];
menu.Parent = Convert.ToInt32(dataReader["Parent"]);
menu.NameMenu = Convert.ToString(dataReader["NameMenu"]);
menu.URL = Convert.ToString(dataReader["URL"]);
menu.MenuLevel = Convert.ToInt32(dataReader["MenuLevel"]);
menu.MenuID = Convert.ToInt32(dataReader["MenuID"]);
menu.IsLeave = Convert.ToInt32(dataReader["IsLeave"]) == 1 ? "true" : "false";
menu.IsExpanded = Convert.ToInt32(dataReader["IsExpanded"]) == 1 ? "true" : "false";
}
}
}
return menu;
}
}
public CVTCMenu GetMenuByMenuName(string Name)
{
CVTCMenu menu = null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Menu_ByName(?)}";
command.CommandType = CommandType.StoredProcedure;
OdbcParameter paramODI = new OdbcParameter("@MenuName", OdbcType.VarChar ,200);
paramODI.Value = Name;
command.Parameters.Add(paramODI);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
if (dataReader.Read())
{
menu = new CVTCMenu();
menu.OID = (int)dataReader["OID"];
menu.Parent = Convert.ToInt32(dataReader["Parent"]);
menu.NameMenu = Convert.ToString(dataReader["NameMenu"]);
menu.URL = Convert.ToString(dataReader["URL"]);
menu.MenuLevel = Convert.ToInt32(dataReader["MenuLevel"]);
menu.MenuID = Convert.ToInt32(dataReader["MenuID"]);
menu.IsLeave = Convert.ToInt32(dataReader["IsLeave"]) == 1 ? "true" : "false";
menu.IsExpanded = Convert.ToInt32(dataReader["IsExpanded"]) == 1 ? "true" : "false";
}
}
}
return menu;
}
}
public Collection<CVTCMenu> GetAllMenu()
{
Collection<CVTCMenu> MenuList = new Collection<CVTCMenu>();
//string connectionString = @"Data Source=.\SQLEXPRESS; Initial Catalog=cvtc; User ID=cvtcuser; Password=cvtcuser";
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
//command.Connection = connection;
////command.CommandText = "UPDATE dbo.Users SET " + "UserName='******', " + " FirstName='" + firstName + "', " + " MiddleName='" + middleName + "'," + "LastName='" + lastName + "'," + "EmailID='" + emailID + "'" + " where UserID='" + userid + "' ";
//command.CommandText = "INSERT INTO Users (UserName, FirstName, LastName, MiddleName, EmailID) VALUES (" + "'" + userName + "','" + firstName + "','" + lastName + "','" + middleName + "','" + emailID + "')";
//connection.Open();
//command.ExecuteNonQuery();
command.Connection = connection;
command.CommandText = "Menu_GetAllMenu";
command.CommandType = CommandType.StoredProcedure;
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
CVTCMenu menu;
while (dataReader.Read())
{
menu = new CVTCMenu();
menu.OID = (int)dataReader["OID"];
menu.Parent = Convert.ToInt32(dataReader["Parent"]);
menu.NameMenu = Convert.ToString(dataReader["NameMenu"]);
menu.URL = Convert.ToString(dataReader["URL"]);
menu.MenuLevel = Convert.ToInt32(dataReader["MenuLevel"]);
menu.MenuID = Convert.ToInt32(dataReader["MenuID"]);
menu.IsLeave = Convert.ToInt32(dataReader["IsLeave"])==1?"true":"false";
menu.IsExpanded = Convert.ToInt32(dataReader["IsExpanded"])==1?"true":"false";
MenuList.Add(menu);
}
}
}
return MenuList;
}
}
protected void ImageButtonDelete_Click(object sender, ImageClickEventArgs e)
{
Assessment ass = new Assessment();
GridViewRow row = ((ImageButton)sender).Parent.Parent as GridViewRow;
HiddenField HiddenFieldAssessmentID = (HiddenField)row.Cells[0].FindControl("HiddenFieldAssessmentID");
string OID = HiddenFieldAssessmentID.Value;
string AssessmentName = null;
if (ass.GetAssessmentStatusByOID(Convert.ToInt32(OID)) == 1)
{
PopulateGrid();
lblStatus.Text = "This Assessment can not be Deleted.It has been Locked";
return;
}
if (OID != null && OID != "")
{
ass = ass.GetAssessmentByOID(Convert.ToInt32(OID));
if (ass != null)
{
AssessmentName = ass.AssessmentName;
}
}
if (ass.DisableAssessmentStatus(Convert.ToInt32(OID)))
{
CVTCMenu menu = new CVTCMenu();
menu = menu.GetMenuByMenuName(AssessmentName);
if (menu != null)
{
int MenuID = menu.MenuID;
int parentID = menu.Parent;
while (MenuID <= (menu.MenuID + 8))
{
menu.DeleteMenuByParent(MenuID);
MenuID++;
}
menu.DeleteMenuByMenuID(menu.MenuID);
}
PopulateGrid();
lblStatus.Text = "This Assessment has been deleted successfully";
}
}
protected void ButtonCreate_Click(object sender, EventArgs e)
{
try
{
if (TextBoxAssessment.Text.Length > 0)
{
string assName = TextBoxAssessment.Text;
int menuId = new CVTCMenu().GetMaxMenuID();
menuId += 1;
TextBoxAssessment.Text = "";
Collection<CVTCMenu> menuList = new Collection<CVTCMenu>();
CVTCMenu menu = null;
Section section = new Section();
Assessment ass = new Assessment();
ass.AssessmentName = assName;
ass.CreatedBy = 1;
ass.CreatedDate = DateTime.Now;
ass.LastModifiedBy = 1;
ass.LastModifiedDate = DateTime.Now;
ass.RefMenuID = menuId;
ass.TotalFlag = 0;
ass.TotalFlagPoint = 0;
ass.TotalQuestion = 0;
ass.TotalSection = 0;
ass.AddAssessment();
section.AssessmentOID = ass.AssessmentOID;
section.SectionName = "NoScore";
section.TotalQuestion = 0;
section.TotalFlag = 0;
section.Low = -1;
section.Medium = -1;
section.Flag = -1;
section.High = -1;
section.LastModifiedBy = 1;
section.CreatedBy = 1;
section.CreatedDate = DateTime.Now;
section.LastModifiedDate = DateTime.Now;
section.PassingTotal = -1;
section.FlagPointTotal = -1;
section.QuestionList = null;
section.AddSection();
#region Assign Value to Menu Items
for (int i = menuId; i <= (menuId + 10); i++)
{
menu = new CVTCMenu();
menu.MenuID = i;
if (menu.MenuID == menuId)
{
menu.NameMenu = assName;
menu.URL = " ";
menu.MenuLevel = 1;
menu.Parent = 24;
menu.IsExpanded = "false";
menu.IsLeave = "false";
}
if (menu.MenuID == (menuId + 1))
{
menu.NameMenu = "View Results";
menu.URL = "pg/assessment/Result.aspx?aid=" + ass.AssessmentOID.ToString();
menu.MenuLevel = 2;
menu.Parent = menuId;
menu.IsExpanded = "true";
menu.IsLeave = "true";
}
if (menu.MenuID == (menuId + 2))
{
menu.NameMenu = "Settings";
menu.URL = "pg/assessment/setting.aspx?aid=" + ass.AssessmentOID.ToString();
menu.MenuLevel = 2;
menu.Parent = menuId;
menu.IsExpanded = "true";
menu.IsLeave = "true";
}
if (menu.MenuID == (menuId + 3))
{
menu.NameMenu = "Reminder Email";
menu.URL = " ";
menu.MenuLevel = 2;
menu.Parent = menuId;
menu.IsExpanded = "false";
menu.IsLeave = "false";
}
if (menu.MenuID == (menuId + 4))
{
menu.NameMenu = "Send Email";
menu.URL = "pg/assessment/ReminderEmail.aspx?aid=" + ass.AssessmentOID.ToString();
menu.MenuLevel = 3;
menu.Parent = (menuId + 3);
menu.IsExpanded = "true";
menu.IsLeave = "true";
}
if (menu.MenuID == (menuId + 5))
{
menu.NameMenu = "Edit Term Codes";
menu.URL = "pg/assessment/editTermCodes.aspx?aid=" + ass.AssessmentOID.ToString();
menu.MenuLevel = 3;
menu.Parent = (menuId + 3);
menu.IsExpanded = "true";
menu.IsLeave = "true";
}
if (menu.MenuID == (menuId + 6))
{
menu.NameMenu = "Results Email";
menu.URL = "pg/assessment/ResultEmail.aspx?aid=" + ass.AssessmentOID.ToString();
menu.MenuLevel = 2;
menu.Parent = menuId;
menu.IsExpanded = "true";
menu.IsLeave = "true";
}
if (menu.MenuID == (menuId + 7))
{
menu.NameMenu = "Results Letter";
menu.URL = "pg/assessment/ResultLetter.aspx?aid=" + ass.AssessmentOID.ToString();
menu.MenuLevel = 2;
menu.Parent = menuId;
menu.IsExpanded = "true";
menu.IsLeave = "true";
}
if (menu.MenuID == (menuId + 8))
{
menu.NameMenu = "Question Groups";
menu.URL = " ";
menu.MenuLevel = 2;
menu.Parent = menuId;
menu.IsExpanded = "false";
menu.IsLeave = "false";
}
if (menu.MenuID == (menuId + 9))
{
menu.NameMenu = "Add";
menu.URL = "pg/assessment/SectionEdit.aspx?aid=" + ass.AssessmentOID.ToString();
menu.MenuLevel = 3;
menu.Parent = (menuId + 8);
menu.IsExpanded = "true";
menu.IsLeave = "true";
}
if (menu.MenuID == (menuId + 10))
{
menu.NameMenu = "No Score";
menu.URL = "pg/assessment/NoScore.aspx?soid=" + section.SectionOID.ToString();
menu.MenuLevel = 2;
menu.Parent = menuId;
menu.IsExpanded = "true";
menu.IsLeave = "true";
}
menuList.Add(menu);
}
#endregion
//Save it to database
foreach (CVTCMenu m in menuList)
{
menu.SaveAssessmentMenuItem(m);
}
PopulateGrid();
LabelMessage.Text = "Saved Successfully.";
}
else
{
LabelMessage.Text = "Please Enter Assessment Name.";
TextBoxAssessment.Focus();
return;
}
//ass.UpdateAssessmentRef();
}
catch (Exception ex)
{
}
}
protected void ButtonSaveMyWork_Click(object sender, EventArgs e)
{
string ordNum = null, ques = null, RespAct = null, Resp = null, Flag = null,Reverse=null;
int assessmentOID=0;
Question questn;//=new Question();
try
{
assessmentOID = (Session["aid"] != null) ? Convert.ToInt32(Session["aid"]) : -1;
Collection<Question> quesList;// = new Collection<Question>();
Collection<QuestionResponse> respList;//=new Collection<QuestionResponse>();
QuestionResponse quesResp;
Section section=new Section();
section.SectionName = TextBoxSectionName.Text;
section.AssessmentOID = assessmentOID;
section.LastModifiedBy = 1;
section.CreatedBy = 1;
section.FlagPointTotal = 0;
section.PassingTotal = 0;
section.SectionOID = 0;
section.TotalFlag = 0;
section.TotalQuestion = 0;
section.Flag =Convert.ToInt32( TextBoxFlag.Text);
section.Low = Convert.ToInt32(TextBoxLow.Text);
section.Medium = Convert.ToInt32(TextBoxMedium.Text);
section.High = 67;
#region Question
//Loop For Questions
quesList = new Collection<Question>();
for(int i=1;;i+=6)
{
questn = new Question();
ordNum = "TextOrderNumber" + i.ToString();
if (ordNum==null )
{
break;
}
ques = "TextQuestion" + i.ToString();
RespAct = "SelectResponseAction" + i.ToString();
//Loop For Question Responses
respList = new Collection<QuestionResponse>();
for (int j = 0; j < 6; j++)
{
quesResp = new QuestionResponse();
Resp = "TextResponse" + (i+j).ToString();
Flag = "SelectFalgRating" + (i + j).ToString();
//Get Value From Form
Resp = Request.Form[Resp];
Flag = Request.Form[Flag];
//Assign values Question Response
quesResp.CreatedBy = 1;
quesResp.LastModifiedBy = 1;
quesResp.FlagRating = Convert.ToInt32(Flag);
quesResp.Response = Resp;
respList.Add(quesResp);
}
ordNum = Request.Form[ordNum];
if (ordNum == null) break;
ques = Request.Form[ques];
RespAct = Request.Form[RespAct];
//Assign Values to question
// quesList= new Collection<Question>();
//questn = new Question();
questn.CreatedBy = 1;//Set current user
questn.LastModifiedBy = 1;//Set current user
questn.Keyword = " ";
questn.MultipleAllow = 1;
questn.OrderNo = Convert.ToInt32(ordNum);
questn.QuestionText = ques;
questn.RespAction = RespAct;
Reverse = Convert.ToString("chkReverse" + i.ToString());
Reverse = Request.Form[Reverse];
if (Reverse == "on")
{
questn.Reverse = 1;
}
else
{
questn.Reverse = 0;
}
quesList.Add(questn);
questn.QuestionRespList = respList;
}
#region dummy
////Process
//for (int j = 1; ; j++)
//{
// Resp = "TextResponse" + i.ToString() + "_" + j.ToString();
// Flag = "SelectFalgRating" + i.ToString() + "_" + j.ToString();
// Resp = Request.Form[Resp];
// Flag = Request.Form[Flag];
// if (Resp == null) break;
// //Assign values Question Response
// quesResp = new QuestionResponse();
// quesResp.CreatedBy = 1;
// quesResp.LastModifiedBy = 1;
// quesResp.FlagRating = Convert.ToInt32(Flag);
// quesResp.Response = Resp;
// respList.Add(quesResp);
//}
#endregion
#endregion
section.QuestionList = quesList;
section.AddSection();
section.UpdateAssessmentSection();
TextBoxSectionName.Text = "";
//TextBoxPassingTotal.Text = "0";
TextBoxTotalQuestion.Text = "1";
Assessment ass = new Assessment();
ass = ass.GetAssessmentByOID(assessmentOID);
CVTCMenu menu = new CVTCMenu();
CVTCMenu tmp = menu.GetMenuByOID(ass.RefMenuID);
menu.NameMenu = section.SectionName;
int menuId = new CVTCMenu().GetMaxMenuID();
menuId += 1;
menu.MenuID = menuId;
menu.URL = "pg/assessment/section.aspx?soid=" + section.SectionOID.ToString();
menu.MenuLevel = 3;
menu.Parent = tmp.MenuID+8;
menu.IsExpanded = "true";
menu.IsLeave = "true";
menu.SaveAssessmentMenuItem(menu);
LabelMessage.Text = "Saved Successfully.";
}
catch (Exception ex)
{
}
}
