//---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)); }