public ActionResult Index()
{
verifySessionforAdmin();
List <Subjects> lstSubject = new SubjectsController().getSubjects();
List <SelectListItem> lstSubjectsDropDown = new List <SelectListItem>();
var varlstSubject = lstSubject.Select(item => new { item.SubjectName, item.SubjectID });
lstSubjectsDropDown.Add(new SelectListItem()
{
Text = "Select Subject", Value = "0"
});
foreach (var item in varlstSubject)
{
lstSubjectsDropDown.Add(new SelectListItem()
{
Text = item.SubjectName, Value = item.SubjectID.ToString()
});
}
ViewBag.SubjectLookup = lstSubjectsDropDown;
return(View());
}
public ActionResult ChaptersDetails(int SubChapID)
{
List <object> lstRet = new List <object>();
lstRet = new SubjectsController().getChapterContentsByID(SubChapID);
return(View(lstRet));
}
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 JsonResult GetChaptersBySubjectID(int SubjectID)
{
List <object> lstChapters = new List <object>();
lstChapters = new SubjectsController().getChaptersBySubjectsID(SubjectID);
//lstChapters.Add(new { SubjectChaptersID = 1, ChapterCode = "P1-1", ChapterName = "Quadratics", SubjectID = 3 });
return(Json(lstChapters, JsonRequestBehavior.AllowGet));
}
public ActionResult CSSTopic(int subID = 0)
{
List <object> lstRet = new SubjectsController().getChapterContentsQuestionBySubjectID(subID);
ViewBag.PastPapers = lstRet;
return(View(lstRet));
}
public ActionResult PaymentWithStripe(string Cancel = null, string subID = null, string questionId = null, string SubChapID = null, string exerciseId = null, string isPastPaper = null, string variant = null)
{
StripeTransactionModel md = new StripeTransactionModel();
//getting the apiContext
System.Guid guid = System.Guid.NewGuid();
var transactionid = guid.ToString();
var paymentSession = this.CreatePaymentSession(transactionid, questionId, subID, SubChapID, exerciseId, isPastPaper, variant);
PayPalInvoiceModel model = new PayPalInvoiceModel();
model.InvoiceGUID = transactionid;
model.QuestionID = int.Parse(subID);
model.RequestXML = "Stripe Payment With Session Id = " + paymentSession.Id;
model.PaymentID = paymentSession.Id;
PayPalManager payPalManager = new PayPalManager();
payPalManager.CreatePayPalInvoice(model);
if (variant == null)
{
List <Questions> lstRet = new SubjectsController().getChaptersQuesionsBySubjectsID(int.Parse(subID));
QuestionPayment qp = new QuestionPayment();
qp.questionid = int.Parse(questionId);
qp.subjbectid = int.Parse(subID);
qp.transactionid = transactionid;
qp.variant = variant;
ChaptersController questionpayment = new ChaptersController();
questionpayment.QuestionPaymentSave(qp);
}
else
{
QuestionPayment qp = new QuestionPayment();
qp.questionid = int.Parse(questionId);
qp.subjbectid = int.Parse(subID);
qp.transactionid = transactionid;
qp.variant = variant;
ChaptersController questionpayment = new ChaptersController();
questionpayment.QuestionPaymentSave(qp);
}
md.session = paymentSession;
md.sessionid = paymentSession.Id;
var StripePublishablekey = ConfigurationManager.AppSettings["StripePublishablekey"].ToString();
md.StripePublishablekey = StripePublishablekey;
return(View(md));
}
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));
}
// GET: Chapters
public ActionResult Chapters(int Sub)
{
if (Session["LoginID"] == null || Convert.ToString(Session["LoginID"]) == "")
{
Response.Redirect("~/Home/Index");
}
List <SubjectChapters> lstRet = new SubjectsController().getChaptersExerciseBySubjectsID(Sub);
return(View(lstRet));
}
public ActionResult ChaptersDetails(int SubChapID)
{
if (Session["LoginID"] == null || Convert.ToString(Session["LoginID"]) == "")
{
Response.Redirect("~/Home/Index");
}
List <object> lstRet = new List <object>();
lstRet = new SubjectsController().getChapterContentsByID(SubChapID);
return(View(lstRet));
}
public ActionResult Chapters(int Sub, int IsTopical)
{
ChaptersViewModel vm = new ChaptersViewModel();
List <SubjectChapters> lstRet = new SubjectsController().getChaptersExerciseBySubjectsID(Sub);
List <Questions> lstRet1 = new SubjectsController().getChaptersQuesionsBySubjectsID(Sub);
vm.SubjectChapters = lstRet;
vm.Questions = lstRet1;
ViewBag.IsTopical = IsTopical;
return(View(vm));
}
public ActionResult ChapterContents(int ID)
{
verifySessionforAdmin();
if (Request.QueryString["ID"] != null)
{
QueryChapterContentID = Convert.ToInt32(Request.QueryString["ID"]);
}
if (ID > 0)
{
QueryChapterContentID = ID;
}
List <object> lstRet = new List <object>();
lstRet = new SubjectsController().getChapterContentsByID(QueryChapterContentID);
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 = QueryChapterContentID;
ViewBag.ChapterName = ChapterName;
ViewBag.SubjectName = SubjectName;
ViewBag.SubjectType = SubjectType;
if (lstRet != null && lstRet.Count == 1)
{
var ChapterContentBasic = lstRet.FirstOrDefault();
var ContentsHolder = Convert.ToString(ChapterContentBasic.GetType().GetProperty("ContentsHolder").GetValue(ChapterContentBasic));
if (ContentsHolder == "0")
{
lstRet.RemoveAt(0);
}
}
ViewBag.ChapterContentsList = lstRet;
return(View());
}
public ActionResult Index()
{
List <object> lstModels = new List <object>();
lstModels.Add(new Login());
List <Subjects> modelSubjectsList = new SubjectsController().getSubjects();
List <Subjects> modelSubjectsTopicsList = new SubjectsController().getSubjectTopics();
lstModels.Add(modelSubjectsList);
lstModels.Add(modelSubjectsTopicsList);
if (Session["EmailSent"] == null)
{
try
{
MVCSlider.App_Code.ExtensionMethods.SendMail();
Session["EmailSent"] = "Sent";
}
catch
{
}
}
if (Session["TotalVisitors"] == null)
{
try
{
int Counter = MVCSlider.DAC.MSSQL_DAC.SaveVisitor();
Session["TotalVisitors"] = Counter;
ViewBag.TotalVisitors = Counter;
}
catch
{
ViewBag.TotalVisitors = 0;
}
}
else
{
ViewBag.TotalVisitors = Session["TotalVisitors"] == null ? 0 : Convert.ToInt32(Session["TotalVisitors"]);
}
return(View("Index", "~/Views/Shared/_IndexPageLayout.cshtml", lstModels));
}
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));
}
public ActionResult PaymentWithPaypal(string Cancel = null, string subID = null
, string questionId = null,
string SubChapID = null, string exerciseId = null, string isPastPaper = null, string variant = null
)
{
//var smtp = new SmtpClient
try
{
//Create the msg object to be sent
MailMessage msg = new MailMessage();
//Add your email address to the recipients
msg.To.Add("*****@*****.**");
//Configure the address we are sending the mail from
MailAddress address = new MailAddress("*****@*****.**");
msg.From = address;
msg.Subject = "Clicked On Paypal Button on date time " + DateTime.Now;
msg.Body = "Clicked On Paypal Button on date time " + DateTime.Now;
SmtpClient client = new SmtpClient();
client.Host = "relay-hosting.secureserver.net";
client.Port = 25;
//Setup credentials to login to our sender email address ("UserName", "Password")
client.UseDefaultCredentials = false;
NetworkCredential credentials = new NetworkCredential("*****@*****.**", "asjad001$");
client.Credentials = credentials;
//Send the msg
client.Send(msg);
//Display some feedback to the user to let them know it was sent
//lblResult.Text = "Your message was sent!";
}
catch (Exception ex)
{
//If the message failed at some point, let the user know
//lblResult.Text = ex.ToString(); //alt text "Your message failed to send, please try again."
}
//getting the apiContext
APIContext apiContext = PaypalConfiguration.GetAPIContext();
var transactionid = "";
try
{
//A resource representing a Payer that funds a payment Payment Method as paypal
//Payer Id will be returned when payment proceeds or click to pay
string payerId = Request.Params["PayerID"];
if (string.IsNullOrEmpty(payerId))
{
//this section will be executed first because PayerID doesn't exist
//it is returned by the create function call of the payment class
// Creating a payment
// baseURL is the url on which paypal sendsback the data.
// string baseURI = Request.Url.Scheme + "://" + Request.Url.Authority + "/PayPal/PaymentWithPayPal?";
string baseURI = GetBaseUrl() + "/PayPal/PaymentWithPayPal?";
//here we are generating guid for storing the paymentID received in session
//which will be used in the payment execution
System.Guid guid1 = System.Guid.NewGuid();
var guid = guid1.ToString();
//CreatePayment function gives us the payment approval url
//on which payer is redirected for paypal account payment
var createdPayment = this.CreatePayment(apiContext, baseURI + "guid=" + guid, guid, questionId
, subID, SubChapID, exerciseId, isPastPaper
);
//get links returned from paypal in response to Create function call
var links = createdPayment.links.GetEnumerator();
string paypalRedirectUrl = null;
while (links.MoveNext())
{
Links lnk = links.Current;
if (lnk.rel.ToLower().Trim().Equals("approval_url"))
{
//saving the payapalredirect URL to which user will be redirected for payment
paypalRedirectUrl = lnk.href;
}
}
// saving the paymentID in the key guid
string paymentXML = Utility.Serialize <Payment>(createdPayment);
PayPalManager payPalManager = new PayPalManager();
PayPalInvoiceModel model = new PayPalInvoiceModel();
model.InvoiceGUID = guid;
model.QuestionID = int.Parse(questionId);
model.RequestXML = paymentXML;
model.PaymentID = createdPayment.id;
if (variant == null)
{
List <Questions> lstRet = new SubjectsController().getChaptersQuesionsBySubjectsID(int.Parse(subID));
QuestionPayment qp = new QuestionPayment();
qp.questionid = int.Parse(questionId);
qp.subjbectid = int.Parse(subID);
qp.transactionid = transactionid;
qp.variant = variant;
ChaptersController questionpayment = new ChaptersController();
questionpayment.QuestionPaymentSave(qp);
}
else
{
QuestionPayment qp = new QuestionPayment();
qp.questionid = int.Parse(questionId);
qp.subjbectid = int.Parse(subID);
qp.transactionid = transactionid;
qp.variant = variant;
ChaptersController questionpayment = new ChaptersController();
questionpayment.QuestionPaymentSave(qp);
}
payPalManager.CreatePayPalInvoice(model);
// Session.Add(guid, createdPayment.id);
return(Redirect(paypalRedirectUrl));
}
else
{
PayPalManager payPalManager = new PayPalManager();
// This function exectues after receving all parameters for the payment
var guid = Request.Params["guid"];
transactionid = guid;
try
{
var invoice = payPalManager.GetPayPalInvoiceByGUID(guid);
if (invoice != null)
{
var executedPayment = ExecutePayment(apiContext, payerId, invoice.PaymentID as string);
var response = Utility.Serialize <Payment>(executedPayment);
invoice.State = executedPayment.state;
invoice.ResponseXML = response;
payPalManager.UpdatePayPalInvoice(invoice);
if (executedPayment.state.ToLower() != "approved")
{
return(RedirectToAction("Index", "Home"));
// return View("FailureView");
}
}
else
{
return(RedirectToAction("Index", "Home"));
// return View("FailureView");
}
}
catch (Exception ex)
{
var exception = Utility.Serialize <Exception>(ex);
payPalManager.LogException(guid, exception);
return(RedirectToAction("Index", "Home"));
}
//If executed payment failed then we will show payment failure message to user
}
}
catch (Exception ex)
{
//return View("FailureView");
return(RedirectToAction("Index", "Home"));
}
//on successful payment, show success page to user.
if (isPastPaper != null && isPastPaper == "1")
{
TempData["paymentTransactionId"] = transactionid;
return(RedirectToAction("ChapterQuestions", "Home", new { sub = subID, questionYearId = questionId, scfp = true }));
// return RedirectToAction("ShowVideoPastPaper", "Home", new { subID = subID, questionId = questionId, transactionid = transactionid });
}
else
{
return(RedirectToAction("ShowVideo", "Home", new { SubChapID = SubChapID, questionId = questionId, exerciseId = exerciseId, transactionid = transactionid }));
}
}
public ActionResult ChapterContent(int subID = 0)
{
List <object> lstRet = new SubjectsController().getChapterContentsQuestionBySubjectID(subID);
return(View(lstRet));
}
// public ActionResult ShowVideo(int SubChapID, string name)
public ActionResult ShowVideo(int SubChapID, int questionId, int exerciseId, string transactionid
, string session_id = null, bool isdwn = false
)
{
if (TempData["paymentTransactionId"] != null)
{
PayPalManager payPalManager = new PayPalManager();
var invoice = payPalManager.GetPayPalInvoiceByGUID(Convert.ToString(TempData["paymentTransactionId"]));
if (invoice != null)
{
if (invoice.QuestionID != SubChapID)
{
ViewBag.paymentTransactionId = null;
}
else
{
ViewBag.paymentTransactionId = TempData["paymentTransactionId"];
}
}
//TempData.Keep("paymentTransactionId");
}
if (string.IsNullOrEmpty(transactionid))
{
if (isdwn == true)
{
List <Questions> Question = new SubjectsController().getChaptersQuesionsByQuestionID(questionId);
if (Question.Select(x => x.isfree).FirstOrDefault() == true)
{
var showVideoViewModel1 = new SubjectsController().getShowVideoViewModelByID(SubChapID).FirstOrDefault();
var Exercises1 = new SubjectsController().getShowVideoViewModelByID(exerciseId);
var question1 = Exercises1.Where(x => x.ContentsHolder == questionId).FirstOrDefault();
ViewBag.Path = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(question1.VideoFilePath);
showVideoViewModel1.ExerciseName = Exercises1.FirstOrDefault().ChapterName;
showVideoViewModel1.QuestionText = question1.QuestionText;
string downloadURL1 = GetBaseUrl() + "/Home/DownloadQuestion?p1=" + questionId;
ViewBag.DownloadURL = downloadURL1;
ViewBag.transactionid = transactionid;
return(View("ShowVideo", "~/Views/Shared/_IndexPageLayout.cshtml", showVideoViewModel1));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return
(RedirectToAction("Index", "Home"));
}
}
else
{
PayPalManager payPalManager = new PayPalManager();
var invoice = payPalManager.GetPayPalInvoiceByGUID(transactionid);
if (invoice != null && invoice.RequestXML.ToLower().Contains("stripe payment"))
{
if (invoice.QuestionID != questionId && session_id != invoice.PaymentID)
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
if (invoice == null || invoice.QuestionID != questionId || invoice.State != "approved")
{
return(RedirectToAction("Index", "Home"));
}
}
}
var showVideoViewModel = new SubjectsController().getShowVideoViewModelByID(SubChapID).FirstOrDefault();
var Exercises = new SubjectsController().getShowVideoViewModelByID(exerciseId);
var question = Exercises.Where(x => x.ContentsHolder == questionId).FirstOrDefault();
ViewBag.Path = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(question.VideoFilePath);
showVideoViewModel.ExerciseName = Exercises.FirstOrDefault().ChapterName;
showVideoViewModel.QuestionText = question.QuestionText;
string downloadURL = GetBaseUrl() + "/Home/DownloadQuestion?p1=" + questionId;
ViewBag.DownloadURL = downloadURL;
ViewBag.transactionid = transactionid;
try
{
string strURL = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(question.VideoFilePath);
//string strFileName = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(videoFileName);
WebClient req = new WebClient();
HttpResponse response = System.Web.HttpContext.Current.Response;
response.Clear();
response.ClearContent();
response.ClearHeaders();
response.Buffer = true;
response.AddHeader("Content-Disposition", "attachment;filename=\"" + Server.MapPath(strURL) + "\"");
//response.AppendHeader("Content-Disposition", "attachment; filename=" + subjectName +" "+ chapterName + " " + questionText + "");
byte[] data = req.DownloadData(Server.MapPath(strURL));
response.BinaryWrite(data);
response.End();
}
catch (Exception ex)
{
}
return(View("ShowVideo", "~/Views/Shared/_IndexPageLayout.cshtml", showVideoViewModel));
}
public ActionResult ShowVideoPastPaper(int subID, int questionId, string transactionid, string session_id = null, bool isdwn = false, string variant = null)
{
if (TempData["paymentTransactionId"] != null)
{
PayPalManager payPalManager = new PayPalManager();
var invoice = payPalManager.GetPayPalInvoiceByGUID(Convert.ToString(TempData["paymentTransactionId"]));
if (invoice != null)
{
if (invoice.QuestionID != subID)
{
ViewBag.paymentTransactionId = null;
}
else if (invoice.QuestionID == subID || variant != null)
{
List <QuestionPayment> lstQuestion = new SubjectsController().getQuesionsFromPaymentQuestion_BySubjectsIDAndTransactionAndVarient(subID, Convert.ToString(TempData["paymentTransactionId"]), variant);
if (lstQuestion.Count > 0)
{
if (lstQuestion.Select(x => x.create_date == DateTime.Now.Date).FirstOrDefault())
{
ViewBag.paymentTransactionId = TempData["paymentTransactionId"];
TempData.Keep("paymentTransactionId");
}
else
{
ViewBag.paymentTransactionId = null;
}
}
else
{
ViewBag.paymentTransactionId = null;
}
}
else
{
List <QuestionPayment> lstQuestion = new SubjectsController().getQuesionsFromPaymentQuestion_BySubjectsIDAndTransaction(subID, Convert.ToString(TempData["paymentTransactionId"]));
if (lstQuestion.Count > 0)
{
if (lstQuestion.Select(x => x.create_date == DateTime.Now.Date).FirstOrDefault())
{
ViewBag.paymentTransactionId = TempData["paymentTransactionId"];
TempData.Keep("paymentTransactionId");
}
else
{
ViewBag.paymentTransactionId = null;
}
}
else
{
ViewBag.paymentTransactionId = null;
}
}
}
}
if (string.IsNullOrEmpty(transactionid))
{
if (isdwn == true)
{
List <Questions> Question = new SubjectsController().getChaptersQuesionsByQuestionID(questionId);
if (Question.Select(x => x.isfree).FirstOrDefault() == true)
{
List <object> lstRet1 = new SubjectsController().getChapterContentsQuestionBySubjectID(subID);
var showVideoViewModel1 = new ShowVideoViewModel();
var videoFileName1 = "";
var videoFilePath1 = "";
var subjectName1 = "";
var chapterName1 = "";
var questionText1 = "";
foreach (var item in lstRet1)
{
var questionIdDB = item.GetType().GetProperty("ContentsHolder").GetValue(item, null).ToString();
if (questionId.ToString() == questionIdDB)
{
videoFilePath1 = item.GetType().GetProperty("VideoFilePath").GetValue(item, null).ToString();
videoFileName1 = item.GetType().GetProperty("VideoFileName").GetValue(item, null).ToString();
subjectName1 = item.GetType().GetProperty("SubjectName").GetValue(item, null).ToString();
chapterName1 = item.GetType().GetProperty("ChapterName").GetValue(item, null).ToString();
questionText1 = item.GetType().GetProperty("QuestionText").GetValue(item, null).ToString();
}
}
ViewBag.Path = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(videoFilePath1);
showVideoViewModel1.SubjectName = subjectName1;
showVideoViewModel1.ChapterName = chapterName1;
showVideoViewModel1.ExerciseName = chapterName1;
showVideoViewModel1.QuestionText = questionText1;
ViewBag.ShowVideoPastPaper = 1;
string downloadURL1 = GetBaseUrl() + "/Home/DownloadQuestion?p1=" + questionId;
ViewBag.DownloadURL = downloadURL1;
ViewBag.transactionid = transactionid;
try
{
string strURL = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(videoFilePath1);
string strFileName = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(videoFileName1);
WebClient req = new WebClient();
HttpResponse response = System.Web.HttpContext.Current.Response;
response.Clear();
response.ClearContent();
response.ClearHeaders();
response.Buffer = true;
response.AddHeader("Content-Disposition", "attachment;filename=\"" + Server.MapPath(videoFileName1) + "\"");
//response.AppendHeader("Content-Disposition", "attachment; filename=" + subjectName +" "+ chapterName + " " + questionText + "");
byte[] data = req.DownloadData(Server.MapPath(strURL));
response.BinaryWrite(data);
response.End();
}
catch (Exception ex)
{
}
return(View("ShowVideo", "~/Views/Shared/_IndexPageLayout.cshtml", showVideoViewModel1));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
}
else
{
PayPalManager payPalManager = new PayPalManager();
var invoice = payPalManager.GetPayPalInvoiceByGUID(transactionid);
//if (invoice == null || invoice.QuestionID != questionId || invoice.State != "approved")
// return RedirectToAction("Index", "Home");
if (invoice != null && invoice.RequestXML.ToLower().Contains("stripe payment"))
{
//if (invoice.QuestionID != questionId && session_id != invoice.PaymentID)
if (invoice.PaymentID == null)
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
//if (invoice == null || invoice.QuestionID != questionId || invoice.State != "approved")
if (invoice == null || invoice.State != "approved")
{
return(RedirectToAction("Index", "Home"));
}
}
}
List <object> lstRet = new SubjectsController().getChapterContentsQuestionBySubjectID(subID);
var showVideoViewModel = new ShowVideoViewModel();
var videoFileName = "";
var videoFilePath = "";
var subjectName = "";
var chapterName = "";
var questionText = "";
foreach (var item in lstRet)
{
var questionIdDB = item.GetType().GetProperty("ContentsHolder").GetValue(item, null).ToString();
if (questionId.ToString() == questionIdDB)
{
videoFilePath = item.GetType().GetProperty("VideoFilePath").GetValue(item, null).ToString();
videoFileName = item.GetType().GetProperty("VideoFileName").GetValue(item, null).ToString();
subjectName = item.GetType().GetProperty("SubjectName").GetValue(item, null).ToString();
chapterName = item.GetType().GetProperty("ChapterName").GetValue(item, null).ToString();
questionText = item.GetType().GetProperty("QuestionText").GetValue(item, null).ToString();
}
}
ViewBag.Path = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(videoFilePath);
showVideoViewModel.SubjectName = subjectName;
showVideoViewModel.ChapterName = chapterName;
showVideoViewModel.ExerciseName = chapterName;
showVideoViewModel.QuestionText = questionText;
ViewBag.ShowVideoPastPaper = 1;
string downloadURL = GetBaseUrl() + "/Home/DownloadQuestion?p1=" + questionId;
ViewBag.DownloadURL = downloadURL;
ViewBag.transactionid = transactionid;
try
{
string strURL = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(videoFilePath);
string strFileName = "/ContentStorage/ChaptersContents/" + System.IO.Path.GetFileName(videoFileName);
WebClient req = new WebClient();
HttpResponse response = System.Web.HttpContext.Current.Response;
response.Clear();
response.ClearContent();
response.ClearHeaders();
response.Buffer = true;
response.AddHeader("Content-Disposition", "attachment;filename=\"" + Server.MapPath(videoFileName) + "\"");
//response.AppendHeader("Content-Disposition", "attachment; filename=" + subjectName +" "+ chapterName + " " + questionText + "");
byte[] data = req.DownloadData(Server.MapPath(strURL));
response.BinaryWrite(data);
response.End();
}
catch (Exception ex)
{
}
return(View("ShowVideo", "~/Views/Shared/_IndexPageLayout.cshtml", showVideoViewModel));
}
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));
}
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 ChapterQuestions(int Sub, int questionYearId, string variant, bool scfp = false)
{
ChaptersViewModel vm = new ChaptersViewModel();
PayPalManager payPalManager = new PayPalManager();
int subjecttype;
if (scfp == false)
{
if (TempData["paymentTransactionId"] != null)
{
SubjectsController sc = new SubjectsController();
sc.DeleteInvoiceFromPaymentQuestion(Convert.ToString(TempData["paymentTransactionId"]));
payPalManager.DeletePayPalInvoice(Convert.ToString(TempData["paymentTransactionId"]));
ViewBag.paymentTransactionId = null;
TempData["paymentTransactionId"] = null;
}
else if (TempData["paymentTransactionId"] == null)
{
ViewBag.paymentTransactionId = null;
TempData["paymentTransactionId"] = null;
}
}
if (TempData["paymentTransactionId"] != null)
{
var invoice = payPalManager.GetPayPalInvoiceByGUID(Convert.ToString(TempData["paymentTransactionId"]));
if (invoice != null)
{
if (invoice.QuestionID != Sub)
{
ViewBag.paymentTransactionId = null;
}
else if (invoice.QuestionID == Sub && !string.IsNullOrEmpty(variant))
{
List <QuestionPayment> lstQuestion = new SubjectsController().getQuesionsFromPaymentQuestion_BySubjectsIDAndTransactionAndVarient(Sub, Convert.ToString(TempData["paymentTransactionId"]), variant);
if (lstQuestion.Count > 0)
{
if (lstQuestion.Select(x => x.create_date == DateTime.Now.Date).FirstOrDefault())
{
ViewBag.paymentTransactionId = TempData["paymentTransactionId"];
TempData.Keep("paymentTransactionId");
//try
//{
// MailMessage msgs = new MailMessage();
// msgs.To.Add("*****@*****.**");
// MailAddress address = new MailAddress("*****@*****.**");
// msgs.From = address;
// msgs.Subject = "USer Redirect to Payment";
// string htmlBody = "Sending This email When user click on Payment Button ";
// msgs.Body = htmlBody;
// msgs.IsBodyHtml = true;
// SmtpClient client = new SmtpClient();
// client.Host = "relay-hosting.secureserver.net";
// client.Port = 25;
// client.UseDefaultCredentials = false;
// client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "asjad001$");
// //Send the msgs
// client.Send(msgs);
//}
//catch (Exception ex) { }
}
else
{
ViewBag.paymentTransactionId = null;
}
}
else
{
ViewBag.paymentTransactionId = null;
}
}
else
{
List <QuestionPayment> lstQuestion = new SubjectsController().getQuesionsFromPaymentQuestion_BySubjectsIDAndTransaction(Sub, Convert.ToString(TempData["paymentTransactionId"]));
if (lstQuestion.Count > 0)
{
if (lstQuestion.Select(x => x.create_date == DateTime.Now.Date).FirstOrDefault())
{
ViewBag.paymentTransactionId = TempData["paymentTransactionId"];
TempData.Keep("paymentTransactionId");
//try
//{
// MailMessage msgs = new MailMessage();
// msgs.To.Add("*****@*****.**");
// MailAddress address = new MailAddress("*****@*****.**");
// msgs.From = address;
// msgs.Subject = "USer Redirect to Payment";
// string htmlBody = "Sending This email When user click on Payment Button ";
// msgs.Body = htmlBody;
// msgs.IsBodyHtml = true;
// SmtpClient client = new SmtpClient();
// client.Host = "relay-hosting.secureserver.net";
// client.Port = 25;
// client.UseDefaultCredentials = false;
// client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "asjad001$");
// //Send the msgs
// client.Send(msgs);
//}
//catch (Exception ex) { }
}
else
{
ViewBag.paymentTransactionId = null;
}
}
else
{
ViewBag.paymentTransactionId = null;
}
}
}
else
{
ViewBag.paymentTransactionId = null;
}
}
else
{
ViewBag.paymentTransactionId = null;
}
List <SubjectChapters> lstRet = new SubjectsController().getChaptersExerciseBySubjectsID(Sub);
List <Questions> lstRet1 = new SubjectsController().getChaptersQuesionsBySubjectsID(Sub);
var variants1 = lstRet1.Where(x => !string.IsNullOrWhiteSpace(x.ImageFileName)).Select(x => x.ImageFileName).Distinct().ToList();
subjecttype = lstRet.Select(x => x.SubjectType).FirstOrDefault();
ViewBag.subjecttype = subjecttype;
ViewBag.selectedVariant = null;
// var type = lstsubjects.Select(x=>x.SubjectID) lstRet1.Select(x => x.SubjectsChaptersID).FirstOrDefault();
vm.Variants = GetSelectListItems(variants1);
var questionYear = lstRet1.Where(x => x.QuestionID == questionYearId).FirstOrDefault()?.PaperYear;
//var questionYear = lstRet1.FirstOrDefault()?.PaperYear;
ViewBag.questionYearId = questionYearId;
//var variatnEndwith2;
//foreach
if (subjecttype == 1 || subjecttype == 4 || subjecttype == 5 || subjecttype == 8)
{
if (!string.IsNullOrEmpty(variant))
{
lstRet1 = lstRet1.Where(x => x.ImageFileName == variant).ToList();
ViewBag.selectedVariant = variant;
}
else
{
var variants2 = variants1.Where(x => x.EndsWith("2")).FirstOrDefault();
lstRet1 = lstRet1.Where(x => x.ImageFileName == variants2).ToList();
ViewBag.selectedVariant = variants2;
}
}
vm.SubjectChapters = lstRet;
vm.Questions = lstRet1.Where(x => x.PaperYear == questionYear).ToList();
return(View(vm));
}
