public ActionResult Login(Login model)
{
//Declaring variable Result that will hold true or false, depends on db search result
String Result;
//Declaring and instantiating hopeCRMEntities object (db instance)
using (DSGVOEntities1 db = new DSGVOEntities1())
{
db.Database.Connection.Open();
//Declaring List of customers that will contain certain customer or null
List <kunden> customer = db.kundens.Where(t => t.plz == model.password.ToString().Trim() && t.seriennr.Substring(15).Trim() == model.username.ToString().Trim()).ToList();
//Define empty User object
UserInfo user = new UserInfo();
//Checking if customer exists or not and filling user object with corresponding value
if (customer.Count != 0)
{
Result = "True";
Session["isLoggedIn"] = 1;
Session["userZip"] = customer[0].plz.ToString().Trim();
Session["serialNo"] = customer[0].seriennr.Substring(15).Trim();
user.Result = Result;
user.UserZip = customer[0].plz.ToString().Trim();
user.UserEmail = customer[0].email.ToString().Trim();
user.UserSerialNo = customer[0].seriennr.Substring(15).Trim();
//Writting into log file (user zip, email, date and time)
using (StreamWriter writer = new StreamWriter(Server.MapPath("~/Log/log.txt"), true))
{
//Declaring and instatiating object of String Builder class, that will append current row
StringBuilder sb = new StringBuilder();
sb.Append(user.UserZip + " " + user.UserEmail + " " + DateTime.Now.ToString("dd.MM.yyyy hh:mm tt", CultureInfo.InvariantCulture));
//Write row with login data into txt file
writer.WriteLine(sb.ToString());
}
}
else
{
//If user is not found set false as result
Result = "False";
user.Result = Result;
}
//Returning user as result in Json format
return(Json(user));
}
}
// GET: Dashboard
public ActionResult Index()
{
//Check if user is logged, if is open dashboard
if (Convert.ToInt32(Session["isLoggedIn"]) == 1 && Session["userZip"].ToString().Trim() == Request["zip"].ToString().Trim() && Session["serialNo"].ToString().Trim() == Request["serialno"].ToString().Trim())
{
ViewBag.Zip = Request["zip"].ToString().Trim();
ViewBag.Email = Request["email"].ToString().Trim();
//Get data from db for current user
DSGVOEntities1 db = new DSGVOEntities1();
string zip = Request["zip"].ToString().Trim();
string serialno = Request["serialno"].ToString().Trim();
kunden CurrentUser = db.kundens.Where(t => t.plz == zip && t.seriennr.Substring(15).Trim() == serialno).First();
//Adding user data to viewbag
if (CurrentUser.name1 != null)
{
ViewBag.AgName1 = CurrentUser.name1.ToString().Trim();
}
if (CurrentUser.name2 != null)
{
ViewBag.AgName2 = CurrentUser.name2.ToString().Trim();
}
if (CurrentUser.strasse != null)
{
ViewBag.Street = CurrentUser.strasse.ToString().Trim();
}
if (CurrentUser.plz != null)
{
ViewBag.Zip = CurrentUser.plz.ToString().Trim();
}
if (CurrentUser.ort != null)
{
ViewBag.City = CurrentUser.ort.ToString().Trim();
}
if (CurrentUser.land != null)
{
//Set country
switch (CurrentUser.land.ToString().Trim())
{
case "D":
CurrentUser.land = "Deutschland";
break;
case "A":
CurrentUser.land = "Österreich";
break;
case "CH":
CurrentUser.land = "Schweiz";
break;
default:
break;
}
ViewBag.Country = CurrentUser.land.ToString().Trim();
}
if (CurrentUser.email != null)
{
ViewBag.AgContact = CurrentUser.email.ToString().Trim();
}
//Generating strong name as word and pdf name
string HashName = UserInfo.CalculateMD5Hash(Request["serialno"].ToString().Trim() + "-" + Request["zip"].ToString().Trim());
string pdfFile = Server.MapPath("~/Pdf/").ToString() + HashName + ".pdf";
if (System.IO.File.Exists(pdfFile))
{
ViewBag.ExistingPdf = true;
ViewBag.PdfName = HashName;
}
else
{
ViewBag.PdfName = "#";
ViewBag.ExistingPdf = false;
}
//Set serial no
ViewBag.SerialNo = Session["serialNo"].ToString().Trim();
return(View());
}
//If not open login page
else
{
return(RedirectToAction("index", "home"));
}
}
public ActionResult CreateDocumentsFromTemplate(ContractDetails details)
{
//Get data from db for current user
DSGVOEntities1 db = new DSGVOEntities1();
kunden CurrentUser = db.kundens.Where(t => t.plz == details.UserZip.ToString().Trim() && t.seriennr.Substring(15).Trim() == details.SerialNo.ToString().Trim()).First();
////Update contractuser in db
//CurrentUser.contractuser = details.ContractUser.ToString().Trim();
////Change email if it is changed
//if (CurrentUser.email.ToString().Trim() != details.Email.ToString().Trim())
//{
// CurrentUser.email = details.Email.ToString().Trim();
//}
//db.SaveChanges();
//Check if changes in data exist and send it in email
StringBuilder dataChanges = new StringBuilder();
bool ChangesExist = false;
dataChanges.Append("<table>");
dataChanges.Append(" <tr><th>Previous data</th><th>Changed data from user</th></tr>");
if (CurrentUser.name1.ToString().Trim() != details.Name1.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.name1.ToString().Trim() + " </td><td>" + details.Name1.ToString().Trim() + "</td></tr>");
CurrentUser.name1 = details.Name1.ToString().Trim();
}
if (CurrentUser.name2.ToString().Trim() != details.Name2.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.name2.ToString().Trim() + " </td><td>" + details.Name2.ToString().Trim() + "</td></tr>");
CurrentUser.name2 = details.Name2.ToString().Trim();
}
if (CurrentUser.strasse.ToString().Trim() != details.Street.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.strasse.ToString().Trim() + " </td><td>" + details.Street.ToString().Trim() + "</td></tr>");
CurrentUser.strasse = details.Street.ToString().Trim();
}
if (CurrentUser.plz.ToString().Trim() != details.Zip.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.plz.ToString().Trim() + " </td><td>" + details.Zip.ToString().Trim() + "</td></tr>");
CurrentUser.plz = details.Zip.ToString().Trim();
}
if (CurrentUser.ort.ToString().Trim() != details.City.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.ort.ToString().Trim() + " </td><td>" + details.City.ToString().Trim() + "</td></tr>");
CurrentUser.ort = details.City.ToString().Trim();
}
//if (CurrentUser.land.ToString().Trim() != details.Country.ToString().Trim())
//{
// ChangesExist = true;
// dataChanges.Append(" <tr><td>" + CurrentUser.land.ToString().Trim() + " </td><td>" + details.Country.ToString().Trim() + "</td></tr>");
//}
if (CurrentUser.email.ToString().Trim() != details.Email.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.email.ToString().Trim() + " </td><td>" + details.Email.ToString().Trim() + "</td></tr>");
CurrentUser.email = details.Email.ToString().Trim();
}
//if (CurrentUser.contractuser == null)
//{
// ChangesExist = true;
// dataChanges.Append(" <tr><td>Empty</td><td>" + details.ContractUser.ToString().Trim() + "</td></tr>");
//}
////Adding user data to viewbag
//if (CurrentUser.name1 != null)
//{
// details.Name1 = CurrentUser.name1.ToString().Trim();
//}
//if (CurrentUser.name2 != null)
//{
// details.Name2 = CurrentUser.name2.ToString().Trim();
//}
//if (CurrentUser.strasse != null)
//{
// details.Street= CurrentUser.strasse.ToString().Trim() + " " ;
//}
//if (CurrentUser.ort != null)
//{
// details.City= CurrentUser.ort.ToString().Trim();
//}
//if (CurrentUser.land != null)
//{
// //Set country
// switch (CurrentUser.land.ToString().Trim())
// {
// case "D":
// CurrentUser.land = "Deutschland";
// break;
// case "A":
// CurrentUser.land = "Österreich";
// break;
// case "CH":
// CurrentUser.land = "Schweiz";
// break;
// default:
// break;
// }
// details.Country = CurrentUser.land.ToString().Trim();
//}
//if (CurrentUser.email != null)
//{
// details.Contact = CurrentUser.email.ToString().Trim();
//}
// Set country
switch (details.Country.ToString().Trim())
{
case "D":
details.Country = "Deutschland";
break;
case "A":
details.Country = "Österreich";
break;
case "CH":
details.Country = "Schweiz";
break;
default:
break;
}
string Result, Name;
//Generating strong name as word and pdf name
string HashName = UserInfo.CalculateMD5Hash(details.SerialNo + "-" + details.UserZip);
try
{
Spire.Doc.Document document = new Spire.Doc.Document();
document.LoadFromFile(Server.MapPath("~/Template/template.docx").ToString());
if (details.Name1 != null && details.Name1.ToString().Trim() != "")
{
document.Replace("##AGName1##", details.Name1, false, true);
}
else
{
document.Replace("##AGName1##", "", false, true);
}
if (details.Name2 != null && details.Name2.ToString().Trim() != "")
{
document.Replace("##AGName2##", details.Name2, false, true);
}
else
{
document.Replace("##AGName2##", "", false, true);
}
if (details.Street != null && details.Street.ToString().Trim() != "")
{
document.Replace("##AGStreet##", details.Street, false, true);
}
else
{
document.Replace("##AGStreet##", "", false, true);
}
if (details.Zip != null && details.Zip.ToString().Trim() != "")
{
document.Replace("##AGZIP##", details.Zip, false, true);
}
else
{
document.Replace("##AGZIP##", "", false, true);
}
if (details.City != null && details.City.ToString().Trim() != "")
{
document.Replace("##AGCITY##", details.City, false, true);
document.Replace("##City##", details.City, false, true);
}
else
{
document.Replace("##AGCITY##", "", false, true);
document.Replace("##City##", "", false, true);
}
if (details.Country != null && details.Country.ToString().Trim() != "")
{
document.Replace("##AGCountry##", details.Country, false, true);
}
else
{
document.Replace("##AGCountry##", "", false, true);
}
if (details.ContractUser != null && details.ContractUser.ToString().Trim() != "")
{
document.Replace("##ContractUser##", details.ContractUser, false, true);
}
if (details.Email != null && details.Email.ToString().Trim() != "")
{
document.Replace("##AGCONTACT##", details.Email, false, true);
}
else
{
document.Replace("##AGCONTACT##", "", false, true);
}
document.Replace("##DayDate##", DateTime.Now.ToString("dd.MM.yyyy"), false, true);
document.SaveToFile(Server.MapPath("~/Word/").ToString() + HashName + ".docx", Spire.Doc.FileFormat.Docx);
//Code for making connection with existing word template
Microsoft.Office.Interop.Word._Application wApp = new Microsoft.Office.Interop.Word.Application();
Microsoft.Office.Interop.Word.Documents wDocs = wApp.Documents;
Microsoft.Office.Interop.Word._Document wDoc = wDocs.Open(Server.MapPath("~/Word/").ToString() + HashName + ".docx", ReadOnly: false, Visible: false);
wDoc.Activate();
string pdfName = @Server.MapPath("~/Pdf/").ToString() + HashName + ".pdf";
//wDoc.ExportAsFixedFormat(OutputFileName: pdfName, ExportFormat: WdExportFormat.wdExportFormatPDF, UseISO19005_1: true);
wDoc.ExportAsFixedFormat(
pdfName,
WdExportFormat.wdExportFormatPDF,
OptimizeFor: WdExportOptimizeFor.wdExportOptimizeForPrint,
BitmapMissingFonts: true,
DocStructureTags: false,
UseISO19005_1: true);
wDoc.Close();
//Update fields into db
CurrentUser.contractuser = details.ContractUser;
CurrentUser.contactperson = details.ContractUser;
CurrentUser.contractsigned = true;
CurrentUser.signeddate = DateTime.Now;
CurrentUser.contractname = HashName + ".pdf";
//Send email with pdf as attachment to office
SmtpClient smtpClient = new SmtpClient();
NetworkCredential basicCredential =
new NetworkCredential("*****@*****.**", "hopeDSGVO");
System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();
MailAddress fromAddress = new MailAddress("*****@*****.**");
smtpClient.Host = "smtp.1und1.de";
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = basicCredential;
smtpClient.Port = 587;
smtpClient.EnableSsl = true;
message.From = fromAddress;
message.Subject = "hope-DSGVO - AV-Vertrag, Kunde: " + details.UserZip + " - hotel: " + details.Name1;
message.Attachments.Add(new System.Net.Mail.Attachment(Server.MapPath("~/Pdf/").ToString() + HashName + ".pdf"));
//[email protected]
message.To.Add(new MailAddress("*****@*****.**"));
smtpClient.Send(message);
//Send email to customer
SmtpClient smtpCustomer = new SmtpClient();
NetworkCredential basicCredentialCustomer =
new NetworkCredential("*****@*****.**", "hopeDSGVO");
System.Net.Mail.MailMessage messageCustomer = new System.Net.Mail.MailMessage();
MailAddress fromAddressCompany = new MailAddress("*****@*****.**");
smtpCustomer.Host = "smtp.1und1.de";
smtpCustomer.UseDefaultCredentials = false;
smtpCustomer.Credentials = basicCredential;
smtpCustomer.Port = 587;
smtpCustomer.EnableSsl = true;
messageCustomer.From = fromAddressCompany;
messageCustomer.Subject = "hope-DSGVO - AV-Vertrag, Kunde: " + details.UserZip + " - hotel: " + details.Name1;
messageCustomer.Attachments.Add(new System.Net.Mail.Attachment(Server.MapPath("~/Pdf/").ToString() + HashName + ".pdf"));
//[email protected]
messageCustomer.To.Add(new MailAddress(CurrentUser.email.ToString().Trim()));
smtpCustomer.Send(messageCustomer);
//Send email if user changed data on html form [email protected]
if (ChangesExist)
{
//Send email with pdf as attachemnt
SmtpClient smtpClientSecond = new SmtpClient();
NetworkCredential basicCredentialSecond =
new NetworkCredential("*****@*****.**", "hopeDSGVO");
System.Net.Mail.MailMessage messageSecond = new System.Net.Mail.MailMessage();
MailAddress fromAddressSecond = new MailAddress("*****@*****.**");
smtpClientSecond.Host = "smtp.1und1.de";
smtpClientSecond.UseDefaultCredentials = false;
smtpClientSecond.Credentials = basicCredential;
smtpClientSecond.Port = 587;
smtpClientSecond.EnableSsl = true;
messageSecond.From = fromAddress;
messageSecond.Subject = "hope-DSGVO - Kundendaten geändert: " + details.UserZip + " - hotel: " + details.Name1;
messageSecond.IsBodyHtml = true;
messageSecond.Body = dataChanges.ToString();
//[email protected]
messageSecond.To.Add(new MailAddress("*****@*****.**"));
smtpClientSecond.Send(message);
//Update field in database
CurrentUser.datachanged = true;
}
//Update field in database
db.SaveChanges();
return(Json(new { Result = "true", Name = HashName }));
}
catch (Exception ex)
{
Console.WriteLine("Error occured:", ex.ToString());
return(Json(Result = ex.ToString()));
}
finally
{
Dispose();
}
}
