protected void Page_Load(object sender, EventArgs e)
{
if (Session["userId"] == null)
{
Response.Redirect("~\\Login.aspx", false);
return;
}
if (Session["ReportID"] != null)
{
var ins = new ORM.SenseiPortalEntities2();
reportID = Convert.ToInt32(Session["ReportID"].ToString());
var download = ins.UserReports.FirstOrDefault(v => v.id == reportID);
if (download != null)
{
AssessmentName = download.Assessment;
FileName = download.ReportFile;
DateTaken = $"{download.CreationDate.Value.ToLongDateString()} {download.CreationDate.Value.ToLongTimeString()}";
}
}
}
protected void btnDownload_Click(object sender, EventArgs e)
{
var ins = new ORM.SenseiPortalEntities2();
var selectedID = Convert.ToInt32(ComboBox.SelectedItem.Value);
var download = ins.UserReports.FirstOrDefault(v => v.id == selectedID);
if (download != null)
{
if (download.IsActive == false || download.Code == null)
{
Session["ReportFilePath"] = download.ReportFile;
Session["ReportID"] = download.id;
Session["RequestToDownload"] = 1;
Response.Redirect("~\\Home.aspx", false);
}
else
{
Response.ContentType = "application/octect-stream";
Response.AppendHeader("content-disposition", "filename=Report.pdf");
Response.TransmitFile(download.ReportFile);
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userId"] == null ||
Session["ReportFilePath"] == null ||
Session["ReportID"] == null)
{
Response.Redirect("~\\Login.aspx", false);
return;
}
if (!IsPostBack)
{
//if this page is redirected from Downloads page then ignore sending email automatically.
//if this page comes from after completing the assessment send the report to user email
if (Session["RequestToDownload"] == null)
{
var downloadFilePath = Session["ReportFilePath"].ToString();
var ins = new ORM.SenseiPortalEntities2();
var reportID = Convert.ToInt32(Session["ReportID"].ToString());
var download = ins.UserReports.FirstOrDefault(v => v.id == reportID);
var AssessmentName = download.Assessment;
//var FileName = download.ReportFile;
var DateTaken = $"{download.CreationDate.Value.ToLongDateString()} {download.CreationDate.Value.ToLongTimeString()}";
var userID = Convert.ToInt32(Session["userId"]);
var userInfo = ins.Users.FirstOrDefault(v => v.OID == userID);
var Subject = $"Sensei Assessments Report ({AssessmentName})";
var Body = $"Dear {userInfo.FirstName},<br/><br/>Thank you for taking Sensei-Assessments.<br/><br/>" +
$"Your Assessment Report is ready to download. Please find the attahed dcocument in this email.<br/><br/>" +
$"Assessment Taken: <strong>{AssessmentName}</strong><br/>" +
$"Date: <strong>{DateTaken}</strong><br/><br/>";
Body += $"Thanks.<br/>The Sensei-Assessments Team";
Functions.SendEmail(Subject, Body, userInfo.E_mail, downloadFilePath);
}
Session["RequestToDownload"] = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userId"] == null)
{
Response.Redirect("~\\Login.aspx", false);
return;
}
var userID = int.Parse(Session["userId"].ToString());
var ins = new ORM.SenseiPortalEntities2();
var reports = ins.UserReports.Where(v => v.UserID == userID).OrderByDescending(v => v.CreationDate);
ComboBox.DataSource = reports.ToList();
ComboBox.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["TransactionID"] == null)
{
Response.Redirect("~\\Login.aspx", false);
return;
}
var ins = new ORM.SenseiPortalEntities2();
var transactionID = Convert.ToInt32(Session["TransactionID"].ToString());
var transactionInfo = ins.Transactions.FirstOrDefault(v => v.id == transactionID);
transactionInfo.status = "FAILED";
ins.SaveChanges();
Session["TransactionID"] = null;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userId"] == null)
{
Response.Redirect("~\\Login.aspx", false);
return;
}
var ins = new ORM.SenseiPortalEntities2();
var userID = Convert.ToInt32(Session["userId"]);
var userInfo = ins.Users.FirstOrDefault(v => v.OID == userID);
if (userInfo == null)
{
Response.Redirect("Login.aspx");
return;
}
if (Session["ReportID"] == null)
{
Response.Redirect("Downloads.aspx");
return;
}
if (Session["TransactionID"] == null)
{
Response.Redirect("Downloads.aspx");
return;
}
var reportID = Convert.ToInt32(Session["ReportID"].ToString());
var transactionID = Convert.ToInt32(Session["TransactionID"].ToString());
var transactionInfo = ins.Transactions.FirstOrDefault(v => v.id == transactionID);
transactionInfo.status = "SUCCESS";
ins.SaveChanges();
Session["TransactionID"] = null;
var download = ins.UserReports.FirstOrDefault(v => v.id == reportID);
if (download == null)
{
Response.Redirect("Login.aspx");
return;
}
var AssessmentName = download.Assessment;
var FileName = download.ReportFile;
var DateTaken = $"{download.CreationDate.Value.ToLongDateString()} {download.CreationDate.Value.ToLongTimeString()}";
var FileNameExcel = FileName.Replace(".pdf", ".xlsx");
//mail.From = new MailAddress("*****@*****.**", "Sensei-Assessments");
//mail.To.Add("*****@*****.**");
//mail.Bcc.Add("*****@*****.**");
var Subject = "Comprehensive Report Request";
var Body = $"Dear Sensei Assessment Team,<br/><br/><strong>{userInfo.FirstName} {userInfo.LastName} has requested for comprehensive report of the following assessment :</strong>";
Body += $"<br/><br/><b>Assessment Name:<b/> {AssessmentName}<br/><b>Date Taken: <b/>{DateTaken}";
Body += $"Email: <strong>{userInfo.E_mail}</strong><br/><br/></strong><br/><br/>Thanks.<br/>The Sensei-Assessments Team";
Functions.SendEmail(Subject, Body, "*****@*****.**", FileNameExcel);
//Response.Write("Mail Sent");
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
ServicePointManager.Expect100Continue = true;
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls
| SecurityProtocolType.Tls11
| SecurityProtocolType.Tls12
| SecurityProtocolType.Ssl3;
var ins = new ORM.SenseiPortalEntities2();
var userID = Convert.ToInt32(Session["userId"]);
var transactionID = Guid.NewGuid().ToString().Replace("-", "").Substring(0, 8);
var userInfo = ins.Users.FirstOrDefault(v => v.OID == userID);
if (userInfo == null)
{
Response.Redirect("Login.aspx?trid=" + transactionID);
return;
}
string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/";
// CREATING LIST OF POST DATA
NameValueCollection PostData = new NameValueCollection();
PostData.Add("total_amount", "10.00");
PostData.Add("currency", "USD");
PostData.Add("tran_id", transactionID);
PostData.Add("success_url", baseUrl + "Success.aspx");
PostData.Add("fail_url", baseUrl + "TransactionFailed.aspx");
PostData.Add("cancel_url", baseUrl + "TransactionFailed.aspx");
PostData.Add("version", "3.00");
PostData.Add("cus_name", $"{userInfo.FirstName} {userInfo.LastName}");
PostData.Add("cus_email", $"{userInfo.E_mail}");
PostData.Add("cus_add1", $"{userInfo.Address}");
PostData.Add("cus_add2", "");
PostData.Add("cus_city", $"{userInfo.City}");
PostData.Add("cus_state", userInfo.State);
PostData.Add("cus_postcode", userInfo.Postal);
PostData.Add("cus_country", userInfo.Country);
PostData.Add("cus_phone", userInfo.PhoneNumber);
PostData.Add("cus_fax", "");
PostData.Add("ship_name", userInfo.FirstName);
PostData.Add("ship_add1", userInfo.Address);
PostData.Add("ship_add2", "");
PostData.Add("ship_city", userInfo.City);
PostData.Add("ship_state", userInfo.State);
PostData.Add("ship_postcode", userInfo.Postal);
PostData.Add("ship_country", userInfo.Country);
PostData.Add("value_a", userID.ToString());
PostData.Add("value_b", AssessmentName);
PostData.Add("value_c", DateTaken);
PostData.Add("value_d", "SENSEI-ASSESSMENTS");
Transaction transaction = new Transaction()
{
amount = 10,
assreportid = reportID,
status = "Pending",
trcode = transactionID,
trdate = DateTime.Now,
userID = userID
};
ins.Transactions.Add(transaction);
ins.SaveChanges();
Session["TransactionID"] = transaction.id;
//SSLCommerz sslcz = new SSLCommerz("sense5dca082ef2de6", "sense5dca082ef2de6@ssl", true);
//SSLCommerz sslcz = new SSLCommerz("demotest", "qwerty");
SSLCommerz sslcz = new SSLCommerz("senseiassessmentslive", "5DD0FB95EE1E552521");
String response = sslcz.InitiateTransaction(PostData);
Response.Redirect(response);
}
