public ActionResult GetSCARFSurveyAnswerData([DataSourceRequest] DataSourceRequest request)
{
List <SCARFSurveyAnswerModels> SCARFSurveyAnswerModelsList = null;
SCARFSurveyAnswerModelsList = BCBSDataAccess.GetDataForSCARFSurveyAnswer();
if (SCARFSurveyAnswerModelsList == null)
{
return(Json(new List <SCARFSurveyAnswerModels>(), JsonRequestBehavior.AllowGet));
}
return(Json(SCARFSurveyAnswerModelsList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public ActionResult U65GetReportData([DataSourceRequest] DataSourceRequest request)
{
List <U65Certificate> U65ModelList = null;
U65ModelList = BCBSDataAccess.GetDataForU65Report();
if (U65ModelList == null)
{
return(Json(new List <U65Certificate>(), JsonRequestBehavior.AllowGet));
}
return(Json(U65ModelList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public ActionResult GetSalesData([DataSourceRequest] DataSourceRequest request)
{
List <SalesCertificate> SalesCertificateModelList = null;
SalesCertificateModelList = BCBSDataAccess.GetDataForSales();
if (SalesCertificateModelList == null)
{
return(Json(new List <SalesCertificate>(), JsonRequestBehavior.AllowGet));
}
return(Json(SalesCertificateModelList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public ActionResult GetReportData([DataSourceRequest] DataSourceRequest request)
{
List <Certificate> courseModelList = null;
courseModelList = BCBSDataAccess.GetDataForReport();
if (courseModelList == null)
{
return(Json(new List <Certificate>(), JsonRequestBehavior.AllowGet));
}
// return View(new GridModel(metadataDocTypesList));
return(Json(courseModelList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
// POST api/<controller>
public string Post(Certificate model)
{
var certificateLink = string.Empty;
// BCBSDataAccess.AddDumCourse("entry");
try
{
if (string.IsNullOrWhiteSpace(model.EmailAddress) && string.IsNullOrWhiteSpace(model.CourseTitle))
{
throw new ApplicationException("Email Address and Course Title required..");
}
//if(model == null)
// BCBSDataAccess.AddDumCourse("model is null");
Guid userCourseId;
// BCBSDataAccess.AddDumCourse("before save data");
var result = BCBSDataAccess.SaveData(model, out userCourseId);
Util.LogInfo("Post", "AFter dsave call :" + result);
// BCBSDataAccess.AddDumCourse("after save data:"+result);
certificateLink = ConfigurationManager.AppSettings["CertificateLink"];
certificateLink = string.Format(certificateLink, userCourseId);
// link = string.Format(link,certificateLink);
if (result)
{
var subject = ConfigurationManager.AppSettings["MailSubject"];
var physicalPath = Util.ResolveFileName(@"Template\EmailTemplate.txt");
var content = File.ReadAllText(physicalPath);
var emailContent = string.Format(content, model.CourseTitle, certificateLink);
// var recipient = ConfigurationManager.AppSettings["Recipient"];
Util.SendMail(model.EmailAddress, subject, emailContent);
}
}
catch (Exception ex)
{
string DetailsMessageError = null;
if (ex.InnerException != null)
{
DetailsMessageError = ex.InnerException.Message + " " + ex.StackTrace;
}
else
{
DetailsMessageError = ex.StackTrace;
}
Util.LoggError(new System.Diagnostics.StackFrame(0).GetMethod().Name,
ex.Message, DetailsMessageError);
}
return(certificateLink);
}
public ActionResult GetExporttoSCARFSurveyAnswerData()
{
MemoryStream memoryStream = null;
List <SCARFSurveyAnswerModels> SCARFSurveyAnswerModelsList = null;
const string header = "Workday ID,Learner Name,Manager Name,Manager Email Address,Report Date,Status,Status Text,Certainty,Certainty Text,Autonomy,Autonomy Text,Relatedness,Relatedness Text,Fairness,Fairness Text";
const string format = "{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14}";
string content = string.Empty;
SCARFSurveyAnswerModelsList = BCBSDataAccess.GetDataForSCARFSurveyAnswer();
memoryStream = new MemoryStream();
if (SCARFSurveyAnswerModelsList != null && SCARFSurveyAnswerModelsList.Count > 0)
{
TextWriter tw = new StreamWriter(memoryStream);
tw.WriteLine(header);
foreach (var item in SCARFSurveyAnswerModelsList)
{
item.WorkDayId = item.WorkDayId;
item.LearnerName = item.LearnerName;
item.managerName = item.managerName;
item.managerEmailID = item.managerEmailID;
item.ReportDateString = item.ReportDate.ToString("MM/dd/yyyy").Trim();
item.Status = item.Status;
item.StatusText = item.StatusText;
item.Certainty = item.Certainty;
item.CertaintyText = item.CertaintyText;
item.Autonomy = item.Autonomy;
item.AutonomyText = item.AutonomyText;
item.Relatedness = item.Relatedness;
item.RelatednessText = item.RelatednessText;
item.Fairness = item.Fairness;
item.FairnessText = item.FairnessText;
content = string.Format(format, item.WorkDayId, item.LearnerName, item.managerName, item.managerEmailID, item.ReportDateString, item.Status, item.StatusText, item.Certainty, item.CertaintyText, item.Autonomy, item.AutonomyText, item.Relatedness, item.RelatednessText, item.Fairness, item.FairnessText);
tw.WriteLine(content);
}
tw.Flush();
}
string contentType = "application/octet-stream";
byte[] pdfdata = null;
pdfdata = memoryStream.ToArray();
var filaName = (ConfigurationManager.AppSettings["ProjectName"]);
var Datetime = "";
Datetime = DateTime.Now.ToString("dd_MM_yyyy_T_HH:mm");
return(File(pdfdata, contentType, filaName + "_ExportData_" + Datetime + ".csv"));
}
public ActionResult U65Certificate(int id)
{
if (id > 0)
{
var model = BCBSDataAccess.U65GetDataForCertificate(id);
if (model != null)
{
model.DateofCompletion = model.DateofCompletion;
string fileName = string.Empty;
byte[] bytes = new byte[0];
var response = new FileContentResult(bytes, "application/octet-stream");
bytes = ControllerContext.GeneratePdf(model, "_U65CertificatePDF");
Font footerFont = FontFactory.GetFont("Arial", 8, Font.NORMAL, BaseColor.BLACK);
using (MemoryStream stream = new MemoryStream())
{
Document document = new Document(PageSize.A4_LANDSCAPE);
PdfWriter writer = PdfWriter.GetInstance(document, stream);
PdfReader reader = new PdfReader(bytes);
using (PdfStamper stamper = new PdfStamper(reader, stream))
{
stamper.AcroFields.SetFieldProperty("SomeDateField", "textsize", 1f, null);
int pages = reader.NumberOfPages;
for (int i = 1; i <= pages; i++)
{
ColumnText.ShowTextAligned(stamper.GetUnderContent(i), Element.ALIGN_LEFT, new Phrase("Page | " + (i) + "/" + pages, footerFont), 20f, 15f, 0);
}
}
bytes = stream.ToArray();
}
fileName = "U65_CertificatePDF" + System.DateTime.Now.Ticks + ".pdf";
response = new FileContentResult(bytes, "application/octet-stream");
response.FileDownloadName = fileName;
return(response);
// return View("U65Certificate", model); // Return Html View Don't Remove
}
else
{
return(View("NotFound", model));
}
}
else
{
return(View("NotFound"));
}
}
public ActionResult ExportData()
{
MemoryStream memoryStream = null;
List <Certificate> courseModelList = null;
const string header = "Course Name, Provider's Name,Provider Type,Email Address,Medical License Number,National Provider Identifier (NPI),Practice Name,Completion Date,Total Credit Hours,Type of Credit,Delivery Method";
const string format = "{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10}";
string content = string.Empty;
courseModelList = BCBSDataAccess.GetDataForReport();
memoryStream = new MemoryStream();
if (courseModelList != null && courseModelList.Count > 0)
{
TextWriter tw = new StreamWriter(memoryStream);
tw.WriteLine(header);
foreach (var item in courseModelList)
{
item.CourseTitle = item.CourseTitle.Contains(",") ? item.CourseTitle.Replace(',', '|') : item.CourseTitle;
item.OfficialProviderName = item.OfficialProviderName.Contains(",") ? item.OfficialProviderName.Replace(',', '|') : item.OfficialProviderName;
item.ProviderType = item.ProviderType.Contains(",") ? item.ProviderType.Replace(',', '|') : item.ProviderType;
item.EmailAddress = item.EmailAddress.Contains(",") ? item.EmailAddress.Replace(',', '|') : item.EmailAddress;
item.MedicalLicenseNo = item.MedicalLicenseNo.Contains(",") ? item.MedicalLicenseNo.Replace(',', '|') : item.MedicalLicenseNo;
item.NPI = item.NPI.Contains(",") ? item.NPI.Replace(',', '|') : item.NPI;
item.PracticeName = item.PracticeName.Contains(",") ? item.PracticeName.Replace(',', '|') : item.PracticeName;
item.TotalContactHours = item.TotalContactHours.Contains(",") ? item.TotalContactHours.Replace(',', '|') : item.TotalContactHours;// Chnage 13/05/2019
item.TypeofCredits = item.TypeofCredits.Contains(",") ? item.TypeofCredits.Replace(',', '|') : item.TypeofCredits;
item.DeliveryMethod = item.DeliveryMethod.Contains(",") ? item.DeliveryMethod.Replace(',', '|') : item.DeliveryMethod;
content = string.Format(format, item.CourseTitle, item.OfficialProviderName, item.ProviderType, item.EmailAddress, item.MedicalLicenseNo, item.NPI, item.PracticeName,
item.CompletionDate.ToString("MMMM d yyyy"), item.TotalContactHours, item.TypeofCredits, item.DeliveryMethod);
tw.WriteLine(content);
}
tw.Flush();
}
string contentType = "application/octet-stream";
byte[] pdfdata = null;
pdfdata = memoryStream.ToArray();
var filaName = ConfigurationManager.AppSettings["CSVFileName"];
return(File(pdfdata, contentType, filaName));
}
public ActionResult U65ExportData()
{
MemoryStream memoryStream = null;
List <U65Certificate> U65CourseModelList = null;
const string header = "Agent Name, Agency Name,Address,Managing Health Agent Name,Agent Email,Work Phone Number,National Producer Number,FFM ID,Assessment Score,Pass/Fail Status,Date of Completion";
const string format = "{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10}";//,{8},{9},{10}";
string content = string.Empty;
U65CourseModelList = BCBSDataAccess.GetDataForU65Report();
memoryStream = new MemoryStream();
if (U65CourseModelList != null && U65CourseModelList.Count > 0)
{
TextWriter tw = new StreamWriter(memoryStream);
tw.WriteLine(header);
foreach (var item in U65CourseModelList)
{
item.AgentName = !String.IsNullOrEmpty(item.AgentName) ? (item.AgentName.Contains(",") ? item.AgentName.Replace(',', '|') : item.AgentName): string.Empty;
item.AgencyName = !String.IsNullOrEmpty(item.AgencyName)? (item.AgencyName.Contains(",") ? item.AgencyName.Replace(',', '|') : item.AgencyName) : string.Empty;
item.AgencyAddress = !String.IsNullOrEmpty(item.AgencyAddress)? (item.AgencyAddress.Contains(",") ? item.AgencyAddress.Replace(',', '|') : item.AgencyAddress) : string.Empty;
item.AgentManagingHealth = !String.IsNullOrEmpty(item.AgentManagingHealth)? (item.AgentManagingHealth.Contains(",") ? item.AgentManagingHealth.Replace(',', '|') : item.AgentManagingHealth) : string.Empty;
item.AgentEmail = !String.IsNullOrEmpty(item.AgentEmail)? (item.AgentEmail.Contains(",") ? item.AgentEmail.Replace(',', '|') : item.AgentEmail) : string.Empty;
item.WorkPhoneNumber = !String.IsNullOrEmpty(item.WorkPhoneNumber)? (item.WorkPhoneNumber.Contains(",") ? item.WorkPhoneNumber.Replace(',', '|') : item.WorkPhoneNumber) : string.Empty;
item.NationalProducerNumber = !String.IsNullOrEmpty(item.NationalProducerNumber)? (item.NationalProducerNumber.Contains(",") ? item.NationalProducerNumber.Replace(',', '|') : item.NationalProducerNumber) : string.Empty;
item.FFMID = !String.IsNullOrEmpty(item.FFMID) ? (item.FFMID.Contains(",") ? item.FFMID.Replace(',', '|') : item.FFMID) : string.Empty;
item.AssessmentScore = item.AssessmentScore;
//item.PassFailStatus = item.PassFailStatus;
item.PassFailStatusstring = Convert.ToBoolean(item.PassFailStatus) ? "PASS" : "FAIL";
item.DateofCompletion = item.DateofCompletion;
content = string.Format(format, item.AgentName, item.AgencyName, item.AgencyAddress, item.AgentManagingHealth, item.AgentEmail, item.WorkPhoneNumber, item.NationalProducerNumber, item.FFMID,
item.AssessmentScore, item.PassFailStatusstring, item.DateofCompletion.ToString("MM-dd-yyyy h:mm:ss tt"));
tw.WriteLine(content);
}
tw.Flush();
}
string contentType = "application/octet-stream";
byte[] pdfdata = null;
pdfdata = memoryStream.ToArray();
var filaName = ConfigurationManager.AppSettings["CSVFileName"];
return(File(pdfdata, contentType, filaName));
}
public ActionResult Certificate(string id)
{
Guid userCourseId;
if (!Guid.TryParse(id, out userCourseId))
{
return(View("NotFound"));
}
var model = BCBSDataAccess.GetDataForCertificate(userCourseId);
if (model != null)
{
model.CompletionDateString = model.CompletionDate.ToString("MMMM d, yyyy");
return(View("Certificate", model));
}
else
{
return(View("NotFound", model));
}
}
public string Post(U65Certificate model)
{
var U65CertificateLink = string.Empty;
try
{
if (string.IsNullOrWhiteSpace(model.AgentEmail) && string.IsNullOrWhiteSpace(model.AgentName))
{
throw new ApplicationException("Agent Email Address and Agent Name required..");
}
var result = BCBSDataAccess.SaveDataU65(model);
Util.LogInfo("Post", "AFter dsave call :" + result);
if (model.PassFailStatus == true)
{
U65CertificateLink = ConfigurationManager.AppSettings["CertificateLink"];
U65CertificateLink = string.Format(U65CertificateLink, result);
Util.LogInfo("Post", "AFter Sucess Result :" + result);
}
else
{
Util.LogInfo("Post", "AFter Status is Fail Result :" + result);
U65CertificateLink = string.Format("Status is Fail");
}
}
catch (Exception ex)
{
string DetailsMessageError = null;
if (ex.InnerException != null)
{
DetailsMessageError = ex.InnerException.Message + " " + ex.StackTrace;
}
else
{
DetailsMessageError = ex.StackTrace;
}
Util.LoggError(new System.Diagnostics.StackFrame(0).GetMethod().Name,
ex.Message, DetailsMessageError);
}
return(U65CertificateLink);
}
public SCARFSurveyAnswerModels SCARFSurveyPost([FromBody] SCARFSurveyAnswerModels SCARFSurveyModel)
{
SCARFSurveyAnswerModels OnjSCARFSurvey = new SCARFSurveyAnswerModels();
try
{
if (String.IsNullOrEmpty(SCARFSurveyModel.WorkDayId.Trim()))
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "WorkDay Id is Required";
}
else if (String.IsNullOrEmpty(SCARFSurveyModel.LearnerName.Trim()))
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "Learner Name is Required";
}
else if (String.IsNullOrEmpty(SCARFSurveyModel.managerName.Trim()))
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "Manager Name is Required";
}
else if (String.IsNullOrEmpty(SCARFSurveyModel.managerEmailID.Trim()))
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "Manager Email Address is Required";
}
else if (SCARFSurveyModel.StatusText.Length > 300)
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "StatusText length exceeded.";
}
else if (SCARFSurveyModel.CertaintyText.Length > 300)
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "CertaintyText length exceeded.";
}
else if (SCARFSurveyModel.AutonomyText.Length > 300)
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "AutonomyText length exceeded.";
}
else if (SCARFSurveyModel.RelatednessText.Length > 300)
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "RelatednessText length exceeded.";
}
else if (SCARFSurveyModel.FairnessText.Length > 300)
{
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "FairnessText length exceeded.";
}
if (SCARFSurveyModel.IsErrrorMsg == false)
{
SCARFSurveyModel.SCARFSurveyId = 0;
OnjSCARFSurvey.WorkDayId = SCARFSurveyModel.WorkDayId;
OnjSCARFSurvey.LearnerName = SCARFSurveyModel.LearnerName;
OnjSCARFSurvey.managerName = SCARFSurveyModel.managerName;
OnjSCARFSurvey.managerEmailID = SCARFSurveyModel.managerEmailID;
OnjSCARFSurvey.Status = SCARFSurveyModel.Status;
OnjSCARFSurvey.StatusText = SCARFSurveyModel.StatusText;
OnjSCARFSurvey.Certainty = SCARFSurveyModel.Certainty;
OnjSCARFSurvey.CertaintyText = SCARFSurveyModel.CertaintyText;
OnjSCARFSurvey.Autonomy = SCARFSurveyModel.Autonomy;
OnjSCARFSurvey.AutonomyText = SCARFSurveyModel.AutonomyText;
OnjSCARFSurvey.Relatedness = SCARFSurveyModel.Relatedness;
OnjSCARFSurvey.RelatednessText = SCARFSurveyModel.RelatednessText;
OnjSCARFSurvey.Fairness = SCARFSurveyModel.Fairness;
OnjSCARFSurvey.FairnessText = SCARFSurveyModel.FairnessText;
int result = BCBSDataAccess.SaveDataSCARFSurvey(OnjSCARFSurvey);
Util.LogInfo("Post", "After dsave call :" + result);
if (result > 0)
{
SCARFSurveyModel.SCARFSurveyId = result;
SCARFSurveyModel.IsErrrorMsg = false;
SCARFSurveyModel.Message = "Sucess";
var model = BCBSDataAccess.GetSCARFSurveyDataForPDF(SCARFSurveyModel.SCARFSurveyId);
if (model != null)
{
model.managerName = OnjSCARFSurvey.managerName;
string html = RenderViewToString("SCARFSurveyAnswer", "~/views/Shared/_SCARFSurveyAnswerPDF.cshtml", model);
model.ReportDate = model.ReportDate;
byte[] buffer = Render(html);
using (MemoryStream stream = new System.IO.MemoryStream())
{
Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 20f, 20f);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
writer.CloseStream = false;
pdfDoc.Open();
StringReader sr = new StringReader(html);
XMLWorkerHelper.GetInstance().ParseXHtml(writer, pdfDoc, sr);
pdfDoc.Close();
buffer = stream.ToArray();
Attachment AttachmentMemoryStream = new Attachment(new MemoryStream(buffer), "SCARFSurveyAnswer" + SCARFSurveyModel.SCARFSurveyId + ".PDF");
//File Write in Folder With Out Mail
//string FilePathandName = @"C:\Logs\" + "SCARFSurveyAnswer" + SCARFSurveyModel.SCARFSurveyId + ".PDF";
//File.WriteAllBytes(FilePathandName, buffer);
#region Mail Sending
var subject = ConfigurationManager.AppSettings["MailSubject"] + model.LearnerName;
var physicalPath = Util.ResolveFileName(@"Template\EmailTemplate.txt");
var content = File.ReadAllText(physicalPath);
string emailContent = content.Replace("@LearnerName", model.LearnerName).Replace("@ManagerName", model.managerName);
Util.SendMail(OnjSCARFSurvey.managerEmailID, subject, emailContent, AttachmentMemoryStream);
}
#endregion
}
SCARFSurveyModel.WorkDayId = "";
SCARFSurveyModel.LearnerName = "";
SCARFSurveyModel.managerName = "";
SCARFSurveyModel.managerEmailID = "";
SCARFSurveyModel.Status = "";
SCARFSurveyModel.StatusText = "";
SCARFSurveyModel.Certainty = "";
SCARFSurveyModel.CertaintyText = "";
SCARFSurveyModel.Autonomy = "";
SCARFSurveyModel.AutonomyText = "";
SCARFSurveyModel.Relatedness = "";
SCARFSurveyModel.RelatednessText = "";
SCARFSurveyModel.Fairness = "";
SCARFSurveyModel.FairnessText = "";
}
else if (result == -1)
{
SCARFSurveyModel.SCARFSurveyId = 0;
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "Duplicate WorkDayId";
SCARFSurveyModel.WorkDayId = "";
SCARFSurveyModel.LearnerName = "";
SCARFSurveyModel.managerName = "";
SCARFSurveyModel.managerEmailID = "";
SCARFSurveyModel.Status = "";
SCARFSurveyModel.StatusText = "";
SCARFSurveyModel.Certainty = "";
SCARFSurveyModel.CertaintyText = "";
SCARFSurveyModel.Autonomy = "";
SCARFSurveyModel.AutonomyText = "";
SCARFSurveyModel.Relatedness = "";
SCARFSurveyModel.RelatednessText = "";
SCARFSurveyModel.Fairness = "";
}
else
{
SCARFSurveyModel.SCARFSurveyId = 0;
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "Fail";
}
SCARFSurveyModel.WorkDayId = OnjSCARFSurvey.WorkDayId;
SCARFSurveyModel.managerName = OnjSCARFSurvey.managerName;
SCARFSurveyModel.LearnerName = OnjSCARFSurvey.LearnerName;
SCARFSurveyModel.managerEmailID = OnjSCARFSurvey.managerEmailID;
SCARFSurveyModel.Status = OnjSCARFSurvey.Status;
SCARFSurveyModel.StatusText = OnjSCARFSurvey.StatusText;
SCARFSurveyModel.Certainty = OnjSCARFSurvey.Certainty;
SCARFSurveyModel.CertaintyText = OnjSCARFSurvey.CertaintyText;
SCARFSurveyModel.Autonomy = OnjSCARFSurvey.Autonomy;
SCARFSurveyModel.AutonomyText = OnjSCARFSurvey.AutonomyText;
SCARFSurveyModel.Relatedness = OnjSCARFSurvey.Relatedness;
SCARFSurveyModel.RelatednessText = OnjSCARFSurvey.RelatednessText;
SCARFSurveyModel.Fairness = OnjSCARFSurvey.Fairness;
SCARFSurveyModel.FairnessText = OnjSCARFSurvey.FairnessText;
SCARFSurveyModel.ReportDate = OnjSCARFSurvey.ReportDate;
}
}
catch (Exception ex)
{
string DetailsMessageError = null;
if (ex.InnerException != null)
{
DetailsMessageError = ex.InnerException.Message + " " + ex.StackTrace;
}
else
{
DetailsMessageError = ex.StackTrace;
}
Util.LoggError(new System.Diagnostics.StackFrame(0).GetMethod().Name,
ex.Message, DetailsMessageError);
SCARFSurveyModel.IsErrrorMsg = true;
SCARFSurveyModel.Message = "Exception block: " + DetailsMessageError;
}
return(SCARFSurveyModel);
}
public ActionResult Login(UserMst model, string returnUrl)
{
List <UserMst> courseModelList = null;
try
{
courseModelList = BCBSDataAccess.GetUserInfoById(model);
if (courseModelList != null && courseModelList.Count > 0)
{
foreach (var item in courseModelList)
{
if (item.LoginIsActive == true)
{
UserMst TempLocation = new UserMst();
Session["LoginUserId"] = item.LoginUserId;
TempLocation.LoginUserId = item.LoginUserId;
TempLocation.LoginUserName = item.LoginUserName;
TempLocation.LoginPassword = item.LoginPassword;
TempLocation.LoginEmail = item.LoginEmail;
TempLocation.LoginFirstName = item.LoginFirstName;
TempLocation.LoginLastName = item.LoginLastName;
TempLocation.LoginIsActive = item.LoginIsActive;
courseModelList.Add(TempLocation);
Util.LogInfo("Login", "Successfully Login : "******"Index", "U65Report");
return(RedirectToAction("Index", "SalesReport"));
}
else
{
Session["LoginUserId"] = null;
Session.Abandon();
Util.LogInfo("Login", "User is In-Active. Please contact Administrator : " + item.LoginUserName);
ViewBag.ErrorMessage = "User is In-Active. Please contact Administrator";
}
}
}
else
{
Session["LoginUserId"] = null;
Session.Abandon();
ViewBag.ErrorMessage = "Incorrect user name/password.";
return(View());
}
}
catch (Exception ex)
{
string DetailsMessageError = null;
if (ex.InnerException != null)
{
DetailsMessageError = ex.InnerException.Message + " " + ex.StackTrace;
}
else
{
DetailsMessageError = ex.StackTrace;
}
Util.LoggError(new System.Diagnostics.StackFrame(0).GetMethod().Name,
ex.Message, DetailsMessageError);
}
return(View());
}
public ActionResult SalesExportData()
{
MemoryStream memoryStream = null;
List <SalesCertificate> SalessModelList = null;
const string header = "Workday ID, Learner Name,Completion Status,Report Date,Pre-Assm Result,Pre-Assm Score %, Post-Assm Attempt,Post-Assm Result,Post-Assm Score %,Pre-Q01, Pre-Q02, Pre-Q03, Pre-Q04, Pre-Q05, Pre-Q06, Pre-Q07, Pre-Q08, Pre-Q09, Pre-Q10, Pre-Q11, Pre-Q12, Pre-Q13, Pre-Q14, Pre-Q15, Pre-Q16, Pre-Q17, Pre-Q18, Pre-Q19, Pre-Q20, Pre-Q21, Pre-Q22, Pre-Q23, Pre-Q24, Pre-Q25, Post-Q01, Post-Q02, Post-Q03, Post-Q04, Post-Q05, Post-Q06, Post-Q07, Post-Q08, Post-Q09, Post-Q10, Post-Q11, Post-Q12, Post-Q13, Post-Q14, Post-Q15, Post-Q16, Post-Q17, Post-Q18, Post-Q19, Post-Q20, Post-Q21, Post-Q22, Post-Q23, Post-Q24, Post-Q25";
const string format = "{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26},{27},{28},{29},{30},{31},{32},{33},{34},{35},{36},{37},{38},{39},{40},{41},{42},{43},{44},{45},{46},{47},{48},{49},{50},{51},{52},{53},{54},{55},{56},{57},{58}";
string content = string.Empty;
SalessModelList = BCBSDataAccess.GetDataForSales();
memoryStream = new MemoryStream();
if (SalessModelList != null && SalessModelList.Count > 0)
{
TextWriter tw = new StreamWriter(memoryStream);
tw.WriteLine(header);
foreach (var item in SalessModelList)
{
item.WorkDayId = !String.IsNullOrEmpty(item.WorkDayId) ? (item.WorkDayId.Contains(",") ? item.WorkDayId.Replace(',', '|') : item.WorkDayId) : string.Empty;
item.LearnerName = !String.IsNullOrEmpty(item.LearnerName) ? (item.LearnerName.Contains(",") ? item.LearnerName.Replace(',', '|') : item.LearnerName) : string.Empty;
item.CompletionStatusString = !String.IsNullOrEmpty(item.CompletionStatusString) ? (item.CompletionStatusString.Contains(",") ? item.CompletionStatusString.Replace(',', '|') : item.CompletionStatusString) : string.Empty;
item.ReportDateString = item.ReportDate.ToString("MM/dd/yyyy");
item.PreAssmResultString = !String.IsNullOrEmpty(item.PreAssmResultString) ? (item.PreAssmResultString.Contains(",") ? item.PreAssmResultString.Replace(',', '|') : item.PreAssmResultString) : string.Empty;
item.PreAssmScore = item.PreAssmScore;
//item.PostAssmAttempt = item.PostAssmAttempt;
item.PostAssmResult = item.PostAssmResult;
if (item.PostAssmAttempt == 0)
{
item.PostAssmAttemptString = "NA";
}
else
{
item.PostAssmAttemptString = item.PostAssmAttempt.ToString();
}
if (item.PostAssmAttempt == 0)
{
item.PostAssmResultString = "NA";
}
else
{
item.PostAssmResultString = !String.IsNullOrEmpty(item.PostAssmResultString) ? (item.PostAssmResultString.Contains(",") ? item.PostAssmResultString.Replace(',', '|') : item.PostAssmResultString) : string.Empty;
}
item.PostAssmScore = item.PostAssmScore;
item.Pre_Q01 = item.Pre_Q01;
item.Pre_Q02 = item.Pre_Q02;
item.Pre_Q03 = item.Pre_Q03;
item.Pre_Q03 = item.Pre_Q03;
item.Pre_Q04 = item.Pre_Q04;
item.Pre_Q05 = item.Pre_Q05;
item.Pre_Q06 = item.Pre_Q06;
item.Pre_Q07 = item.Pre_Q07;
item.Pre_Q08 = item.Pre_Q08;
item.Pre_Q09 = item.Pre_Q09;
item.Pre_Q10 = item.Pre_Q10;
item.Pre_Q11 = item.Pre_Q11;
item.Pre_Q12 = item.Pre_Q12;
item.Pre_Q13 = item.Pre_Q13;
item.Pre_Q14 = item.Pre_Q14;
item.Pre_Q15 = item.Pre_Q15;
item.Pre_Q16 = item.Pre_Q16;
item.Pre_Q17 = item.Pre_Q17;
item.Pre_Q18 = item.Pre_Q18;
item.Pre_Q19 = item.Pre_Q19;
item.Pre_Q20 = item.Pre_Q20;
item.Pre_Q21 = item.Pre_Q21;
item.Pre_Q22 = item.Pre_Q22;
item.Pre_Q23 = item.Pre_Q23;
item.Pre_Q24 = item.Pre_Q24;
item.Pre_Q25 = item.Pre_Q25;
item.Post_Q01 = item.Post_Q01;
item.Post_Q02 = item.Post_Q02;
item.Post_Q03 = item.Post_Q03;
item.Post_Q04 = item.Post_Q04;
item.Post_Q05 = item.Post_Q05;
item.Post_Q06 = item.Post_Q06;
item.Post_Q07 = item.Post_Q07;
item.Post_Q08 = item.Post_Q08;
item.Post_Q09 = item.Post_Q09;
item.Post_Q10 = item.Post_Q10;
item.Post_Q11 = item.Post_Q11;
item.Post_Q12 = item.Post_Q12;
item.Post_Q13 = item.Post_Q13;
item.Post_Q14 = item.Post_Q14;
item.Post_Q15 = item.Post_Q15;
item.Post_Q16 = item.Post_Q16;
item.Post_Q17 = item.Post_Q17;
item.Post_Q18 = item.Post_Q18;
item.Post_Q19 = item.Post_Q19;
item.Post_Q20 = item.Post_Q20;
item.Post_Q21 = item.Post_Q21;
item.Post_Q22 = item.Post_Q22;
item.Post_Q23 = item.Post_Q23;
item.Post_Q24 = item.Post_Q24;
item.Post_Q25 = item.Post_Q25;
content = string.Format(format, item.WorkDayId, item.LearnerName, item.CompletionStatusString, item.ReportDateString, item.PreAssmResultString, item.PreAssmScore, item.PostAssmAttemptString, item.PostAssmResultString, item.PostAssmScore, item.Pre_Q01, item.Pre_Q02, item.Pre_Q03, item.Pre_Q04, item.Pre_Q05, item.Pre_Q06, item.Pre_Q07, item.Pre_Q08, item.Pre_Q09, item.Pre_Q10, item.Pre_Q11, item.Pre_Q12, item.Pre_Q13, item.Pre_Q14, item.Pre_Q15, item.Pre_Q16, item.Pre_Q17, item.Pre_Q18, item.Pre_Q19, item.Pre_Q20, item.Pre_Q21, item.Pre_Q22, item.Pre_Q23, item.Pre_Q24, item.Pre_Q25, item.Post_Q01, item.Post_Q02, item.Post_Q03, item.Post_Q04, item.Post_Q05, item.Post_Q06, item.Post_Q07, item.Post_Q08, item.Post_Q09, item.Post_Q10, item.Post_Q11, item.Post_Q12, item.Post_Q13, item.Post_Q14, item.Post_Q15, item.Post_Q16, item.Post_Q17, item.Post_Q18, item.Post_Q19, item.Post_Q20, item.Post_Q21, item.Post_Q22, item.Post_Q23, item.Post_Q24, item.Post_Q25);
tw.WriteLine(content);
}
tw.Flush();
}
string contentType = "application/octet-stream";
byte[] pdfdata = null;
pdfdata = memoryStream.ToArray();
var filaName = (ConfigurationManager.AppSettings["ProjectName"]);
var Datetime = "";
Datetime = DateTime.Now.ToString("dd_MM_yyyy_T_HH:mm");
return(File(pdfdata, contentType, filaName + "_ExportData_" + Datetime + ".csv"));
}
