// GET: ListUsers/Delete/5
public ActionResult Delete(string id)
{
string role = null;
ViewData["Role"] = "";
IEnumerable <string> roles = new List <string>();
roles = ((ClaimsIdentity)User.Identity).Claims
.Where(ca => ca.Type == ClaimTypes.Role)
.Select(ca => ca.Value);
foreach (var x in roles)
{
role = x;
}
if (role != null)
{
ViewData["Role"] = role;
}
aspnetuser u = new aspnetuser();
u = userService.getUser(id);
u.cvs = null;
cv c = s.Get(x => x.user_idUser.Equals(id));
c.user_idUser = null;
c.aspnetuser = null;
s.Delete(c);
s.Commit();
userService.Delete(u);
userService.Commit();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(string id)
{
poduzeće poduzeće = await db.poduzeće.FindAsync(id);
var slike = await(from c in db.slika where c.idPoduzeća.Equals(id) select c).ToListAsync();
if (slike.Count != 0)
{
foreach (slika slika in slike)
{
slika s = db.slika.Find(slika.idSlika);
string putanjaSlike = Server.MapPath(s.putanjaSlike);
if (System.IO.File.Exists(putanjaSlike))
{
System.IO.File.Delete(putanjaSlike);
}
db.slika.Remove(s);
await db.SaveChangesAsync();
}
}
aspnetuser aspnetuser = await db.aspnetusers.FindAsync(id);
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
db.aspnetusers.Remove(aspnetuser);
db.poduzeće.Remove(poduzeće);
await db.SaveChangesAsync();
return(RedirectToAction("Index", "Home"));
}
public ActionResult Index()
{
ViewData["Name"] = sAccount.getUser(User.Identity.GetUserId()).Name;
ViewData["Picture"] = sAccount.getUser(User.Identity.GetUserId()).ImagePath;
string role = null;
ViewData["Role"] = "";
IEnumerable <string> roles = new List <string>();
roles = ((ClaimsIdentity)User.Identity).Claims
.Where(c => c.Type == ClaimTypes.Role)
.Select(c => c.Value);
foreach (var x in roles)
{
role = x;
}
if (role != null)
{
ViewData["Role"] = role;
}
aspnetuser u = new aspnetuser();
ServiceAccount s = new ServiceAccount();
u = s.getUser(User.Identity.GetUserId());
return(View(u));
}
public JObject IsUserVerified(UserDTO model)
{
JObject data = new JObject();
aspnetuser user = _us.GetUserDataByUsername(model.username);
data.Add("email", user.EmailConfirmed == true ? true : false);
data.Add("phone", user.PhoneNumberConfirmed == true ? true : false);
return(data);
}
public int UpdateUser(User editedUser)
{
aspnetuser editedUserDb = GetUserDataByUsername(editedUser.UserName);
editedUserDb.UserName = editedUser.UserName;
editedUserDb.FirstName = editedUser.FirstName;
editedUserDb.LastName = editedUser.LastName;
editedUserDb.City = editedUser.City;
editedUserDb.Address = editedUser.Address;
editedUserDb.Municipality = editedUser.Municipality;
editedUserDb.MobilePhoneNumber = editedUser.MobilePhoneNumber;
editedUserDb.Email = editedUser.Email;
editedUserDb.DateOfBirth = editedUser.DateOfBirth;
editedUserDb.EMBG = editedUser.EMBG;
editedUserDb.Gender = editedUser.Gender;
editedUserDb.PassportNumber = editedUser.PassportNumber;
editedUserDb.PostalCode = editedUser.PostalCode;
editedUserDb.PhoneNumber = editedUser.PhoneNumber;
var userRole = editedUserDb.aspnetroles.FirstOrDefault();
if (userRole != null && userRole.Name != editedUser.Role)
{
aspnetrole previousUserRole = _db.aspnetroles.Where(x => x.Name == userRole.Name).FirstOrDefault();
if (previousUserRole != null)
{
editedUserDb.aspnetroles.Remove(previousUserRole);
}
AuthRepository _repo = new AuthRepository();
try
{
_repo.AddUserToRole(editedUserDb.Id, editedUser.Role);
}
catch (Exception ex)
{
}
}
int result = -1;
try
{
result = _db.SaveChanges();
}
catch (Exception ex)
{
}
return(result);
}
public async Task <ActionResult> Index(aspnetuser ua)
{
string role = null;
ViewData["Role"] = "";
IEnumerable <string> roles = new List <string>();
roles = ((ClaimsIdentity)User.Identity).Claims
.Where(c => c.Type == ClaimTypes.Role)
.Select(c => c.Value);
foreach (var x in roles)
{
role = x;
}
if (role != null)
{
ViewData["Role"] = role;
}
ServiceAccount s = new ServiceAccount();
ua.Id = User.Identity.GetUserId();
ApplicationUser model = UserManager.FindById(User.Identity.GetUserId());
model.Last_Name = ua.Last_Name;
model.Name = ua.Name;
var file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Images/"), fileName);
model.ImagePath = fileName;
file.SaveAs(path);
}
IdentityResult result = await UserManager.UpdateAsync(model);
if (result.Succeeded)
{
return(RedirectToAction("Index"));
}
return(null);
// TODO: Add update logic here
}
public bool ChangeStatus(string username)
{
aspnetuser user = _db.aspnetusers.Where(x => x.UserName == username).FirstOrDefault();
int status = user.Active.Value;
switch (status)
{
case 1: user.Active = 0; break;
case 0: user.Active = 1; break;
}
var result = _db.SaveChanges();
return(result == 1);
}
public List <travel_policy> GetEndUserExpiringPolicies(string userId, DateTime dateFrom)
{
if (userId == "")
{
return(null);
}
aspnetuser currentUser = _db.aspnetusers.FirstOrDefault(x => x.Id == userId);
if (currentUser == null)
{
return(null);
}
return(_db.travel_policy.Where(x => (x.Created_By == userId ||
x.insured.SSN == currentUser.EMBG ||
_db.policy_insured.Where(h => h.PolicyID == x.ID).Select(k => k.insured.SSN).ToList().Contains(currentUser.EMBG)) &&
x.End_Date < dateFrom && x.End_Date > DateTime.Now).ToList());
}
public bool IsUser(string role, string username)
{
bool authorize = false;
aspnetuser aspnetuser = context.aspnetusers.FirstOrDefault(m => m.UserName == username);
if (aspnetuser == null)
{
return(authorize);
}
if (aspnetuser.aspnetroles.Count == 0)
{
return(authorize);
}
authorize = aspnetuser.aspnetroles.FirstOrDefault() != null?aspnetuser.aspnetroles.FirstOrDefault().Name == role : false;
return(authorize);
}
//mjenjanje lozinke - get
public async Task <ActionResult> ChangePassword(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
aspnetuser aspnetusers = await db.aspnetusers.FindAsync(id);
if (aspnetusers == null)
{
return(HttpNotFound());
}
PromijeniLozinku promijeniLozinku = new PromijeniLozinku {
ID = id
};
return(View("~/Views/Korisnik/ChangePassword.cshtml", promijeniLozinku));
}
public bool IsUser(string role)
{
bool authorize = false;
var user = System.Web.HttpContext.Current.User;
aspnetuser aspnetuser = context.aspnetusers.Where(m => m.UserName == user.Identity.Name).FirstOrDefault();
if (aspnetuser == null)
{
return(authorize);
}
if (aspnetuser.aspnetroles.Count == 0)
{
authorize = false;
return(authorize);
}
authorize = aspnetuser.aspnetroles.FirstOrDefault() != null?aspnetuser.aspnetroles.FirstOrDefault().Name == role : false;
return(authorize);
}
public ActionResult Index()
{
var genderList = Gender();
var roles = _rs.GetAll().ToList();
aspnetuser userEdit = _us.GetUserDataByUsername(System.Web.HttpContext.Current.User.Identity.Name);
if (userEdit == null)
{
return(View());
}
User userEditModel = Mapper.Map <aspnetuser, User>(userEdit);
foreach (var role in roles)
{
if (role.Selected)
{
role.Selected = false;
}
if (role.Text == userEditModel.Role)
{
role.Selected = true;
}
}
foreach (var gender in genderList)
{
if (gender.Text == userEditModel.Gender)
{
gender.Selected = true;
}
}
ViewBag.Roles = roles;
ViewBag.Gender = genderList;
return(View(userEditModel));
}
public async Task <ActionResult> DeleteConfirmed(string id)
{
korisnik korisnik = await db.korisnik.FindAsync(id);
if (korisnik.putanjaDoProfilneSlike != null)
{
string putanjaSlike = Server.MapPath(korisnik.putanjaDoProfilneSlike);
if (System.IO.File.Exists(putanjaSlike))
{
System.IO.File.Delete(putanjaSlike);
}
}
aspnetuser aspnetuser = await db.aspnetusers.FindAsync(id);
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
db.aspnetusers.Remove(aspnetuser);
db.korisnik.Remove(korisnik);
await db.SaveChangesAsync();
return(RedirectToAction("Index", "Home"));
}
public JObject RetrieveUserInformation(UserDTO username)
{
JObject data = new JObject();
aspnetuser user = _us.GetUserDataByUsername(username.username);
if (user == null)
{
throw new HttpResponseException(System.Net.HttpStatusCode.NotFound);
}
//information about the user
var userJson = new JObject();
userJson.Add("User_ID", user.Id);
userJson.Add("FirstName", user.FirstName);
userJson.Add("LastName", user.LastName);
userJson.Add("Municipality", user.Municipality);
userJson.Add("MobilePhoneNumber", user.MobilePhoneNumber);
userJson.Add("PassportNumber", user.PassportNumber);
userJson.Add("PostalCode", user.PostalCode);
userJson.Add("PhoneNumber", user.PhoneNumber);
userJson.Add("EMBG", user.EMBG);
userJson.Add("DateOfBirth", user.DateOfBirth);
userJson.Add("Gender", user.Gender);
userJson.Add("City", user.City);
userJson.Add("Address", user.Address);
userJson.Add("Email", user.Email);
data.Add("user", userJson);
//user's policies
JArray userPolicies = new JArray();
travel_policy[] policies = _ps.GetPolicyByUsernameId(user.Id);
foreach (travel_policy policy in policies)
{
var userPolicy = new JObject();
userPolicy.Add("ID", policy.ID);
userPolicy.Add("Policy_Number", policy.Policy_Number);
userPolicy.Add("Exchange_RateID", policy.Exchange_RateID);
userPolicy.Add("CountryID", policy.CountryID);
userPolicy.Add("Policy_TypeID", policy.Policy_TypeID);
userPolicy.Add("Retaining_RiskID", policy.Retaining_RiskID);
userPolicy.Add("Start_Date", policy.Start_Date);
userPolicy.Add("End_Date", policy.End_Date);
userPolicy.Add("Valid_Days", policy.Valid_Days);
userPolicy.Add("Travel_NumberID", policy.Travel_NumberID);
userPolicy.Add("Travel_Insurance_TypeID", policy.Travel_Insurance_TypeID);
userPolicy.Add("Created_By", policy.Created_By);
userPolicy.Add("Date_Created", policy.Date_Created);
userPolicy.Add("Date_Modified", policy.Date_Modified);
userPolicy.Add("Modified_By", policy.Modified_By);
userPolicy.Add("Payment_Status", policy.Modified_By);
userPolicy.Add("Date_Cancellation", policy.Modified_By);
//information about policy holder
if (policy.insured != null)
{
userPolicy.Add("Policy_HolderID", policy.Policy_HolderID);
userPolicy.Add("Name", policy.insured.Name);
userPolicy.Add("Lastname", policy.insured.Lastname);
userPolicy.Add("SSN", policy.insured.SSN);
userPolicy.Add("DateBirth", policy.insured.DateBirth);
userPolicy.Add("Age", policy.insured.Age);
userPolicy.Add("Email", policy.insured.Email);
userPolicy.Add("Phone_Number", policy.insured.Phone_Number);
userPolicy.Add("City", policy.insured.City);
userPolicy.Add("Postal_Code", policy.insured.Postal_Code);
userPolicy.Add("Address", policy.insured.Address);
userPolicy.Add("Passport_Number_IdNumber", policy.insured.Passport_Number_IdNumber);
userPolicy.Add("Type_InsuredID", policy.insured.Type_InsuredID);
//bank account for the policy holder
var ssn = _us.GetUserSsnByUsername(username.username);
var holderDetails = _iss.GetInsuredDataBySsn(ssn);
if (holderDetails != null)
{
JArray bankAccounts = new JArray();
var banks = _bas.BankAccountsByInsuredId(holderDetails.ID);
foreach (bank_account_info bankAccount in banks)
{
var bankAccountObject = new JObject();
bankAccountObject.Add("BankAccount", bankAccount.Account_Number);
bankAccountObject.Add("BankName", bankAccount.bank.Name);
bankAccountObject.Add("BankAccountId", bankAccount.ID);
bankAccounts.Add(bankAccountObject);
}
userPolicy.Add("policyHolderBankAccounts", bankAccounts);
}
}
//information about insureds
if (policy.policy_insured != null)
{
JArray policyInsureds = new JArray();
foreach (var insured in policy.policy_insured)
{
var policyInsured = new JObject();
policyInsured.Add("Insured_ID", policy.Policy_HolderID);
policyInsured.Add("Name", policy.insured.Name);
policyInsured.Add("Lastname", policy.insured.Lastname);
policyInsured.Add("SSN", policy.insured.SSN);
policyInsured.Add("DateBirth", policy.insured.DateBirth);
policyInsured.Add("Age", policy.insured.Age);
policyInsured.Add("Email", policy.insured.Email);
policyInsured.Add("Phone_Number", policy.insured.Phone_Number);
policyInsured.Add("City", policy.insured.City);
policyInsured.Add("Postal_Code", policy.insured.Postal_Code);
policyInsured.Add("Address", policy.insured.Address);
policyInsured.Add("Passport_Number_IdNumber", policy.insured.Passport_Number_IdNumber);
policyInsured.Add("Type_InsuredID", policy.insured.Type_InsuredID);
JArray bankAccounts = new JArray();
var banks = _bas.BankAccountsByInsuredId(insured.InsuredID);
foreach (bank_account_info bankAccount in banks)
{
var bankAccountObject = new JObject();
bankAccountObject.Add("BankAccount", bankAccount.Account_Number);
bankAccountObject.Add("BankName", bankAccount.bank.Name);
bankAccountObject.Add("BankAccountId", bankAccount.ID);
bankAccounts.Add(bankAccountObject);
}
policyInsured.Add("insuredBankAccounts", bankAccounts);
policyInsureds.Add(policyInsured);
}
userPolicy.Add("insureds", policyInsureds);
}
userPolicies.Add(userPolicy);
}
data.Add("policy", userPolicies);
// user's quotes
JArray userQuotes = new JArray();
travel_policy[] quotes = _ps.GetPolicyNotPayedByUsernameId(user.Id);
foreach (travel_policy policy in quotes)
{
var userQuote = new JObject();
userQuote.Add("Policy_Number", policy.Policy_Number);
userQuote.Add("Exchange_RateID", policy.Exchange_RateID);
userQuote.Add("CountryID", policy.CountryID);
userQuote.Add("Policy_TypeID", policy.Policy_TypeID);
userQuote.Add("Retaining_RiskID", policy.Retaining_RiskID);
userQuote.Add("Start_Date", policy.Start_Date);
userQuote.Add("End_Date", policy.End_Date);
userQuote.Add("Valid_Days", policy.Valid_Days);
userQuote.Add("Travel_NumberID", policy.Travel_NumberID);
userQuote.Add("Group_Members", policy.Group_Members);
userQuote.Add("Group_Total_Premium", policy.Group_Total_Premium);
userQuote.Add("Created_By", policy.Created_By);
userQuote.Add("Date_Created", policy.Date_Created);
userQuote.Add("Date_Modified", policy.Date_Modified);
userQuote.Add("Modified_By", policy.Modified_By);
userQuote.Add("Payment_Status", policy.Modified_By);
userQuote.Add("Date_Cancellation", policy.Modified_By);
//information about policy holder
if (policy.insured != null)
{
userQuote.Add("Policy_HolderID", policy.Policy_HolderID);
userQuote.Add("Name", policy.insured.Name);
userQuote.Add("Lastname", policy.insured.Lastname);
userQuote.Add("SSN", policy.insured.SSN);
userQuote.Add("DateBirth", policy.insured.DateBirth);
userQuote.Add("Age", policy.insured.Age);
userQuote.Add("Email", policy.insured.Email);
userQuote.Add("Phone_Number", policy.insured.Phone_Number);
userQuote.Add("City", policy.insured.City);
userQuote.Add("Postal_Code", policy.insured.Postal_Code);
userQuote.Add("Address", policy.insured.Address);
userQuote.Add("Passport_Number_IdNumber", policy.insured.Passport_Number_IdNumber);
userQuote.Add("Type_InsuredID", policy.insured.Type_InsuredID);
//bank account for the policy holder
var ssn = _us.GetUserSsnByUsername(username.username);
var holderDetails = _iss.GetInsuredDataBySsn(ssn);
if (holderDetails != null)
{
JArray bankAccounts = new JArray();
var banks = _bas.BankAccountsByInsuredId(holderDetails.ID);
foreach (bank_account_info bankAccount in banks)
{
var bankAccountObject = new JObject();
bankAccountObject.Add("BankAccount", bankAccount.Account_Number);
bankAccountObject.Add("BankName", bankAccount.bank.Name);
bankAccountObject.Add("BankAccountId", bankAccount.ID);
bankAccounts.Add(bankAccountObject);
}
userQuote.Add("policyHolderBankAccounts", bankAccounts);
}
}
//information about insureds
if (policy.policy_insured != null)
{
JArray quoteInsureds = new JArray();
foreach (var insured in policy.policy_insured)
{
var quoteInsured = new JObject();
quoteInsured.Add("ID", policy.Policy_HolderID);
quoteInsured.Add("Name", policy.insured.Name);
quoteInsured.Add("Lastname", policy.insured.Lastname);
quoteInsured.Add("SSN", policy.insured.SSN);
quoteInsured.Add("DateBirth", policy.insured.DateBirth);
quoteInsured.Add("Age", policy.insured.Age);
quoteInsured.Add("Email", policy.insured.Email);
quoteInsured.Add("Phone_Number", policy.insured.Phone_Number);
quoteInsured.Add("City", policy.insured.City);
quoteInsured.Add("Postal_Code", policy.insured.Postal_Code);
quoteInsured.Add("Address", policy.insured.Address);
quoteInsured.Add("Passport_Number_IdNumber", policy.insured.Passport_Number_IdNumber);
quoteInsured.Add("Type_InsuredID", policy.insured.Type_InsuredID);
JArray bankAccounts = new JArray();
var banks = _bas.BankAccountsByInsuredId(insured.InsuredID);
foreach (bank_account_info bankAccount in banks)
{
var bankAccountObject = new JObject();
bankAccountObject.Add("BankAccount", bankAccount.Account_Number);
bankAccountObject.Add("BankName", bankAccount.bank.Name);
bankAccountObject.Add("BankAccountId", bankAccount.ID);
bankAccounts.Add(bankAccountObject);
}
quoteInsured.Add("insuredBankAccounts", bankAccounts);
quoteInsureds.Add(quoteInsured);
}
userQuote.Add("insureds", quoteInsureds);
}
userQuotes.Add(userQuote);
}
data.Add("quote", userQuotes);
//user's reports of loss
JArray userFNOL = new JArray();
first_notice_of_loss[] fnols = _fnls.GetByInsuredUserId(user.Id);
foreach (first_notice_of_loss fnol in fnols)
{
var fnolObject = new JObject();
if (fnol.Short_Detailed == true)
{
fnolObject.Add("ChatId", fnol.ChatId);
fnolObject.Add("ID", fnol.ID);
fnolObject.Add("Policy_Number", fnol.travel_policy.Policy_Number);
fnolObject.Add("Short_Detailed", fnol.Short_Detailed);
}
else
{
fnolObject.Add("ID", fnol.ID);
fnolObject.Add("PolicyId", fnol.PolicyId);
fnolObject.Add("Policy_Number", fnol.travel_policy.Policy_Number);
if (fnol.insured != null)
{
var claimantBankAccount = _bas.BankAccountInfoById(fnol.Claimant_bank_accountID);
fnolObject.Add("Claimant_ID", fnol.insured.ID);
fnolObject.Add("Name", fnol.insured.Name);
fnolObject.Add("Lastname", fnol.insured.Lastname);
fnolObject.Add("SSN", fnol.insured.SSN);
fnolObject.Add("DateBirth", fnol.insured.DateBirth);
fnolObject.Add("Age", fnol.insured.Age);
fnolObject.Add("Email", fnol.insured.Email);
fnolObject.Add("Phone_Number", fnol.insured.Phone_Number);
fnolObject.Add("City", fnol.insured.City);
fnolObject.Add("Postal_Code", fnol.insured.Postal_Code);
fnolObject.Add("Address", fnol.insured.Address);
fnolObject.Add("Passport_Number_IdNumber", fnol.insured.Passport_Number_IdNumber);
fnolObject.Add("Type_InsuredID", fnol.insured.Type_InsuredID);
fnolObject.Add("Claimant_Account_HolderID", claimantBankAccount.Account_HolderID);
fnolObject.Add("Claimant_Account_Number", claimantBankAccount.Account_Number);
fnolObject.Add("Claimant_BankID", claimantBankAccount.BankID);
}
fnolObject.Add("Relation_claimant_policy_holder", fnol.Relation_claimant_policy_holder);
fnolObject.Add("Destination", fnol.Destination);
fnolObject.Add("Depart_Date_Time", fnol.Depart_Date_Time);
fnolObject.Add("Arrival_Date_Time", fnol.Arrival_Date_Time);
fnolObject.Add("Transport_means", fnol.Transport_means);
fnolObject.Add("Total_cost", fnol.Total_cost);
fnolObject.Add("Web_Mobile", fnol.Web_Mobile);
fnolObject.Add("CreatedBy", fnol.CreatedBy);
if (fnol.Policy_holder_bank_account_info != null)
{
fnolObject.Add("PolicyHolder_Account_HolderID", fnol.Policy_holder_bank_account_info.Account_HolderID);
fnolObject.Add("PolicyHolder_Account_Number", fnol.Policy_holder_bank_account_info.Account_Number);
fnolObject.Add("BankID", fnol.Policy_holder_bank_account_info.BankID);
}
var healthInsurance = _fis.GetHealthAdditionalInfoByLossId(fnol.ID);
if (healthInsurance == null)
{
fnolObject.Add("HealthInsurance_Y_N", "N");
}
else
{
fnolObject.Add("HealthInsurance_Y_N", "Y");
if (fnol.additional_info != null)
{
fnolObject.Add("Datetime_accident", fnol.additional_info.Datetime_accident);
fnolObject.Add("Accident_place", fnol.additional_info.Accident_place);
if (fnol.additional_info.health_insurance_info != null)
{
fnolObject.Add("Datetime_doctor_visit", fnol.additional_info.health_insurance_info.Datetime_doctor_visit);
fnolObject.Add("Doctor_info", fnol.additional_info.health_insurance_info.Doctor_info);
fnolObject.Add("Medical_case_description ", fnol.additional_info.health_insurance_info.Medical_case_description);
fnolObject.Add("Previous_medical_history", fnol.additional_info.health_insurance_info.Previous_medical_history);
fnolObject.Add("Responsible_institution", fnol.additional_info.health_insurance_info.Responsible_institution);
}
}
}
var luggageInsurance = _fis.GetLuggageAdditionalInfoByLossId(fnol.ID);
if (luggageInsurance == null)
{
fnolObject.Add("LuggageInsurance_Y_N", "N");
}
else
{
fnolObject.Add("LuggageInsurance_Y_N", "Y");
if (fnol.additional_info != null)
{
fnolObject.Add("Datetime_accident", fnol.additional_info.Datetime_accident);
fnolObject.Add("Accident_place", fnol.additional_info.Accident_place);
if (fnol.additional_info.luggage_insurance_info != null)
{
fnolObject.Add("Place_description", fnol.additional_info.luggage_insurance_info.Place_description);
fnolObject.Add("Detail_description", fnol.additional_info.luggage_insurance_info.Detail_description);
fnolObject.Add("Report_place", fnol.additional_info.luggage_insurance_info.Report_place);
fnolObject.Add("Floaters", fnol.additional_info.luggage_insurance_info.Floaters);
fnolObject.Add("Floaters_value", fnol.additional_info.luggage_insurance_info.Floaters_value);
fnolObject.Add("Luggage_checking_Time", fnol.additional_info.luggage_insurance_info.Luggage_checking_Time);
}
}
}
JArray invoices = new JArray();
var allInvoices = _fis.GetInvoiceDocumentName(fnol.ID);
foreach (var invoice in allInvoices)
{
var invoiceObject = new JObject();
invoiceObject.Add("invoicePath", ConfigurationManager.AppSettings["webpage_url"] + "/DocumentsFirstNoticeOfLoss/Invoices/" + invoice);
invoices.Add(invoiceObject);
}
fnolObject.Add("invoices", invoices);
JArray documents = new JArray();
var allDoc = _fis.GetHealthLuggageDocumentName(fnol.ID);
foreach (var doc in allDoc)
{
var document = new JObject();
document.Add("documentPath", healthInsurance != null ? ConfigurationManager.AppSettings["webpage_url"] + "/DocumentsFirstNoticeOfLoss/HealthInsurance/" + doc : ConfigurationManager.AppSettings["webpage_url"] + "/DocumentsFirstNoticeOfLoss/LuggageInsurance/" + doc);
documents.Add(document);
}
fnolObject.Add("documents", documents);
userFNOL.Add(fnolObject);
}
}
data.Add("loss", userFNOL);
return(data);
}
public async Task <ActionResult> ProfileEdit(RegisterViewModel model, HttpPostedFileBase picture_selector, String cropImgParam)
{
String userID = User.Identity.GetUserId();
String Img = cropImgParam;
ViewBag.GalleryPics = "";
ViewBag.PrivateGalleryPics = "";
if (userID != null && userID.Length > 0)
{
//{{Upload Picture
String FileName = "";
string PictureDirectory = Server.MapPath("~/Content/UserPicture");
if (!Directory.Exists(PictureDirectory))
{
Directory.CreateDirectory(PictureDirectory);
}
if (picture_selector != null)
{
FileName = userID + "." + picture_selector.FileName.Substring(picture_selector.FileName.Length - 3, 3);
var path = System.IO.Path.Combine(PictureDirectory, FileName);
var data = new byte[picture_selector.ContentLength];
picture_selector.InputStream.Read(data, 0, picture_selector.ContentLength);
using (var sw = new FileStream(path, FileMode.Create))
{
sw.Write(data, 0, data.Length);
}
}
else if (cropImgParam.Length > 0)
{
FileName = userID + ".png";
var path = System.IO.Path.Combine(PictureDirectory, FileName);
ProcessImage(cropImgParam, path);
}
//}}Upload Picture
ApplicationUserManager userManager = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>();
userManager.RemoveFromRoles(userID, new string[] { "member", "client" });
userManager.AddToRole(userID, (model.AccountType == 0 ? "member" : "client"));
//validate age with 18+
if (DateTime.Today.AddYears(-18) < model.Birthday)
{
ModelState.AddModelError("Birthday", "Members or Clients need to be 18 or above to register.");
}
ModelState.Remove("Password");
if (this.ModelState.IsValid)
{
aspnetuser aspuser = this.db.aspnetusers.SingleOrDefault(r => r.Id == userID);
aspuser.Email = model.Email;
aspuser.PhoneNumber = model.PhoneNumber;
if (model.Password != null && model.Password.Length > 0)
{
aspuser.PasswordHash = userManager.PasswordHasher.HashPassword(model.Password);
}
userinfo ui = this.db.userinfoes.SingleOrDefault(r => r.Id == userID);
ViewBag.GalleryPics = ui.Gallery_Pics;
ViewBag.PrivateGalleryPics = ui.Private_Gallery_Pics;
ui.UserName = model.UserName;
ui.Account_Type = model.AccountType;
ui.Date_Of_Birth = model.Birthday;
ui.Gender = Convert.ToSByte(model.Gender);
ui.Gender_Pref = model.GenderPref;
ui.Credit_Amount = 0;
if (picture_selector != null || cropImgParam.Length > 0)
{
ui.Profile_Pic = FileName;
model.Picture = FileName;
}
ui.City = model.City;
ui.County = model.County;
ui.Country = model.Country;
ui.Postcode = model.Postcode;
this.db.SaveChanges();
}
}
ViewBag.mode = 0;
return(View("ProfileView", model));
}
public aspnetuser GetUserDataByUsername(string username)
{
aspnetuser a = _db.aspnetusers.Where(x => x.UserName == username).ToArray().FirstOrDefault();
return(a);
}
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl)
{
if (model.Email.IndexOf('@') > -1)
{
//Validate email format
string emailRegex = @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" +
@"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" +
@".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$";
Regex re = new Regex(emailRegex);
if (!re.IsMatch(model.Email))
{
ModelState.AddModelError("Email", "Email is not valid");
}
}
else
{
//validate Username format
string emailRegex = @"^[a-zA-Z0-9]*$";
Regex re = new Regex(emailRegex);
if (!re.IsMatch(model.Email))
{
ModelState.AddModelError("Email", "Username is not valid");
}
}
if (!ModelState.IsValid)
{
return(View("Login", "_LayoutLogin", model));
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
String MailVal = model.Email;
var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout : false);
if (result != SignInStatus.Success)
{
//retry about username.
IQueryable <userinfo> userInfo = db.userinfoes.Where(i => i.UserName == model.Email);
if (userInfo != null && userInfo.Count() > 0)
{
userinfo ui = userInfo.Single();
aspnetuser aspUser = db.aspnetusers.Where(i => i.Id == ui.Id).Single();
MailVal = aspUser.Email;
result = await SignInManager.PasswordSignInAsync(aspUser.Email, model.Password, model.RememberMe, shouldLockout : false);
}
}
if (result == SignInStatus.Success)
{
string uid = UserManager.FindByName(MailVal)?.Id;
userinfo user = db.userinfoes.Where(i => i.Id == uid).Single();
if (user.Online_Status == 0 || user.Online_Status == 1)
{
db.userinfoes.Where(i => i.Id == uid).Single().Online_Status = 1;
db.SaveChanges();
}
else
{//not normal, so must logout.
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
return(RedirectToAction("Index", "Home"));
}
}
switch (result)
{
case SignInStatus.Success:
return(RedirectToLocal(returnUrl));
case SignInStatus.LockedOut:
return(View("Lockout"));
case SignInStatus.RequiresVerification:
return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }));
case SignInStatus.Failure:
default:
ModelState.AddModelError("", "Invalid login attempt.");
return(View("Login", "_LayoutLogin", model));
}
}
public async Task <ActionResult> ProfileView(int?mode)
{
if (mode == null)
{
mode = 0;
}
ViewBag.mode = mode;
String userID = User.Identity.GetUserId();
if (userID == null || userID.Length == 0)
{
return(View());
}
aspnetuserclaim aspUserClaim = db.aspnetuserclaims.Where(i => i.UserId == userID).Single();
switch (mode)
{
case 0: //Profile
{
string query = "SELECT * FROM userinfo WHERE userinfo.Id = '" + userID + "'";
userinfo UserInfo = await db.userinfoes.SqlQuery(query).SingleOrDefaultAsync();
query = "SELECT * FROM aspnetusers WHERE Id = '" + userID + "'";
aspnetuser aspnetUserInfo = await db.aspnetusers.SqlQuery(query).SingleOrDefaultAsync();
Models.RegisterViewModel model = new Models.RegisterViewModel();
model.Email = User.Identity.Name;
//model.Password = "";
//model.ConfirmPassword = "";
model.UserName = UserInfo.UserName;
model.Birthday = (DateTime)(UserInfo.Date_Of_Birth == null ? new DateTime() : UserInfo.Date_Of_Birth);
model.Picture = UserInfo.Profile_Pic;
model.Gender = (int)UserInfo.Gender;
model.GenderPref = (int)UserInfo.Gender_Pref;
model.PhoneNumber = aspnetUserInfo.PhoneNumber;
model.Ethnicity = UserInfo.Ethnicity;
model.Interests = UserInfo.Interests;
model.City = UserInfo.City;
model.County = UserInfo.County;
model.Country = UserInfo.Country;
model.Postcode = UserInfo.Postcode;
model.AccountType = (int)(UserInfo.Account_Type == null ? 0 : UserInfo.Account_Type);
ViewBag.GalleryPics = UserInfo.Gallery_Pics;
ViewBag.PrivateGalleryPics = UserInfo.Private_Gallery_Pics;
return(View("ProfileView", model));
}
case 1: //Gallery
{
String GalleryPics = "";
if (userID != null)
{
string query = "SELECT * FROM userinfo WHERE userinfo.Id = '" + userID + "'";
System.Data.Entity.Infrastructure.DbSqlQuery <userinfo> userInfos = db.userinfoes.SqlQuery(query);
userinfo UserInfo = null;
if (userInfos != null)
{
UserInfo = await userInfos.SingleOrDefaultAsync();
}
if (UserInfo != null && UserInfo.Gallery_Pics != null)
{
GalleryPics = UserInfo.Gallery_Pics;
}
}
return(View("ProfileView", (object)GalleryPics));
}
case 2: //Private Gallery
{
String GalleryPics = "";
if (userID != null)
{
string query = "SELECT * FROM userinfo WHERE userinfo.Id = '" + userID + "'";
System.Data.Entity.Infrastructure.DbSqlQuery <userinfo> userInfos = db.userinfoes.SqlQuery(query);
userinfo UserInfo = null;
if (userInfos != null)
{
UserInfo = await userInfos.SingleOrDefaultAsync();
}
if (UserInfo != null && UserInfo.Gallery_Pics != null)
{
GalleryPics = UserInfo.Private_Gallery_Pics;
}
}
return(View("ProfileView", (object)GalleryPics));
}
}
return(View());
}
