//---Getting subjects by ID
public Subjects getSubjectByID(int SubjectID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
Subjects clsSubjectRet = null;
dt_1 = clsDAC.Read_DT_Procedure("sp_GetSubjects", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectID", SubjectID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
DataRow dr_1 = dt_1.Rows[0];
clsSubjectRet = new Subjects()
{
SubjectID = Convert.ToInt32(dr_1["SubjectID"]),
SubjectName = Convert.ToString(dr_1["SubjectName"]),
SubjectCode = Convert.ToString(dr_1["SubjectCode"]),
SubjectImage = (Byte[])(dr_1["SubjectImage"]),
SubjectType = Convert.ToInt32(dr_1["SubjectType"]),
SubjectTypeDesc = Convert.ToString(dr_1["SubjectTypeDesc"]),
SubjectYear = Convert.ToString(dr_1["SubjectYear"]),
ParentSubjectID = (dr_1["ParentSubjectID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["ParentSubjectID"]))
};
}
return(clsSubjectRet);
}
public dynamic getStudentSelectedSubjectsByID(int StudentID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <object> lstRet = new List <object>();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetStudentsSelectedSubjects", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("StudentID", StudentID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
lstRet.Add(new
{
StudentNumber = Convert.ToString(dr_1["StudentNumber"]),
FirstName = Convert.ToString(dr_1["FirstName"]),
LastName = Convert.ToString(dr_1["LastName"]),
BatchCode = Convert.ToString(dr_1["BatchCode"]),
SubjectID = Convert.ToString(dr_1["SubjectID"]),
SubjectCode = Convert.ToString(dr_1["SubjectCode"]),
SubjectName = Convert.ToString(dr_1["SubjectName"]),
SubjectImage = (byte[])(dr_1["SubjectImage"])
});
}
}
return(lstRet);
}
public ActionResult ChapterQuetionsDelete(int CHID, int SCID)
{
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectsChaptersID", SCID),
new KeyValuePair <string, object>("ContentHolder", CHID),
new KeyValuePair <string, object>("CreatedBy", Session["UserID"])
};
clsDAC.Execute_Procedure("sp_DeleteSubjectQuestions", lstData);
ViewBag.Error = clsDAC.Error_Message;
if (clsDAC.Error_Message.Trim() == "")
{
Response.Redirect(string.Format("~/Chapters/ChapterContents?ID={0}", SCID));
}
else
{
Response.Redirect(string.Format("~/Chapters/ChapterContents?ID={0}&removed=0", SCID));
}
return(View());
}
public List <Subjects> getSubjectTopics()
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetSubjectTopics");
List <Subjects> lstSubjects = new List <Subjects>();
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
lstSubjects.Add(new Subjects()
{
SubjectID = Convert.ToInt32(dr_1["SubjectID"]),
SubjectName = Convert.ToString(dr_1["SubjectName"]),
SubjectCode = Convert.ToString(dr_1["SubjectCode"]),
SubjectImage = (Byte[])(dr_1["SubjectImage"]),
SubjectType = Convert.ToInt32(dr_1["SubjectType"]),
SubjectTypeDesc = Convert.ToString(dr_1["SubjectTypeDesc"]),
SubjectYear = Convert.ToString(dr_1["SubjectYear"]),
ParentSubjectID = (dr_1["ParentSubjectID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["ParentSubjectID"]))
});
}
}
return(lstSubjects);
}
public dynamic getChaptersBySubjectsID(int SubjectID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <object> lstRet = new List <object>();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetSubjectsChapters", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectID", SubjectID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
lstRet.Add(new
{
SubjectsChaptersID = Convert.ToInt32(dr_1["SubjectsChaptersID"]),
ChapterCode = Convert.ToString(dr_1["ChapterCode"]),
ChapterName = Convert.ToString(dr_1["ChapterName"]),
SubjectID = Convert.ToInt32(dr_1["SubjectID"]),
SubjectName = Convert.ToString(dr_1["SubjectName"]),
});
}
}
return(lstRet);
}
//---Getting Students
public List <Students> getStudents()
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetStudents");
List <Students> lstStudents = new List <Students>();
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
lstStudents.Add(new Students()
{
StudentID = Convert.ToInt32(dr_1["StudentID"]),
StudentNumber = Convert.ToString(dr_1["StudentNumber"]),
FirstName = Convert.ToString(dr_1["FirstName"]),
MiddleInit = Convert.ToString(dr_1["MiddleInit"]),
LastName = Convert.ToString(dr_1["LastName"]),
DateofBirth = dr_1["DateofBirth"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr_1["DateofBirth"]),
BatchCode = Convert.ToString(dr_1["BatchCode"]),
Address1 = Convert.ToString(dr_1["Address1"]),
Address2 = Convert.ToString(dr_1["Address2"]),
City = Convert.ToString(dr_1["City"]),
Zipcode = Convert.ToString(dr_1["Zipcode"]),
StateCode = Convert.ToString(dr_1["StateCode"]),
UserID = Convert.ToInt32(dr_1["UserID"])
});
}
}
return(lstStudents);
}
//---Getting Student by ID
public Students getStudentByID(int StudentID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
Students clsStudentRet = new Students();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetStudents", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("StudentID", StudentID)
});
if (dt_1 != null && dt_1.Rows.Count > 0)
{
DataRow dr_1 = dt_1.Rows[0];
clsStudentRet = new Students()
{
StudentID = Convert.ToInt32(dr_1["StudentID"]),
StudentNumber = Convert.ToString(dr_1["StudentNumber"]),
FirstName = Convert.ToString(dr_1["FirstName"]),
MiddleInit = Convert.ToString(dr_1["MiddleInit"]),
LastName = Convert.ToString(dr_1["LastName"]),
DateofBirth = dr_1["DateofBirth"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr_1["DateofBirth"]),
BatchCode = Convert.ToString(dr_1["BatchCode"]),
Address1 = Convert.ToString(dr_1["Address1"]),
Address2 = Convert.ToString(dr_1["Address2"]),
City = Convert.ToString(dr_1["City"]),
Zipcode = Convert.ToString(dr_1["Zipcode"]),
StateCode = Convert.ToString(dr_1["StateCode"]),
UserID = Convert.ToInt32(dr_1["UserID"]),
Password = Convert.ToString(dr_1["Password"]) == "" ? "" : System.Text.ASCIIEncoding.ASCII.GetString(Convert.FromBase64String(Convert.ToString(dr_1["Password"])))
};
}
return(clsStudentRet);
}
// GET: Student/Delete/5
public ActionResult Delete(int id)
{
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("StudentID", id),
new KeyValuePair <string, object>("CreatedBy", Session["UserID"]),
new KeyValuePair <string, object>("Mode", "Delete")
};
clsDAC.Execute_Procedure("sp_StudentsCRUD", lstData);
ViewBag.Error = clsDAC.Error_Message;
if (clsDAC.Error_Message.Trim() == "")
{
Response.Redirect("~/Students/List?removed=1");
}
else
{
Response.Redirect("~/Students/List?removed=0");
}
return(View());
}
public PayPalInvoiceModel GetPayPalInvoiceByGUID(string invoiceGUID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
PayPalInvoiceModel clsSubjectRet = null;
dt_1 = clsDAC.Read_DT_Procedure("sp_GetPayPalInvoiceByGUID", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("InvoiceGUID", invoiceGUID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
DataRow dr_1 = dt_1.Rows[0];
clsSubjectRet = new PayPalInvoiceModel()
{
InvoiceGUID = Convert.ToString(dr_1["InvoiceGUID"]),
PayPalInvoiceID = (dr_1["PayPalInvoiceID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["PayPalInvoiceID"])),
QuestionID = (dr_1["QuestionID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["QuestionID"])),
RequestXML = Convert.ToString(dr_1["RequestXML"]),
PaymentID = Convert.ToString(dr_1["PaymentID"]),
ResponseXML = Convert.ToString(dr_1["ResponseXML"]),
State = Convert.ToString(dr_1["State"]),
};
}
return(clsSubjectRet);
}
// GET: Subjects/Create
public ActionResult Create()
{
verifySessionforAdmin();
Subjects modelSubjects = new Subjects();
IEnumerable <SelectListItem> ddlSubjectType = null;
IEnumerable <SelectListItem> ddlparentSubjects = null;
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
DataTable dt_1 = clsDAC.Read_DT_Query("SELECT ValueColumn,DisplayColumn FROM dbo.tblLookups WHERE LookupCode='SubjectType'");
if (dt_1 != null)
{
ddlSubjectType = dt_1.Rows.Cast <DataRow>().ToList().Select(x => new SelectListItem()
{
Value = Convert.ToString(x["ValueColumn"]), Text = Convert.ToString(x["DisplayColumn"])
});
}
dt_1 = clsDAC.Read_DT_Query("SELECT SubjectID, SubjectName FROM dbo.tblSubjects WHERE SubjectType <> 8 AND ISNULL(IsActive,1) = 1");
if (dt_1 != null)
{
ddlparentSubjects = dt_1.Rows.Cast <DataRow>().ToList().Select(x => new SelectListItem()
{
Value = Convert.ToString(x["SubjectID"]), Text = Convert.ToString(x["SubjectName"])
});
}
ViewBag.MainModel = modelSubjects;
ViewBag.ddSubjectTypelist = ddlSubjectType;
ViewBag.ddlparentSubjectslist = ddlparentSubjects;
return(View());
}
public JsonResult SaveUpdate(string Chapter)
{
dynamic clsChapter = JsonConvert.DeserializeObject(Chapter);
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectChapterID", (clsChapter.SubjectChapterID == "" ? 0 : (int)clsChapter.SubjectChapterID)),
new KeyValuePair <string, object>("SubjectID", (clsChapter.SubjectID == "" ? 0 : (int)clsChapter.SubjectID)),
new KeyValuePair <string, object>("ChapterCode", Convert.ToString(clsChapter.ChapterCode)),
new KeyValuePair <string, object>("ChapterName", Convert.ToString(clsChapter.ChapterName)),
new KeyValuePair <string, object>("CreatedBy", (int)Session["UserID"])
};
clsDAC.Execute_Procedure("sp_SubjectsChaptersCRUD", lstData);
ViewBag.Error = clsDAC.Error_Message;
List <object> lstChapters = new List <object>();
lstChapters = new SubjectsController().getChaptersBySubjectsID((int)clsChapter.SubjectID);
return(Json(lstChapters, JsonRequestBehavior.AllowGet));
}
public List <object> getExercisesByChapterID(int SubjectsChaptersID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <object> lstRet = new List <object>();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetExercises", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectsChaptersID", SubjectsChaptersID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
lstRet.Add(new
{
SubjectsChaptersID = (dr_1["SubjectsChaptersID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["SubjectsChaptersID"])),
ChapterCode = Convert.ToString(dr_1["ChapterCode"]),
ChapterName = Convert.ToString(dr_1["ChapterName"]),
ExerciseCode = Convert.ToString(dr_1["ExerciseCode"]),
ExerciseName = Convert.ToString(dr_1["ExerciseName"]),
ParentChapterID = (dr_1["ParentChapterID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["ParentChapterID"])),
SubjectID = Convert.ToInt32(dr_1["SubjectID"]),
SubjectName = Convert.ToString(dr_1["SubjectName"])
});
}
}
return(lstRet);
}
//---
public List <StudentsSubjects> getStudentSubjectsByID(int StudentID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <StudentsSubjects> clsStudentSubject = new List <StudentsSubjects>();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetStudentsSubjects", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("StudentID", StudentID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
clsStudentSubject.Add(new StudentsSubjects()
{
SubjectID = Convert.ToInt32(dr_1["SubjectID"]),
SubjectName = Convert.ToString(dr_1["SubjectName"]),
SubjectCode = Convert.ToString(dr_1["SubjectCode"]),
IsSelected = Convert.ToBoolean(dr_1["IsSelected"])
}
);
}
}
return(clsStudentSubject);
}
public List <QuestionPayment> getQuesionsFromPaymentQuestion_BySubjectsIDAndTransactionAndVarient(int SubjectID, string transactionid, string variant)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <QuestionPayment> lstRet = new List <QuestionPayment>();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetSubjectsAndQuestionFromQuestionPaymentBySubIdAndTransactionIDandVariantID", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectID", SubjectID), new KeyValuePair <string, object>("TransactionId", transactionid), new KeyValuePair <string, object>("Variant", variant)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
lstRet.Add(new QuestionPayment
{
questionid = Convert.ToInt32(dr_1["questionid"]),
subjbectid = Convert.ToInt32(dr_1["subjbectid"]),
transactionid = dr_1["transactionid"] == DBNull.Value ? "" : Convert.ToString(dr_1["transactionid"]),
variant = dr_1["variant"] == DBNull.Value ? "" : Convert.ToString(dr_1["variant"]),
create_date = Convert.ToDateTime(dr_1["create_date"])
});
}
}
return(lstRet);
}
public Questions GetQuestionByID(int QuestionID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
Questions clsQuestion = null;
dt_1 = clsDAC.Read_DT_Procedure("GetQuestionByID", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("QuestionID", QuestionID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
DataRow dr_1 = dt_1.Rows[0];
clsQuestion = new Questions()
{
ImageFileName = Convert.ToString(dr_1["ImageFileName"]),
SubjectsChaptersID = (dr_1["SubjectsChaptersID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["SubjectsChaptersID"])),
QuestionID = (dr_1["QuestionID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["QuestionID"])),
PaperYear = Convert.ToString(dr_1["PaperYear"]),
QuestionText = Convert.ToString(dr_1["QuestionText"]),
URL = Convert.ToString(dr_1["URL"]),
VideoFileName = Convert.ToString(dr_1["VideoFileName"]),
ImageFilePath = Convert.ToString(dr_1["ImageFilePath"]),
PdfDocFile = Convert.ToString(dr_1["PdfDocFile"]),
PdfDocFilePath = Convert.ToString(dr_1["PdfDocFilePath"]),
VideoFilePath = Convert.ToString(dr_1["VideoFilePath"]),
};
}
return(clsQuestion);
}
public ActionResult Exercises(FormCollection frmCollection)
{
verifySessionforAdmin();
int SubjectsChapterID = 0;
string Code = "";
string ExerciseName = "";
int ParentChapterID = 0;
if (string.IsNullOrEmpty(frmCollection["SubjectsChaptersID"]))
{
SubjectsChapterID = 0;
}
else
{
SubjectsChapterID = Convert.ToInt32(frmCollection["SubjectsChaptersID"]);
}
Code = Convert.ToString(frmCollection["ExerciseCode"]);
ExerciseName = Convert.ToString(frmCollection["ExerciseName"]);
ParentChapterID = Convert.ToInt32(frmCollection["ParentChapterID"]);
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectsChaptersID", SubjectsChapterID),
new KeyValuePair <string, object>("ExerciseCode", Code),
new KeyValuePair <string, object>("ExerciseName", ExerciseName),
new KeyValuePair <string, object>("ParentChapterID", ParentChapterID),
new KeyValuePair <string, object>("CreatedBy", Session["UserID"])
};
clsDAC.Execute_Procedure("sp_ExerciseCRUD", lstData);
ViewBag.Error = clsDAC.Error_Message;
List <object> lstRet = new List <object>();
lstRet = getExercisesByChapterID(ParentChapterID);
string ChapterName = "";
string SubjectName = "";
if (lstRet.Count() > 0)
{
var ChapterContentBasic = lstRet.FirstOrDefault();
ChapterName = Convert.ToString(ChapterContentBasic.GetType().GetProperty("ChapterName").GetValue(ChapterContentBasic));
SubjectName = Convert.ToString(ChapterContentBasic.GetType().GetProperty("SubjectName").GetValue(ChapterContentBasic));
}
ViewBag.ParentChapterID = ParentChapterID;
ViewBag.ChapterName = ChapterName;
ViewBag.SubjectName = SubjectName;
ViewBag.ExercisesList = lstRet;
return(View());
}
public ActionResult ChapterQuetionsEdit(int CHID, int SCID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
Questions question = new Questions();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetSubjectsChapterQuestionsByQuestionID", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("QuestionID", CHID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
question.QuestionID = Convert.ToInt32(dr_1["QuestionID"]);
question.URL = dr_1["URL"] == DBNull.Value ? "" : Convert.ToString(dr_1["URL"]);
question.SubjectsChaptersID = (dr_1["SubjectsChaptersID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["SubjectsChaptersID"]));
question.QuestionText = dr_1["QuestionText"] == DBNull.Value ? "" : Convert.ToString(dr_1["QuestionText"]);
question.ImageFileName = dr_1["ImageFileName"] == DBNull.Value ? "" : Convert.ToString(dr_1["ImageFileName"]);
question.VideoFileName = dr_1["VideoFileName"] == DBNull.Value ? "" : Convert.ToString(dr_1["VideoFileName"]);
question.PaperYear = dr_1["PaperYear"] == DBNull.Value ? "" : Convert.ToString(dr_1["PaperYear"]);
question.ImageFilePath = dr_1["ImageFilePath"] == DBNull.Value ? "" : Convert.ToString(dr_1["ImageFilePath"]);
question.PdfDocFile = dr_1["PdfDocFile"] == DBNull.Value ? "" : Convert.ToString(dr_1["PdfDocFile"]);
question.PdfDocFilePath = dr_1["PdfDocFilePath"] == DBNull.Value ? "" : Convert.ToString(dr_1["PdfDocFilePath"]);
question.VideoFilePath = dr_1["VideoFilePath"] == DBNull.Value ? "" : Convert.ToString(dr_1["VideoFilePath"]);
question.isfree = Convert.ToBoolean(dr_1["Isfree"]);
}
}
List <object> lstRet = new List <object>();
lstRet = new SubjectsController().getChapterContentsByID(SCID);
string ChapterName = "";
string SubjectName = "";
string SubjectType = "";
if (lstRet.Count() > 0)
{
var ChapterContentBasic = lstRet.FirstOrDefault();
ChapterName = Convert.ToString(ChapterContentBasic.GetType().GetProperty("ChapterName").GetValue(ChapterContentBasic));
SubjectName = Convert.ToString(ChapterContentBasic.GetType().GetProperty("SubjectName").GetValue(ChapterContentBasic));
SubjectType = Convert.ToString(ChapterContentBasic.GetType().GetProperty("SubjectType").GetValue(ChapterContentBasic));
}
ViewBag.SubjectsChaptersID = SCID;
ViewBag.ChapterName = ChapterName;
ViewBag.SubjectName = SubjectName;
ViewBag.SubjectType = SubjectType;
return(View(question));
}
public List <object> getChapterContentsByID(int SubjectsChaptersID)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <object> lstRet = new List <object>();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetChaptersContents_1", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectsChaptersID", SubjectsChaptersID)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
lstRet.Add(new
{
//RowNumber = Convert.ToInt32(dr_1["RowNumber"]),
//ContentsHolder = Convert.ToInt32(dr_1["ContentsHolder"]),
//SubjectsChaptersID = Convert.ToInt32(dr_1["SubjectsChaptersID"]),
//ChapterCode = Convert.ToString(dr_1["ChapterCode"]),
//ChapterName = Convert.ToString(dr_1["ChapterName"]),
//SubjectID = Convert.ToInt32(dr_1["SubjectID"]),
//SubjectName = Convert.ToString(dr_1["SubjectName"]),
//ContentFileName = Convert.ToString(dr_1["ContentFileName"]),
//OriginalFileName = Convert.ToString(dr_1["OriginalFileName"]),
//URL = Convert.ToString(dr_1["URL"]),
//QuestionText = Convert.ToString(dr_1["QuestionText"]),
RowNumber = Convert.ToInt32(dr_1["RowNumber"]),
ContentsHolder = Convert.ToInt32(dr_1["ContentsHolder"]),
SubjectsChaptersID = Convert.ToInt32(dr_1["SubjectsChaptersID"]),
ChapterCode = Convert.ToString(dr_1["ChapterCode"]),
ChapterName = Convert.ToString(dr_1["ChapterName"]),
SubjectID = Convert.ToInt32(dr_1["SubjectID"]),
SubjectName = Convert.ToString(dr_1["SubjectName"]),
ImageFileName = Convert.ToString(dr_1["ImageFileName"]),
VideoFileName = Convert.ToString(dr_1["VideoFileName"]),
PdfDocFile = Convert.ToString(dr_1["PdfDocFile"]),
// OriginalFileName = Convert.ToString(dr_1["OriginalFileName"]),
URL = Convert.ToString(dr_1["URL"]),
QuestionText = Convert.ToString(dr_1["QuestionText"]),
SubjectType = Convert.ToString(dr_1["SubjectType"]),
ImageFilePath = Convert.ToString(dr_1["ImageFilePath"]),
VideoFilePath = Convert.ToString(dr_1["VideoFilePath"]),
PdfDocFilePath = Convert.ToString(dr_1["PdfDocFilePath"]),
PaperYear = Convert.ToString(dr_1["PaperYear"])
});
ViewBag.SubjectsChaptersID = SubjectsChaptersID;
}
}
return(lstRet);
}
public int DeletePayPalInvoice(string TID)
{
var clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("InvoiceGUID", TID)
};
return(clsDAC.Execute_Procedure("sp_DeletePayPalInvoice", lstData));
}
public int LogException(string InvoiceGUID, string ExceptionXML)
{
var clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("InvoiceGUID", InvoiceGUID),
new KeyValuePair <string, object>("QuestionID", ExceptionXML)
};
return(clsDAC.Execute_Procedure("sp_SavePayPalExecutePaymentException", lstData));
}
public int UpdatePayPalInvoice(PayPalInvoiceModel payPalInvoiceModel)
{
var clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("InvoiceGUID", payPalInvoiceModel.InvoiceGUID),
new KeyValuePair <string, object>("State", payPalInvoiceModel.State),
new KeyValuePair <string, object>("ResponseXML", payPalInvoiceModel.ResponseXML),
};
return(clsDAC.Execute_Procedure("sp_UpdatePayPalInvoice", lstData));
}
public int CreatePayPalInvoice(PayPalInvoiceModel payPalInvoiceModel)
{
var clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("InvoiceGUID", payPalInvoiceModel.InvoiceGUID),
new KeyValuePair <string, object>("QuestionID", payPalInvoiceModel.QuestionID),
new KeyValuePair <string, object>("PaymentID", payPalInvoiceModel.PaymentID),
new KeyValuePair <string, object>("RequestXML", payPalInvoiceModel.RequestXML),
};
return(clsDAC.Execute_Procedure("sp_SavePayPalInvoice", lstData));
}
public void DeleteInvoiceFromPaymentQuestion(string TID)
{
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("TID", TID)
};
clsDAC.Execute_Procedure("sp_DeletePaymentQuestionAgaintsTid", lstData);
ViewBag.Error = clsDAC.Error_Message;
}
public void QuestionPaymentSave(QuestionPayment questionPayment)
{
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("subjbectid", questionPayment.subjbectid),
new KeyValuePair <string, object>("questionid", questionPayment.questionid),
new KeyValuePair <string, object>("transactionid", questionPayment.transactionid),
new KeyValuePair <string, object>("variant", questionPayment.variant)
};
clsDAC.Execute_Procedure("sp_PaymentQuestionSave", lstData);
ViewBag.Error = clsDAC.Error_Message;
}
public ActionResult ExercisesDelete(int ID, int ParentID)
{
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectsChaptersID", ID),
new KeyValuePair <string, object>("Mode", "Delete"),
new KeyValuePair <string, object>("CreatedBy", Session["UserID"])
};
clsDAC.Execute_Procedure("sp_ExerciseCRUD", lstData);
ViewBag.Error = clsDAC.Error_Message;
Response.Redirect("~/Chapters/Exercises?ID=" + ParentID);
return(View());
}
public ActionResult PasswordReset(Login modelLogin)
{
List <object> lstModels = new List <object>();
List <KeyValuePair <string, object> > lstData;
DataTable dt_1 = null;
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("UserName", Session["UserName"].ToString()),
new KeyValuePair <string, object>("UserPassword", Convert.ToBase64String(System.Text.ASCIIEncoding.ASCII.GetBytes(modelLogin.Password)))
};
dt_1 = clsDAC.Read_DT_Procedure("sp_update_login_password", lstData);
return(View("Index"));
}
public ActionResult AboutUs()
{
List <object> lstVisitors = new List <object>();
DataTable dt_1 = null;
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
dt_1 = clsDAC.Read_DT_Query("SELECT Id,VisitingTime FROM tblVisitor");
if (dt_1 != null || dt_1.Rows.Count != 0)
{
foreach (DataRow item in dt_1.Rows)
{
lstVisitors.Add(new { ID = Convert.ToInt32(item["Id"]), VisitingTime = Convert.ToDateTime(item["VisitingTime"]) });
}
}
return(View(lstVisitors));
}
public List <Questions> getChaptersQuesionsBySubjectsIDAndVariant(int SubjectID, string variant)
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <Questions> lstRet = new List <Questions>();
dt_1 = clsDAC.Read_DT_Procedure("sp_GetSubjectsChapterQuestionsByQuestionIDAndVariant", new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectID", SubjectID), new KeyValuePair <string, object>("variant", variant)
});
if (dt_1 != null || dt_1.Rows.Count > 0)
{
foreach (DataRow dr_1 in dt_1.Rows)
{
lstRet.Add(new Questions
{
QuestionID = Convert.ToInt32(dr_1["QuestionID"]),
URL = dr_1["URL"] == DBNull.Value ? "" : Convert.ToString(dr_1["URL"]),
SubjectsChaptersID = (dr_1["SubjectsChaptersID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["SubjectsChaptersID"])),
QuestionText = dr_1["QuestionText"] == DBNull.Value ? "" : Convert.ToString(dr_1["QuestionText"]),
ImageFileName = dr_1["ImageFileName"] == DBNull.Value ? "" : Convert.ToString(dr_1["ImageFileName"]),
VideoFileName = dr_1["VideoFileName"] == DBNull.Value ? "" : Convert.ToString(dr_1["VideoFileName"]),
PaperYear = dr_1["PaperYear"] == DBNull.Value ? "" : Convert.ToString(dr_1["PaperYear"]),
ImageFilePath = dr_1["ImageFilePath"] == DBNull.Value ? "" : Convert.ToString(dr_1["ImageFilePath"]),
PdfDocFile = dr_1["PdfDocFile"] == DBNull.Value ? "" : Convert.ToString(dr_1["PdfDocFile"]),
PdfDocFilePath = dr_1["PdfDocFilePath"] == DBNull.Value ? "" : Convert.ToString(dr_1["PdfDocFilePath"]),
VideoFilePath = dr_1["VideoFilePath"] == DBNull.Value ? "" : Convert.ToString(dr_1["VideoFilePath"]),
isfree = Convert.ToBoolean(dr_1["Isfree"]),
subID = (dr_1["SubjectID"] == DBNull.Value ? 0 : Convert.ToInt32(dr_1["SubjectID"])),
});
}
}
return(lstRet);
}
public int Logout()
{
DataTable dt_1 = null;
MSSQL_DAC clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("LoginID", Convert.ToString(Session["LoginID"]))
};
dt_1 = clsDAC.Read_DT_Procedure("sp_Logout", lstData);
if (Session.SessionID != null)
{
Session.Clear();
Session.Abandon();
}
Response.Redirect("/Home/Index");
return(1);
}
public JsonResult SaveDelete(int SubjectChapterID, int SubjectID)
{
//dynamic clsChapter = JsonConvert.DeserializeObject(Chapter);
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectChapterID", SubjectChapterID),
new KeyValuePair <string, object>("CreatedBy", (int)Session["UserID"])
};
clsDAC.Execute_Procedure("sp_SubjectsChaptersDelete", lstData);
ViewBag.Error = clsDAC.Error_Message;
List <object> lstChapters = new List <object>();
lstChapters = new SubjectsController().getChaptersBySubjectsID(SubjectID);
return(Json(lstChapters, JsonRequestBehavior.AllowGet));
}
