public ActionResult TestYourKnowledge()
{
List <SelectListItem> countriesItem = new List <SelectListItem>();
TblEnquiry tblEnquiry = new TblEnquiry();
try
{
DataSet ds = quizRepository.GetCountries();
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
countriesItem.Add(new SelectListItem
{
Text = Convert.ToString(dr["CountryName"]),
Value = Convert.ToString(dr["CountryName"])
});
}
}
}
}
Session["countriesItem"] = countriesItem;
ViewBag.CountryList = countriesItem;
}
catch (Exception ex)
{
newException.AddException(ex);
}
return(View(tblEnquiry));
}
public ActionResult SubmitEnquiry(TblEnquiry tblEnquiry)
{
try
{
List <SelectListItem> countriesItem = new List <SelectListItem>();
countriesItem = (List <SelectListItem>)Session["countriesItem"];
ViewBag.CountryList = countriesItem;
var result = quizRepository.InsertEnquiryData(tblEnquiry);
if (result > 0)
{
Session["Enquiry"] = result;
TempData["Added"] = "Enquiry added succefully";
return(RedirectToAction("StartQuiz"));
}
else
{
TempData["Message"] = "Email Id already exist";
}
}
catch (Exception ex)
{
newException.AddException(ex);
}
return(View("TestYourKnowledge"));
}
public int InsertEnquiryData(TblEnquiry obj)
{
int status = 0;
try
{
db.parameters.Clear();
db.AddParameter("@FullName", SqlDbType.NText, obj.FullName);
db.AddParameter("@EmailId", SqlDbType.NText, obj.EmailId);
db.AddParameter("@ContactNo", SqlDbType.NText, obj.ContactNo);
db.AddParameter("@CourseName", SqlDbType.NText, obj.CourseName);
db.AddParameter("@Country", SqlDbType.NText, obj.Country);
db.AddParameter("@isShared", SqlDbType.Bit, obj.isShared);
db.AddParameter("@UserId", SqlDbType.Int, ParameterDirection.Output);
status = db.ExecuteQuery("sp_EnquiryAdd");
if (Convert.ToInt32(db.parameters[6].Value) > 0)
{
status = Convert.ToInt32(db.parameters[6].Value);
}
}
catch (Exception ex)
{
newException.AddException(ex);
throw ex;
}
return(status);
}
public ActionResult ShareLink(string emailId)
{
string AssessmentLink = System.Configuration.ConfigurationManager.AppSettings["AssessmentLink"];
TblEnquiry tblEnquiry = new TblEnquiry();
tblEnquiry.EmailId = emailId;
tblEnquiry.isShared = true;
var result = quizRepository.InsertEnquiryData(tblEnquiry);
if (result > 0)
{
var link = "<a href='" + AssessmentLink + "'>Click here to test your knowledge</a>";
var emailBody = "Hello <br> Your friend shared assessment to test your knowledge. Please click on below link to take a test - " + link;
var emailSubject = "Test your knowledge";
tblEmails objEmail = new tblEmails();
objEmail.EmailTo = emailId;
objEmail.EmailSubject = emailSubject;
objEmail.EmailBody = emailBody;
var emailResult = userRepository.InsertEmail(objEmail);
}
return(Json("OK", JsonRequestBehavior.AllowGet));
}
