//---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);
}
//---
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 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);
}
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);
}
//---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 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);
}
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 <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 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 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);
}
//---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);
}
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 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 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 ActionResult ChapterQuetionsEdit(FormCollection frmCollection)
{
var ImageFileName = ""; //using this field to save variant value
var VideoFileName = "";
var PdfFileName = "";
var ImageFilePath = "";
var VideoFilePath = "";
var PdfFilePath = "";
var isfree = false;
var PaperYear = "";
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
List <string> FilesAlreadyLoaded = new List <string>();
int SubjectChapterID = 0;
int QuestionID = 0;
isfree = Convert.ToBoolean(frmCollection["Isfree"]);
Int32.TryParse(Convert.ToString(frmCollection["SubjectChapterID"]), out SubjectChapterID);
Int32.TryParse(Convert.ToString(frmCollection["QuestionID"]), out QuestionID);
if (!string.IsNullOrEmpty(frmCollection["PaperYear"]))
{
PaperYear = Convert.ToString(frmCollection["PaperYear"]);
}
if (!string.IsNullOrEmpty(frmCollection["QuestionDiagram"]))
{
ImageFileName = Convert.ToString(frmCollection["QuestionDiagram"]);
}
if (Request.Files.Count > 0)
{
for (int updFile = 0; updFile < Request.Files.Count; updFile++)
{
//string ContentFileName = Convert.ToString(dt_1.Rows[0]["ContentFileName"]);
var supportedFile = false;
HttpPostedFileBase postedFile = Request.Files[updFile];
var fileName = postedFile.FileName;
var fileExtension = System.IO.Path.GetExtension(fileName).ToLower();
System.Guid Guid = System.Guid.NewGuid();
var guidStr = Guid.ToString() + fileExtension;
if (fileExtension == ".mp4")
{
supportedFile = true;
VideoFileName = fileName;
VideoFilePath = guidStr;
}
//else if (fileExtension == ".png" || fileExtension == ".jpg" || fileExtension == ".jpeg")
//{
// supportedFile = true;
// ImageFileName = fileName;
// ImageFilePath = guidStr;
//}
else if (fileExtension == ".pdf")
{
supportedFile = true;
PdfFileName = fileName;
PdfFilePath = guidStr;
}
if (supportedFile)
{
fileName = guidStr; //System.IO.Path.GetFileName(fileName);
System.IO.MemoryStream mem = new System.IO.MemoryStream();
var path = System.IO.Path.Combine(Server.MapPath("~/ContentStorage/ChaptersContents/"), fileName);
// postedFile.InputStream.CopyTo(mem);
// System.IO.File.WriteAllBytes(System.IO.Path.Combine(Server.MapPath("~/ContentStorage/ChaptersContents/"), fileName), mem.ToArray());
//
postedFile.SaveAs(path);
}
}
}
{
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("QuestionID", QuestionID),
new KeyValuePair <string, object>("SubjectsChaptersID", SubjectChapterID),
new KeyValuePair <string, object>("Url", frmCollection["youTubeUrl"]),
new KeyValuePair <string, object>("CreatedBy", Session["UserID"]),
new KeyValuePair <string, object>("QuestionText", frmCollection["questionText"]),
new KeyValuePair <string, object>("ImageFileName", ImageFileName),
new KeyValuePair <string, object>("VideoFileName", VideoFileName),
new KeyValuePair <string, object>("PaperYear", PaperYear),
new KeyValuePair <string, object>("PdfDocFile", PdfFileName),
new KeyValuePair <string, object>("ImageFilePath", ImageFilePath),
new KeyValuePair <string, object>("VideoFilePath", VideoFilePath),
new KeyValuePair <string, object>("PdfDocFilePath", PdfFilePath),
new KeyValuePair <string, object>("Isfree", isfree),
};
DataTable dt_1 = clsDAC.Read_DT_Procedure("sp_SaveChaptersQuestions", lstData);
ViewBag.Error = clsDAC.Error_Message;
}
return(View());
}
public ActionResult ChapterContents(FormCollection frmCollection, int ID = 0, int page = 1)
{
verifySessionforAdmin();
var ImageFileName = ""; //using this field to save variant value
var VideoFileName = "";
var PdfFileName = "";
var ImageFilePath = "";
var VideoFilePath = "";
var PdfFilePath = "";
var isfree = false;
var PaperYear = "";
MSSQL_DAC clsDAC = null;
clsDAC = new MSSQL_DAC();
List <string> FilesAlreadyLoaded = new List <string>();
int SubjectChapterID = 0;
isfree = Convert.ToBoolean(frmCollection["Isfree"]);
Int32.TryParse(Convert.ToString(frmCollection["SubjectChapterID"]), out SubjectChapterID);
if (!string.IsNullOrEmpty(frmCollection["PaperYear"]))
{
PaperYear = Convert.ToString(frmCollection["PaperYear"]);
}
if (!string.IsNullOrEmpty(frmCollection["QuestionDiagram"]))
{
ImageFileName = Convert.ToString(frmCollection["QuestionDiagram"]);
}
if (Request.Files.Count > 0)
{
for (int updFile = 0; updFile < Request.Files.Count; updFile++)
{
//string ContentFileName = Convert.ToString(dt_1.Rows[0]["ContentFileName"]);
var supportedFile = false;
HttpPostedFileBase postedFile = Request.Files[updFile];
var fileName = postedFile.FileName;
var fileExtension = System.IO.Path.GetExtension(fileName).ToLower();
System.Guid Guid = System.Guid.NewGuid();
var guidStr = Guid.ToString() + fileExtension;
if (fileExtension == ".mp4")
{
supportedFile = true;
VideoFileName = fileName;
VideoFilePath = guidStr;
}
//else if (fileExtension == ".png" || fileExtension == ".jpg" || fileExtension == ".jpeg")
//{
// supportedFile = true;
// ImageFileName = fileName;
// ImageFilePath = guidStr;
//}
else if (fileExtension == ".pdf")
{
supportedFile = true;
PdfFileName = fileName;
PdfFilePath = guidStr;
}
if (supportedFile)
{
fileName = guidStr; //System.IO.Path.GetFileName(fileName);
System.IO.MemoryStream mem = new System.IO.MemoryStream();
var path = System.IO.Path.Combine(Server.MapPath("~/ContentStorage/ChaptersContents/"), fileName);
// postedFile.InputStream.CopyTo(mem);
// System.IO.File.WriteAllBytes(System.IO.Path.Combine(Server.MapPath("~/ContentStorage/ChaptersContents/"), fileName), mem.ToArray());
//
postedFile.SaveAs(path);
}
}
}
{
List <KeyValuePair <string, object> > lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("SubjectsChaptersID", SubjectChapterID),
new KeyValuePair <string, object>("Url", frmCollection["youTubeUrl"]),
new KeyValuePair <string, object>("CreatedBy", Session["UserID"]),
new KeyValuePair <string, object>("QuestionText", frmCollection["questionText"]),
new KeyValuePair <string, object>("ImageFileName", ImageFileName),
new KeyValuePair <string, object>("VideoFileName", VideoFileName),
new KeyValuePair <string, object>("PaperYear", PaperYear),
new KeyValuePair <string, object>("PdfDocFile", PdfFileName),
new KeyValuePair <string, object>("ImageFilePath", ImageFilePath),
new KeyValuePair <string, object>("VideoFilePath", VideoFilePath),
new KeyValuePair <string, object>("PdfDocFilePath", PdfFilePath),
new KeyValuePair <string, object>("Isfree", isfree),
};
DataTable dt_1 = clsDAC.Read_DT_Procedure("sp_SaveChaptersQuestions", lstData);
ViewBag.Error = clsDAC.Error_Message;
}
//if (Request.Files.Count > 0)
//{
// for (int updFile = 0; updFile < Request.Files.Count; updFile++)
// {
// List<KeyValuePair<string, object>> lstData = new List<KeyValuePair<string, object>>()
// {
// new KeyValuePair<string,object>("SubjectsChaptersID",SubjectChapterID),
// new KeyValuePair<string,object>("OriginalFileName",Request.Files[updFile].FileName),
// new KeyValuePair<string,object>("CreatedBy",Session["UserID"])
// };
// DataTable dt_1 = clsDAC.Read_DT_Procedure("sp_SaveChaptersContents", lstData);
// ViewBag.Error = clsDAC.Error_Message;
// if (dt_1 != null || dt_1.Rows.Count > 0)
// {
// if (Convert.ToBoolean(dt_1.Rows[0]["IsAlreadyLoaded"]))
// {
// FilesAlreadyLoaded.Add(Convert.ToString(dt_1.Rows[0]["OriginalFileName"]));
// }
// else
// {
// string ContentFileName = Convert.ToString(dt_1.Rows[0]["ContentFileName"]);
// HttpPostedFileBase postedFile = Request.Files[updFile];
// System.IO.MemoryStream mem = new System.IO.MemoryStream();
// postedFile.InputStream.CopyTo(mem);
// System.IO.File.WriteAllBytes(Server.MapPath("/ContentStorage/ChaptersContents/") + ContentFileName, mem.ToArray());
// }
// }
// }
//}
List <object> lstRet = new List <object>();
lstRet = new SubjectsController().getChapterContentsByID(SubjectChapterID);
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.SubjectsChaptersID = SubjectChapterID;
ViewBag.ChapterName = ChapterName;
ViewBag.SubjectName = SubjectName;
ViewBag.ChapterContentsList = lstRet;
ViewBag.FilesAlreadyLoaded = FilesAlreadyLoaded;
ViewBag.SubjectsChaptersID = ID;
//////////Response.Redirect(string.Format("~/Chapters/ChapterContents?ID={0}", SubjectChapterID));
////RedirectToAction(string.Format("ChapterContents?ID={0}", SubjectChapterID));
// return View(SubjectChapterID);
return(RedirectToAction("ChapterContents", new { ID = SubjectChapterID }));
}
public ActionResult Index(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();
ViewBag.TotalVisitors = Session["TotalVisitors"] == null ? 0 : Convert.ToInt32(Session["TotalVisitors"]);
//---Getting Subjects
List <Subjects> modelSubjectsList = new SubjectsController().getSubjects();
Session["UserName"] = modelLogin.UserName;
//---Login
lstData = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("UserName", modelLogin.UserName),
new KeyValuePair <string, object>("UserPassword", Convert.ToBase64String(System.Text.ASCIIEncoding.ASCII.GetBytes(modelLogin.Password))),
new KeyValuePair <string, object>("IPAddress", System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName()).AddressList.Where(item => item.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork).FirstOrDefault().ToString())
};
dt_1 = clsDAC.Read_DT_Procedure("sp_Login", lstData);
if (dt_1 == null || dt_1.Rows.Count == 0)
{
modelLogin.LoginStatus = "Login Failed: Unable to access";
modelLogin.LoginStatusCode = "0";
}
else if (dt_1 != null && dt_1.Rows.Count > 0)
{
modelLogin.userID = Convert.ToInt32(dt_1.Rows[0]["UserID"]);
modelLogin.LoginStatusCode = Convert.ToString(dt_1.Rows[0]["LoginStatusCode"]);
modelLogin.LoginStatus = Convert.ToString(dt_1.Rows[0]["LoginStatus"]);
modelLogin.IPAddress = System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName()).AddressList.Where(item => item.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork).FirstOrDefault().ToString();
modelLogin.LoginTimeStamp = Convert.ToDateTime(dt_1.Rows[0]["LoginTimeStamp"]);
}
if (modelLogin.LoginStatusCode != "1")
{
lstModels.Add(modelLogin);
lstModels.Add(modelSubjectsList);
return(View("Index", "~/Views/Shared/_IndexPageLayout.cshtml", lstModels));
}
Session["LoginID"] = Convert.ToInt32(dt_1.Rows[0]["LoginID"]);
Session["UserID"] = modelLogin.userID;
Session["UserName"] = modelLogin.UserName;
Session["UserType"] = Convert.ToString(dt_1.Rows[0]["UserType"]);
Session["UserFirstName"] = Convert.ToString(dt_1.Rows[0]["FirstName"]);
Session["UserLastName"] = Convert.ToString(dt_1.Rows[0]["LastName"]);
Session["LoginTimeStamp"] = Convert.ToDateTime(modelLogin.LoginTimeStamp);
Session["StudentID"] = Convert.ToString(dt_1.Rows[0]["StudentID"]) == "" ? 0 : Convert.ToInt32(dt_1.Rows[0]["StudentID"]);
if (Convert.ToString(dt_1.Rows[0]["UserType"]) == "Admin")
{
Response.Redirect("~/Admin/Index");
}
else if (Convert.ToString(dt_1.Rows[0]["UserType"]) == "User")
{
Response.Redirect("~/User/Index");
}
lstModels.Add(modelLogin);
lstModels.Add(modelSubjectsList);
return(View("Index", "~/Views/Shared/_IndexPageLayout.cshtml", lstModels));
}
