private ConfirmationEmailTemplate GetAdminEmailTemplate(string adminName, string adminEmail, UserDetail userInfo, Pollinator.DataAccess.PolinatorInformation pollinator) { String path = Request.PhysicalApplicationPath + "\\EmailTemplates\\RegisterEmailAdmin.html"; Uri uri = HttpContext.Current.Request.Url; string webAppUrl = uri.GetLeftPart(UriPartial.Authority); //Return both host and port using (StreamReader reader = File.OpenText(path)) { String content = reader.ReadToEnd(); // Load the content from your file... content = content.Replace("{AdminName}", adminName); content = content.Replace("{RegisterName}", userInfo.FirstName); content = content.Replace("{UserType}", "PREMIUM"); content = content.Replace("{ShareMapUrl}", webAppUrl + "/Pollinator/ShareMap.aspx"); content = content.Replace("{OrganizationName}", pollinator.OrganizationName); content = content.Replace("{PhoneNumber}", userInfo.PhoneNumber); content = content.Replace("{LandscapeStreet}", pollinator.LandscapeStreet); content = content.Replace("{LandscapeCity}", pollinator.LandscapeCity); content = content.Replace("{LandscapeState}", pollinator.LandscapeState); content = content.Replace("{LandscapeZipcode}", pollinator.LandscapeZipcode); content = content.Replace("{PollinatorSize}", pollinator.PollinatorSize.ToString()); content = content.Replace("{PollinatorType}", pollinator.PollinatorType.ToString()); content = content.Replace("{LogonLink}", webAppUrl + "/Pollinator/Account/Login"); var membership = System.Web.Security.Membership.GetUser(userInfo.UserId); var emailTemplate = new ConfirmationEmailTemplate(); emailTemplate.EmailTo = adminEmail; emailTemplate.EmailFrom = Utility.EmailConfiguration.WebMasterEmail; emailTemplate.Subject = "Thank you for registering with S.H.A.R.E!"; emailTemplate.EmailBodyTemplate = content; return emailTemplate; } }
public ActionResult About() { ViewBag.Message = "Your application description page."; UserDetail user = new UserDetail(); user = userService.AddUser(user); return View(); }
protected void btnLogin_Click(object sender, EventArgs e) { UserDetail ud = new UserDetail(); try { string hashedPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "SHA1"); DataTable dt = ud.CheckStudent(txtUsername.Text, hashedPassword, ddlFaculty.SelectedItem.Value, ddlSemester.SelectedItem.Value); if (dt.Rows.Count > 0) { Session["Student"] = txtUsername.Text; Session["Faculty"] = ddlFaculty.SelectedItem.Value; Session["Semester"] = ddlSemester.SelectedItem.Value; Response.Redirect("MyProfile.aspx"); } else { ltrMessage.Text = "Invallid User or Password!"; } } catch (Exception ex) { ltrMessage.Text = ex.Message; } }
protected void btnSearchById_Click(object sender, EventArgs e) { try { UserDetail ud = new UserDetail(); DataTable dt = ud.SearchStudentByID(txtStudentID.Text); txtStudentName.Text = dt.Rows[0]["Name"].ToString(); txtRollNumber.Text = dt.Rows[0]["RollNumber"].ToString().Trim(); txtUsername.Text = dt.Rows[0]["Username"].ToString(); ddlFaculty.Text = dt.Rows[0]["Faculty"].ToString(); ddlSemester.Text = dt.Rows[0]["Semester"].ToString(); txtEmail.Text = dt.Rows[0]["Email"].ToString(); lblMessage.ForeColor = System.Drawing.Color.Black; lblMessage.Text = ""; } catch (Exception) { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Invalid Student ID"; txtStudentName.Text = ""; txtRollNumber.Text = ""; txtUsername.Text = ""; ddlSemester.Text = ""; txtEmail.Text = ""; } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { UserDetail ud = new UserDetail(); DataTable dt = ud.SearchStudentByID(txtStudentID.Text); if (dt.Rows.Count < 1) { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Invalid Student ID"; lblMessage.Text = "Invalid Student ID"; } else { ud.UpdateStudent(txtStudentName.Text, txtRollNumber.Text, txtUsername.Text, ddlFaculty.SelectedItem.Value, ddlSemester.SelectedItem.Value, txtEmail.Text, txtStudentID.Text); lblMessage.ForeColor = System.Drawing.Color.Black; lblMessage.Text = "Successfully Updated!"; txtStudentID.Text = ""; txtStudentName.Text = ""; txtRollNumber.Text = ""; txtUsername.Text = ""; txtEmail.Text = ""; txtStudentID.Focus(); } } catch(Exception){ lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Record Cannot be Updated"; } }
public UserDetail FromCookie() { FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName].Value); UserDetail userDetail = new UserDetail(); userDetail = UserDetail.FromString(ticket.UserData); return userDetail; }
protected void btnRegister_Click(object sender, EventArgs e) { // Default UserStore constructor uses the default connection string named: DefaultConnection var userStore = new UserStore<IdentityUser>(); //Set ConnectionString to GarageConnectionString userStore.Context.Database.Connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["GarageConnectionString"].ConnectionString; var manager = new UserManager<IdentityUser>(userStore); //Create new user and try to store in DB. var user = new IdentityUser { UserName = txtUserName.Text }; if (txtPassword.Text == txtConfirmPassword.Text) { try { IdentityResult result = manager.Create(user, txtPassword.Text); if (result.Succeeded) { UserDetail userDetail = new UserDetail { Address = txtAddress.Text, FirstName = txtFirstName.Text, LastName = txtLastName.Text, Guid = user.Id, PostalCode = Convert.ToInt32(txtPostalCode.Text) }; UserDetailModel model = new UserDetailModel(); model.InsertUserDetail(userDetail); //Store user in DB var authenticationManager = HttpContext.Current.GetOwinContext().Authentication; var userIdentity = manager.CreateIdentity(user, DefaultAuthenticationTypes.ApplicationCookie); //If succeedeed, log in the new user and set a cookie and redirect to homepage authenticationManager.SignIn(new AuthenticationProperties(), userIdentity); Response.Redirect("~/Index.aspx"); } else { litStatusMessage.Text = result.Errors.FirstOrDefault(); } } catch (Exception ex) { litStatusMessage.Text = ex.ToString(); } } else { litStatusMessage.Text = "Passwords must match!"; } }
public void Update(UserDetail userDetail) { //Fetch object from db UserDetail u = db.UserDetails.Find(userDetail.Id); u.Address = userDetail.Address; u.FirstName = userDetail.FirstName; u.LastName = userDetail.LastName; u.PostalCode = userDetail.PostalCode; db.SaveChanges(); }
public static string InsertUser(UserDetail e) { dataContext.UserDetails.Add(e); try { dataContext.SaveChanges(); } catch(Exception e1) { Console.WriteLine(e1); } return "success"; }
private void bindingNavigatorEditItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count < 1) return; var srNo = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Id"].Value); _userDetail = uniDb.UserDetails.Single(x => x.Id == srNo); ResetAndBindPageControls(); SetControlNonEditForAdmin(); }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { Token = Member.AdminToken; if (Token.IsEmpty()) { filterContext.Result = new RedirectResult(Url.Action("Index", "Login", new {returnurl = HttpUtility.UrlEncode(Request.Url.ToString())})); return; } LoginUserDetail = Member.GetLoginMember(Token); ViewData["UserName"] = LoginUserDetail.Nick; base.OnActionExecuting(filterContext); }
protected void btnCreateMember_Click(object sender, EventArgs e) { UserDetail ud = new UserDetail(); try { string hashedPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "SHA1"); ud.SaveMember(txtMemberID.Text, txtUsername.Text, hashedPassword); ltrMessage.Text = "Member Successfully Created"; txtMemberID.Text = ""; txtUsername.Text = ""; txtPassword.Text = ""; txtMemberID.Focus(); } catch(Exception){ ltrMessage.Text = "Member Already Exists"; } }
public static bool AddAccountDetails(string userName, string password,bool isCurrent) { using(MagDBEntities dbentities = new MagDBEntities()) { UserDetail detail = new UserDetail(); detail.UserName = userName; detail.Password=password; dbentities.UserDetails.Add(detail); dbentities.SaveChanges(); AccountInformation info = new AccountInformation(); info.IsCurrent=isCurrent; info.Balance=10000; info.UserId=detail.Id; dbentities.AccountInformations.Add(info); dbentities.SaveChanges(); return true; } }
public Task<IEnumerable<string>> Post(string name, string address) { try { if (Request.Content.IsMimeMultipartContent()) { string fullPath = HttpContext.Current.Server.MapPath("~/uploads"); MultipartFormDataStreamProvider streamProvider = new MultipartFormDataStreamProvider(fullPath); var task = Request.Content.ReadAsMultipartAsync(streamProvider).ContinueWith(t => { if (t.IsFaulted || t.IsCanceled) throw new HttpResponseException(HttpStatusCode.InternalServerError); var fileInfo = streamProvider.FileData.Select(i => { var info = new FileInfo(i.LocalFileName); UserDetail ud = new UserDetail(); byte[] a = File.ReadAllBytes(info.FullName); //img.productID = productid; ud.fname = name; ud.address = address; ud.pic = a; ImageRepository.updateImage(ud); return "File uploaded successfully!"; }); return fileInfo; }); return task; } else { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotAcceptable, "Invalid Request!")); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); return null; } }
protected void btnCreateStudent_Click(object sender, EventArgs e) { try { UserDetail ud = new UserDetail(); string hashedPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtRollNumber.Text, "SHA1"); ud.AddStudent(txtStudentID.Text, txtStudentName.Text, txtRollNumber.Text, txtRollNumber.Text, hashedPassword, ddlFaculty.SelectedItem.Value, ddlSemester.SelectedItem.Value, txtEmail.Text, "Student/" + FileUpload1.FileName); FileUpload1.SaveAs(Server.MapPath("~/Student/" + FileUpload1.FileName)); ltrMessage.Text = "Saved Successfully!"; txtStudentID.Text = ""; txtStudentName.Text = ""; txtRollNumber.Text = ""; txtEmail.Text = ""; txtStudentID.Focus(); } catch(Exception){ ltrMessage.Text = "Student Already Exists"; } }
public void SendRegisterEmail(UserDetail userInfo, Pollinator.DataAccess.PolinatorInformation pollinator) { var emails = new List<ConfirmationEmailTemplate>(); var userEmailTemplate = GetUserEmailTemplate(userInfo, pollinator); emails.Add(userEmailTemplate); var Administrators = new List<string>(); Administrators.Add("Truong"); //Dummy data, must be replaced with real Admin name foreach(var admin in Administrators) { string adminEmail = "*****@*****.**";//DUMMY data, must replaced with real data of Admin user var adminEmailTemplate = GetAdminEmailTemplate(admin, adminEmail, userInfo, pollinator); emails.Add(adminEmailTemplate); } Session["Emails"] = emails; }
protected void btnDelete_Click(object sender, EventArgs e) { try { UserDetail ud = new UserDetail(); ud.DeleteStudent(txtStudentID.Text); lblMessage.Text = "Successfully Deleted!"; txtStudentID.Text = ""; txtStudentName.Text = ""; txtRollNumber.Text = ""; txtUsername.Text = ""; txtEmail.Text = ""; txtStudentID.Focus(); } catch (Exception) { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Record Cannot be Deleted"; } }
public async Task <ActionResult> Register(RegisterViewModel userViewModel, params string[] selectedRoles) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = userViewModel.Email, Email = userViewModel.Email, EmailConfirmed = true }; var adminresult = await UserManager.CreateAsync(user, userViewModel.Password); //Add User to the selected Roles if (adminresult.Succeeded) { var result = await UserManager.AddToRolesAsync(user.Id, "Employee"); if (!result.Succeeded) { ModelState.AddModelError("", result.Errors.First()); ViewBag.RoleId = new SelectList(await RoleManager.Roles.ToListAsync(), "Name", "Name"); return(View()); } UserDetail deets = new UserDetail() { UserID = user.Id, FirstName = userViewModel.FirstName, LastName = userViewModel.LastName }; LMSEntities ctx = new LMSEntities(); ctx.UserDetails.Add(deets); ctx.SaveChanges(); } else { ModelState.AddModelError("", adminresult.Errors.First()); ViewBag.RoleId = new SelectList(RoleManager.Roles, "Name", "Name"); return(View()); } return(RedirectToAction("Login")); } ViewBag.RoleId = new SelectList(RoleManager.Roles, "Name", "Name"); return(View()); }
public async Task <IActionResult> Register(AccountVM register) { if (ModelState["Fullname"].ValidationState == Microsoft.AspNetCore.Mvc.ModelBinding.ModelValidationState.Invalid || ModelState["RegisterUsername"].ValidationState == Microsoft.AspNetCore.Mvc.ModelBinding.ModelValidationState.Invalid || ModelState["Email"].ValidationState == Microsoft.AspNetCore.Mvc.ModelBinding.ModelValidationState.Invalid || ModelState["RegisterPassword"].ValidationState == Microsoft.AspNetCore.Mvc.ModelBinding.ModelValidationState.Invalid || ModelState["ConfirmPassword"].ValidationState == Microsoft.AspNetCore.Mvc.ModelBinding.ModelValidationState.Invalid) { register.Bio = _db.Bios.FirstOrDefault(); return(PartialView("_RegisterPartialView", register)); } AppUser user = new AppUser { FullName = register.Fullname, UserName = register.RegisterUsername, Email = register.Email }; IdentityResult identityResult = await _userManager.CreateAsync(user, register.RegisterPassword); if (!identityResult.Succeeded) { foreach (var error in identityResult.Errors) { ModelState.AddModelError("", error.Description); } register.Bio = _db.Bios.FirstOrDefault(); return(PartialView("_RegisterPartialView", register)); } UserDetail userDetail = new UserDetail { AppUserId = user.Id }; _db.UserDetails.Add(userDetail); await _userManager.AddToRoleAsync(user, Helper.Roles.Member.ToString()); await _signInManager.SignInAsync(user, false); await _db.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); }
public UserDetail GetLandloardEmail(string landlordEmail) { objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; UserDetail objUserDtl = null; objDbCommand.AddInParameter("LandloardId", landlordEmail); try { objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "ams.uspGetLandloardEmail", CommandType.StoredProcedure); if (objDbDataReader.HasRows) { //DocumentBiz.GetApplicantDocuments(applicantId); while (objDbDataReader.Read()) { objUserDtl = new UserDetail(); BuildModel(objDbDataReader, objUserDtl); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return(objUserDtl); }
public UserDetail GetUserBasicInfo(User objUser) { objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; UserDetail objUserDtl = null; objDbCommand.AddInParameter("EmailAsUserID", objUser.Email); objDbCommand.AddInParameter("MobileNoAsUserID", objUser.MobileNo); objDbCommand.AddInParameter("Password", objUser.Password); try { objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "ams.uspGetAuthoriseUserBasicInfo", CommandType.StoredProcedure); if (objDbDataReader.HasRows) { //DocumentBiz.GetApplicantDocuments(applicantId); while (objDbDataReader.Read()) { objUserDtl = new UserDetail(); BuildModel(objDbDataReader, objUserDtl); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return(objUserDtl); }
public async Task <IEnumerable <UserDetail> > GetUserDetail() { try { UserDetail userDetail = new UserDetail(); List <UserDetail> userDetails = new List <UserDetail>(); List <User> users = await _context.Users.Find(_ => true).ToListAsync(); List <Question> questions = await _context.Questions.Find(_ => true).ToListAsync(); foreach (User u in users) { userDetail.internalId = u.internalId; userDetail.surveyId = u.surveyId; userDetail.userName = u.userName; userDetail.userPhone = u.userPhone; userDetail.userEmail = u.userEmail; userDetail.optIn = u.optIn; List <Response> responses = await _context.Responses.Find(r => r.userId == u.internalId).ToListAsync(); List <UserDetailResponse> udResponses = new List <UserDetailResponse>(); foreach (Question q in questions) { Response response = await _context.Responses.Find(s => s.questionId == q.questionId).SingleOrDefaultAsync(); UserDetailResponse udResponse = new UserDetailResponse(); udResponse.questionDesc = q.questionDesc; udResponse.questionType = q.questionType; udResponse.choice = response.choice; udResponses.Add(udResponse); } userDetail.responses = udResponses; userDetails.Add(userDetail); } return(userDetails); } catch (Exception ex) { throw ex; } }
//OLD method can be deleted when cleaning up public static string GetUserDetail() { string paraphrase = "123medicarepass"; string email = System.Web.HttpContext.Current.User.Identity.Name; var userService = ApplicationContext.Current.Services.MemberService; //Get the member from their email address var amember = userService.GetByEmail(email); UserDetail ud = new UserDetail(); ud.UserFirstName = amember.GetValue("firstName").ToString(); ud.UserLastName = amember.GetValue("lastName").ToString(); ud.UserEmail = email; string st = amember.GetValue("state").ToString(); if (st == "IND") { st = "IN"; } if (st == "ORE") { st = "OR"; } ud.UserState = st; ud.Organization = amember.GetValue("organization").ToString(); ud.UserRole = GetRoleOfUser(email); ud.UserId = amember.Id.ToString(); string jsonString = JsonConvert.SerializeObject(ud); string encryptString = UmbracoShipTac.Code.Encryptor.StringCipher.Encrypt(jsonString, paraphrase); // string DecrptString = UmbracoShipTac.Code.Encryptor.StringCipher.Decrypt(encryptString, paraphrase); return(encryptString); }
public UserDetail InsertUserDetail(int vUserDetailID, string vUserId, string vFirstName, string vLastName, int vAddressId, int vContactInfoId, DateTime vAddedDate, string vAddedBy, DateTime vUpdatedDate, string vUpdatedBy, bool vActive, string vPassword) { UserDetail lUserDetail = new UserDetail(); using (FRShoppingEntities frctx = new FRShoppingEntities()) { if (vUserDetailID > 0) { lUserDetail = frctx.UserDetails.FirstOrDefault(u => u.UserDetailId == vUserDetailID); lUserDetail.UserId = vUserId; lUserDetail.FirstName = vFirstName; lUserDetail.LastName = vLastName; lUserDetail.AddressId = vAddressId; lUserDetail.ContactInfoId = vContactInfoId; lUserDetail.UpdatedDate = vUpdatedDate; lUserDetail.UpdatedBy = vUpdatedBy; lUserDetail.Active = vActive; //lUserDetail.Password = vPassword; return(frctx.SaveChanges() > 0 ? lUserDetail : null); } else { lUserDetail.UserId = vUserId; lUserDetail.FirstName = vFirstName; lUserDetail.LastName = vLastName; lUserDetail.AddressId = vAddressId; lUserDetail.ContactInfoId = vContactInfoId; lUserDetail.Password = vPassword; lUserDetail.AddedDate = vAddedDate; lUserDetail.AddedBy = vAddedBy; lUserDetail.UpdatedDate = vUpdatedDate; lUserDetail.UpdatedBy = vUpdatedBy; lUserDetail.Active = vActive; return(AddUserDetail(lUserDetail)); } } }
public VendorsBeautyService AddBeautyService(VendorsBeautyService vendorBeautyService, Vendormaster vendorMaster) { string updateddate = DateTime.UtcNow.ToShortDateString(); vendorBeautyService.UpdatedDate = Convert.ToDateTime(updateddate); vendorBeautyService.Status = "Active"; vendorMaster.UpdatedDate = userLogin.RegDate = userLogin.UpdatedDate = Convert.ToDateTime(updateddate); vendorMaster.Status = userLogin.Status = "Active"; vendorMaster.ServicType = "BeautyServices"; vendorMaster = vendorMasterRepository.AddVendorMaster(vendorMaster); vendorBeautyService.VendorMasterId = vendorMaster.Id; vendorBeautyService = vendorBeautyServiceRespository.AddBeautyService(vendorBeautyService); userLogin.UserName = vendorMaster.EmailId; userLogin.Password = randomPassword.GenerateString(); userLogin.UserType = "Vendor"; userLogin.UpdatedBy = 2; userLogin = userLoginRepository.AddVendorUserLogin(userLogin); userDetail.UserLoginId = userLogin.UserLoginId; userDetail.FirstName = vendorMaster.BusinessName; userDetail.UserPhone = vendorMaster.ContactNumber; userDetail.Url = vendorMaster.Url; userDetail.Address = vendorMaster.Address; userDetail.City = vendorMaster.City; userDetail.State = vendorMaster.State; userDetail.ZipCode = vendorMaster.ZipCode; userDetail.Status = "Active"; userDetail.UpdatedBy = ValidUserUtility.ValidUser(); userDetail.UpdatedDate = Convert.ToDateTime(updateddate); userDetail.AlternativeEmailID = vendorMaster.EmailId; userDetail.Landmark = vendorMaster.Landmark; userDetail = userDetailsRepository.AddUserDetails(userDetail); if (vendorMaster.Id != 0 && vendorBeautyService.Id != 0 && userLogin.UserLoginId != 0 && userDetail.UserDetailId != 0) { return(vendorBeautyService); } else { vendorBeautyService.Id = 0; return(vendorBeautyService); } }
public ActionResult AddUser(FormCollection fc, HttpPostedFileBase photo, HttpPostedFileBase document) { if (ModelState.IsValid) { UserDetail user = new UserDetail(); user.FirstName = fc["FirstName"]; user.LastName = fc["LastName"]; user.Address = fc["Address"]; //user.FileAddress = fc["FileAddress"]; user.CityName = fc["CityName"]; user.Latitude = decimal.Parse(fc["Latitude"]); user.Longitude = decimal.Parse(fc["Longitude"]); user.Description = fc["Description"]; //user.PhotoPath = fc["PhotoPath"]; user.RegisterDate = DateTime.Now.ToLocalTime(); user.mapAddress = fc["map"]; if (photo != null && photo.ContentLength > 0) { string fileName = Path.GetFileName(photo.FileName); string imgpath = Path.Combine(Server.MapPath("~/Files/Images/"), DateTime.Now.ToLongDateString() + fileName); photo.SaveAs(imgpath); user.PhotoPath = DateTime.Now.ToLongDateString() + fileName; } if (document != null && document.ContentLength > 0) { string fileName = Path.GetFileName(document.FileName); string imgpath = Path.Combine(Server.MapPath("~/Files/Images/"), DateTime.Now.ToLongDateString() + fileName); document.SaveAs(imgpath); user.FileAddress = DateTime.Now.ToLongDateString() + fileName; } db.UserDetails.Add(user); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }
private string InitiateICR(PurchaseOrderItem item, int RecordId, UserDetail currentUser, CompanyDetail company, int WorkFlowId) { ItemChangedDetailsAC itemChange = new ItemChangedDetailsAC { IsPOItemIcr = true, IsPriceChangeRequest = true, ItemId = item.ItemId, ModifyingCostPrice = item.ReceivingCostPrice, ModifyingSellPrice = item.ItemProfile.SellPrice, ModifyingSellPriceA = item.ItemProfile.SellPriceA, ModifyingSellPriceB = item.ItemProfile.SellPriceB, ModifyingSellPriceC = item.ItemProfile.SellPriceC, ModifyingSellPriceD = item.ItemProfile.SellPriceD, POItemId = item.Id, RequestedDate = DateTime.UtcNow, ParentRecordId = RecordId, IsInDirect = true }; return(_iICRRepository.SaveICR(itemChange, currentUser, company, WorkFlowId)); }
public UserDetail RejectUserPendingRequest(UserDetail userDetail) { var param = new SqlParameter[] { new SqlParameter("@ID", userDetail.ID), new SqlParameter("@GlobalID", userDetail.GlobalID), new SqlParameter("@UserName", userDetail.UserName), new SqlParameter("@Email", userDetail.EmailID), new SqlParameter("@ContactNo", userDetail.ContactNo), new SqlParameter("@CreditAmountID", userDetail.CreditAmountID), new SqlParameter("@DepartmentID", userDetail.DepartmentID), new SqlParameter("@ApprovalStatus", false), new SqlParameter("@Comments", userDetail.Comments), new SqlParameter("@RequesterEmail", userDetail.RequesterEmail), new SqlParameter("@IsRequesterNotified", false), new SqlParameter("@IsAdminNotified", false), new SqlParameter("@RecordStatusId", 1) }; return(SqlHelper.ExecuteProcedureReturnSingleObject <UserDetail>(ConnectionString, SPConstants.uspSaveUserAccessRequest, param)); }
public IActionResult LoginUser(UserDetail ud) { UserMethod um = new UserMethod(); List <UserDetail> users = new List <UserDetail>(); string error = ""; users = um.GetUsers(out error); UserDetail currentUser = users.Find(user => user.Username == ud.Username); if (currentUser != null) { string usr = JsonConvert.SerializeObject(currentUser); HttpContext.Session.SetString("currentuser", usr); return(View("UserSettings", currentUser)); } else { ViewBag.error = "Inloggningsuppgifterna stämmer inte."; return(View()); } }
public ActionResult BasicInformation() { if (Session["UserId"] != null) { int UserId = Convert.ToInt32(Session["UserId"].ToString()); UserDetail Userdata = UserInfoService.Get(UserId); ProfileBasicInformation BasicProfile = new ProfileBasicInformation() { FirstName = Userdata.FirstName, LastName = Userdata.LastName, DOB = Userdata.DOB, Salutation = SalutationService.GetSaluations(), //States = StatecitydistrictService.GetAllStates(), SalutationId = Userdata.SalutationId, GenderId = Convert.ToInt32(Userdata.GenderId), ProfilePicture = Userdata.ProfilePicture }; return(View(BasicProfile)); } return(RedirectToAction("Login", "Account", new { area = "" })); }
private async void btnsave_Clicked(object sender, EventArgs e) { Datamanager dataManager = new Datamanager(); users = new UserDetail() { Username = name.Text, UserPhone = phone.Text, UserEmail = email.Text, Savetime = DateTime.Now.ToShortTimeString() }; int result = await dataManager.SaveUserDetailAsync(users); if (result == 1) { name.Text = string.Empty; phone.Text = string.Empty; email.Text = string.Empty; await DisplayAlert("", "Record Saved", "OK"); } }
public LoginValidate SignUp([FromBody] UserDetail usr) { Login db = new Login(); LoginValidate lv = new LoginValidate(); UserDetail u = db.SignIn(usr.userName); if (u != null) { lv.loginStatus = -1; //User already Exist lv.accType = ""; lv.token = ""; } else { db.SignUp(usr); lv.loginStatus = 1; //Signup Successful lv.accType = ""; lv.token = ""; } return(lv); }
public async Task <ActionResult <UserDetail> > GetCurrentUser() { var user = await _userManager.FindByNameAsync(User.Identity.Name); if (user == null) { return(NotFound()); } var result = new UserDetail { Id = user.Id, isAdministrator = user.IsAdministrator, UserName = user.UserName, PasswordExpired = user.PasswordExpired, DaysTillPasswordExpiry = PasswordExpiryHelper.ContDaysTillPasswordExpiry(user, _userOptionsExtended), Permissions = user.Roles.SelectMany(x => x.Permissions).Select(x => x.Name).Distinct().ToArray() }; return(Ok(result)); }
public async Task <IActionResult> PutAnItem(int id, [FromBody] UserDetail item) { try { if (id != item.Id) { return(BadRequest()); } _context.Entry(item).State = EntityState.Modified; _context.Entry(item.UserInfo).State = EntityState.Unchanged; await _context.SaveChangesAsync(); return(AcceptedAtAction(nameof(GetById), new { id = item.Id }, item)); } catch (Exception ex) { Log.ForContext <UserDetailsController>().Error(ex.Message); return(BadRequest(ex.Message)); } }
public void GetMethodCallRetrunsExeExpectedResult() { // Arrange var mockUserDetail = new UserDetail { Id = 1, FirstName = "Thiru", LastName = "Vasan" }; var movieCruiserDbContext = new Mock <AuthServiceDbContext>(); var dbSetMock = new Mock <DbSet <UserDetail> >(); movieCruiserDbContext.Setup(x => x.Set <UserDetail>()).Returns(dbSetMock.Object); dbSetMock.Setup(x => x.Find(It.IsAny <int>())).Returns(mockUserDetail); repository = new Repository(movieCruiserDbContext.Object); // Act var result = repository.Get <UserDetail>(1); // Assert movieCruiserDbContext.Verify(x => x.Set <UserDetail>()); dbSetMock.Verify(x => x.Find(It.IsAny <int>())); Assert.Equal(1, result.Id); }
private AudienceResponse TokenMapper(User audience, Guid token, string message = "") { var webUrl = ConfigurationManager.AppSettings["WebUrl"] + "/"; var userCardDetail = _userRepository.GetUserCardDetailsByUserId(audience.Id); UserDetail userDetailReturn = new UserDetail(); userDetailReturn.UserId = audience.Id; userDetailReturn.Email = audience.Email; userDetailReturn.IsVerified = audience.IsVerified; userDetailReturn.AccessToken = token; userDetailReturn.Message = message; userDetailReturn.IsCardRegistered = userCardDetail != null ? true : false; userDetailReturn.UserCode = webUrl + "UserCodes/" + audience.UserCode + ".jpeg"; var validateResponse = new AudienceResponse { data = userDetailReturn, }; return(validateResponse); }
protected void btnChangePicture_Click(object sender, EventArgs e) { try { UserDetail ud = new UserDetail(); ud.UpdatePicture("Student/" + FileUpload1.FileName, txtStudentID.Text); FileUpload1.SaveAs(Server.MapPath("~/Student/" + FileUpload1.FileName)); lblMessage.ForeColor = System.Drawing.Color.Black; lblMessage.Text = "Successfully Updated!"; txtStudentID.Text = ""; txtStudentName.Text = ""; txtRollNumber.Text = ""; txtUsername.Text = ""; txtEmail.Text = ""; txtStudentID.Focus(); } catch (Exception) { lblMessage.ForeColor = System.Drawing.Color.Red; lblMessage.Text = "Cannot Update Picture"; } }
/// <summary> /// sipriş yetki düzenleme sayfası /// </summary> public PartialViewResult Parametre(int ID) { if (CheckPerm(Perms.Kullanıcılar, PermTypes.Reading) == false || ID == 1) { return(null); } ViewBag.ID = ID; var tbl = db.UserDetails.Where(m => m.UserID == ID).FirstOrDefault(); if (tbl == null) { tbl = new UserDetail() { GostCHKKodAlani = "0;ZZZ", GostKod3OrtBakiye = "0, 999999999999, 0, 0", GostRiskDeger = "0, 999999999999, 0, 0" } } ; return(PartialView("Parametre", tbl)); }
public IActionResult ProfileData() { UserDetail model = new UserDetail(); var user = HttpContext.Session.Get <UserViewModel>(Constants.SessionKeyUserInfo); user = user ?? new UserViewModel(); try { ViewBag.JobIndustryArea = jobpastHandler.GetJobIndustryAreaDetails(); ViewBag.EmploymentStatus = jobpastHandler.GetJobJobEmploymentStatusDetails(); ViewBag.Country = jobpastHandler.GetCountryDetails(); model = userProfileHandler.GetJobseekerDetail(user.UserId); } catch (DataNotFound ex) { Logger.Logger.WriteLog(Logger.Logtype.Error, ex.Message, user.UserId, typeof(JobSeekerManagementController), ex); ModelState.AddModelError("ErrorMessage", string.Format("{0}", ex.Message)); } return(new JsonResult(model, ContractSerializer.JsonInPascalCase())); }
public async Task ResetUser(UserDetail target) { int id = 0; if (int.TryParse(target.GroupId, out id)) { var channel = await _db.Channels.Include(i => i.Users).FirstOrDefaultAsync(i => i.Id == id); if (channel.OwnerId != target.UserId) { var channelUserDb = await _db.ChannelUsers.FirstOrDefaultAsync(i => i.ChannelId == id && i.UserId.Equals(target.UserId)); channelUserDb.State = (int)UserStates.Joined; target.State = channelUserDb.State; await _db.SaveChangesAsync(); await UpdateState(target); } } }
public int editUserProfile(UserDetailsView model, string email) { UserDetail userDetail = db.UserDetails.FirstOrDefault(x => x.email == email); userDetail.adress = model.Address; userDetail.email = model.Email; userDetail.name = model.Name; userDetail.phone = model.Phone; try { // db.UserDetails.Add(userDetail); db.SaveChanges(); return(1); } catch { return(0); } }
public string AddUserDetails(UserLogin userLogin, UserDetail userDetails) { string response; //userLogin.Status = "Active"; DateTime updateddate = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);//DateTime.UtcNow.ToShortDateString(); userLogin.RegDate = updateddate; userLogin.UpdatedDate = userDetails.UpdatedDate = updateddate; try { UserLogin l1 = userLoginRepository.AddLoginCredentials(userLogin); userDetails.UserLoginId = l1.UserLoginId; UserDetail l2 = userDetailsRepository.AddUserDetails(userDetails); response = "sucess"; } catch (Exception ex) { response = "failure"; } return(response); }
public int Insert2(UserDetailsInsertModel model, string Email) { UserDetail userDetail = new UserDetail(); userDetail.adress = model.Address; userDetail.email = Email; userDetail.name = model.Name; userDetail.phone = model.Phone; userDetail.point = 50; try { db.UserDetails.Add(userDetail); db.SaveChanges(); return(1); } catch { return(0); } }
public IHttpActionResult Register(RegisterBindingModel model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var user = new UserDetail() { UserName = model.Email, Email = model.Email }; var result = userManagementService.CreateUser(user, model.Password); if (result.HasError) { return(GetErrorResult(result)); } return(Ok()); }
public IActionResult DelEquip(int EquipID) { var result = db.Equips.Where(x => x.EquipID == EquipID).FirstOrDefault(); db.Remove(result); db.SaveChanges(); var UserDetail = new UserDetail(); var equipDetail = from a in db.Equips join b in db.Types on a.TypeID equals b.TypeID select new EquipInfo { EquipName = a.EquipName, EquipDes = a.EquipDes, EquipStatus = a.EquipStatus, TypeName = b.TypeName, EquipID = a.EquipID }; UserDetail.EquipInfos = equipDetail.ToList(); return(View("ShowEquip", UserDetail)); }
public int createUser(UserDetail user) { int result = 0; if (user.password == user.confirmPW) { bool check = _user.NewAccount(user); if (check == true) { SelectList x = new SelectList(_user.getAllDonVi(), "Value", "Name", user.don_vi_ref); ViewBag.lstDonVi = x; } } else { SelectList x = new SelectList(_user.getAllDonVi(), "Value", "Name", user.don_vi_ref); ViewBag.lstDonVi = x; result = 1; } return(result); }
public HttpResponseMessage PostUserSearch(Inner data) { AllString ob = new AllString(); try { UserDetail uDetail = new UserDetail(); UserData ud = DapperHelper.Search <UserData>(SamgoGameHelper.connectionString, "exec [samgo_get_user_info] N'" + data.Role + "', N'" + data.Legion + "'").FirstOrDefault(); uDetail = DapperHelper.Search <UserDetail>(SamgoGameHelper.connectionString, "exec [samgo_get_user_tech_info] N'" + data.Role + "', N'" + data.Legion + "'").FirstOrDefault(); SamgoGameHelper.ConvertDataToModels(ref ob, ud, uDetail); } catch (Exception) { } if (ob.Role == null) { ob.Role = data.Role; ob.Legion = data.Legion; } return(Request.CreateResponse(HttpStatusCode.OK, ob)); }
//This function will send emails in background... public void SendRegisterEmail(UserDetail userInfo, Pollinator.DataAccess.PolinatorInformation pollinator) { phEmailTasks.Controls.Add(new LiteralControl("<iframe src='" + ResolveUrl("../AsyncSendEmail") + "' id='AsyncSendEmails' scrolling='no'></iframe>")); var emails = new List<ConfirmationEmailTemplate>(); var userEmailTemplate = GetUserEmailTemplate(userInfo, pollinator); emails.Add(userEmailTemplate); //Add emailing for new user //var Administrators = new List<string>(); //Administrators.Add("Truong"); //Dummy data, must be replaced with real Admin name foreach (var adminEmail in GetListAdmin()) { var adminName = adminEmail.Substring(0, adminEmail.IndexOf("@")); var adminEmailTemplate = GetAdminEmailTemplate(adminName, adminEmail, userInfo, pollinator); emails.Add(adminEmailTemplate); //Add emailing for Administrators } //Put them all in session object which will be retrieved in Async process running in background Session["Emails"] = emails; }
protected void btnUpdate_Click(object sender, EventArgs e) { try { MembershipUser usr = Membership.GetUser(UserID); var userDetail = GetUser(); if (userDetail==null) userDetail = new UserDetail(); var polinatorInformation = GetPolinatorInfo(); if (polinatorInformation == null) polinatorInformation = new PolinatorInformation(); //status polinatorInformation.IsApproved = false;//reset IsApproved = 0 polinatorInformation.IsNew = false; polinatorInformation.LastUpdated = DateTime.Now; //get new values from form and set to object to update GetValueFromControlPrenium(usr, userDetail, polinatorInformation); if (usr != null) Membership.UpdateUser(usr); mydb.SaveChanges(); //StatusMessage.Text = "<strong>Update successful!</strong>"; //GoToAlertMessage(panelSuccessMessage); ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "document.getElementById('confirm_pop').click();", true); //Response.Redirect("~/ShareMap.aspx"); } catch (Exception ex) { Response.Write(ex.ToString()); Pollinator.Common.Logger.Error("Error occured at " + typeof(Members_UserUpdate).Name + ".btnUpdate_Click(). Exception:" + ex.Message); GoToAlertMessage(panelErrorMessage); } }
void btnRegister_Click(object sender, EventArgs e) { lblThankYouMessage.Text = "Thank you for registering pollinator information with Pollinator Partnership. An email has been sent to contact emails associated with your account. Please be patient; the delivery of email may be delayed. Remember to confirm that the email above is correct and to check your junk or spam folder or filter if you do not receive this email."; UserDetail userInfo = new UserDetail(); var pollinator = new Pollinator.DataAccess.PolinatorInformation(); //----------------NOTE: You have to supply the real data to replace this dummy data------------------ userInfo.UserId = new Guid(); userInfo.FirstName = "Truong"; userInfo.PhoneNumber = "0904949821"; pollinator.OrganizationName = "Natural Resources Conservation Service"; pollinator.LandscapeStreet = "Duy Tan"; pollinator.LandscapeCity = "Hanoi"; pollinator.LandscapeState = "CA"; pollinator.LandscapeZipcode = "01"; pollinator.PollinatorSize = 1; pollinator.PollinatorType = 1; SendRegisterEmail(userInfo, pollinator); }
public static string updateImage(UserDetail ud) { try { UserDetail usr = dataContext.UserDetails.First(i => i.fname == ud.fname && i.address == ud.address); usr.pic = ud.pic; dataContext.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } return "success"; }
protected void btnLogin_Click(object sender, EventArgs e) { UserDetail ud = new UserDetail(); try { string hashedPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "SHA1"); DataTable dt = ud.CheckMember(txtUsername.Text, hashedPassword); if (dt.Rows.Count > 0) { Session["Member"] = txtUsername.Text; Response.Redirect("Home.aspx"); } else { ltrMessage.Text = "Invallid User or Password!"; } } catch (Exception ex) { ltrMessage.Text = ex.Message; } }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { Token = Member.AdminToken; if (!Token.IsEmpty()) { LoginUserDetail = Member.GetLoginMember(Token); //用户存在并且是管理人员 if (LoginUserDetail != null && (LoginUserDetail.IsStaff || LoginUserDetail.IsLegal || LoginUserDetail.IsShopkeeper || LoginUserDetail.IsManager)) { ViewData["UserName"] = LoginUserDetail.Nick; base.OnActionExecuting(filterContext); return; } } filterContext.Result = new RedirectResult(Url.Action("Index", "Login", new {returnurl = HttpUtility.UrlEncode(Request.Url.ToString())})); }
public void Connect(string userName, string eventName) { var id = Context.ConnectionId; if (ConnectedUsers.Count(x => x.ConnectionId == id) > 0) return; UserDetail user = new UserDetail { ConnectionId = id, UserName = userName, Event = eventName }; if (ConnectedUsers.FirstOrDefault(u => u.UserName == userName) == null) { ConnectedUsers.Add(user); } else { ConnectedUsers.FirstOrDefault(u => u.UserName == userName).ConnectionId = id; ConnectedUsers.FirstOrDefault(u => u.UserName == userName).Event = eventName; } this.Groups.Add(id, eventName); // send to caller Clients.Caller.onConnected(id, userName, GetSameGroupUsers(userName), SameGroupMessage(userName)); // send to all except caller client //Clients.AllExcept(GetOtherGroupUsers(userName)).onNewUserConnected(id, userName); }
/// <summary> /// Custom display at top of site /// (1)Set logonName display FirstName /// (2)Set Premium Since MMM, yyyy /// </summary> private void SetMessageAfterLogin() { try { //if (Context.User.Identity.IsAuthenticated) //{ // string test = HttpUtility.HtmlEncode(@"<newuser2>?:!@#%^&*()_+""'.,/\[]|\!@#$%^&*()_+"); // //test = "<newuser2>?:{}|\\!@#$%^&*()_+"; // LoginName loginName1 = (LoginName)LoginView2.FindControl("loginName"); // loginName1.FormatString = test; //} if (Context.User.Identity.IsAuthenticated && Roles.IsUserInRole(Utility.RoleName.Members.ToString())) { string sesloginName = "loginName" + Context.User.Identity.Name; string sesPreSince = "aPreSince" + Context.User.Identity.Name; LoginName loginName = (LoginName)LoginView2.FindControl("loginName"); if (Session[sesloginName] != null) loginName.FormatString = Session[sesloginName].ToString(); HtmlAnchor aPreSince = (HtmlAnchor)LoginView2.FindControl("aPreSince"); if (Session[sesPreSince] != null) aPreSince.InnerText = Session[sesPreSince].ToString(); else { Guid userID = (Guid)System.Web.Security.Membership.GetUser(Context.User.Identity.Name).ProviderUserKey; PollinatorEntities mydb = new PollinatorEntities(); UserDetail userDetail = new UserDetail(); var selectedUserDetail = (from user in mydb.UserDetails where user.UserId == userID select user).FirstOrDefault(); if (selectedUserDetail != null) { //set loginName Session[sesloginName] = selectedUserDetail.FirstName; loginName.FormatString = HttpUtility.HtmlEncode(Session[sesloginName].ToString()); if (selectedUserDetail.MembershipLevel == 0) aPreSince.Visible = false; else if (selectedUserDetail.MembershipLevel > 0) { var pollinatorInfomation = (from poll in mydb.PolinatorInformations where poll.UserId == userID select poll).FirstOrDefault(); DateTime paidDate = pollinatorInfomation.PaidDate == null ? DateTime.MinValue : (DateTime)pollinatorInfomation.PaidDate; if (paidDate > DateTime.MinValue) { aPreSince.Visible = true; Session[sesPreSince] = string.Format("Premium since {0}", String.Format("{0:MMM, yyyy}", paidDate)); aPreSince.InnerText = Session[sesPreSince].ToString(); } } } } } else if (Context.User.Identity.IsAuthenticated) { string sesloginName = "loginName" + Context.User.Identity.Name; string sesPreSince = "aPreSince" + Context.User.Identity.Name; HtmlAnchor aPreSince = (HtmlAnchor)LoginView2.FindControl("aPreSince"); aPreSince.Visible = false; LoginName loginName = (LoginName)LoginView2.FindControl("loginName"); if (Session[sesloginName] != null) loginName.FormatString = Session[sesloginName].ToString(); else { Guid userID = (Guid)System.Web.Security.Membership.GetUser(Context.User.Identity.Name).ProviderUserKey; PollinatorEntities mydb = new PollinatorEntities(); UserDetail userDetail = new UserDetail(); var selectedUserDetail = (from user in mydb.UserDetails where user.UserId == userID select user).FirstOrDefault(); if (selectedUserDetail != null) { //set loginName Session[sesloginName] = selectedUserDetail.FirstName; loginName.FormatString = Session[sesloginName].ToString(); } } } } catch (Exception ex) { //write log Pollinator.Common.Logger.Error("Occured in function: " + typeof(SiteMap).Name + ".SetMessageAfterLogin()", ex); } }
public UserDetailFrm() { InitializeComponent(); _userDetail = new UserDetail(); }
public void TestSaveUser() { var sessionFactory = NhContext.CurrentFactory; using (var session = sessionFactory.OpenSession()) { using (var tran = session.BeginTransaction()) { var user = new User { Password = "", UserName = "******", CreateTime = DateTime.Now }; var userDetail = new UserDetail { LastUpdated = DateTime.Now, Name = new PersionName { FirstName = "小明", LastName = "小明家族" } }; userDetail.User = user; user.Detail = userDetail; session.Save(user); tran.Commit(); } } }
public static async void SaveAsync(string filename, object obj) { /* //this use the Local folder but can be other var applicationData = ApplicationData.Current; var storageFolder = applicationData.LocalFolder; var file = await storageFolder.CreateFileAsync("User.xml", CreationCollisionOption.ReplaceExisting); var dataContractSerializer = new DataContractSerializer(obj.GetType()); var memoryStream = new MemoryStream(); dataContractSerializer.WriteObject(memoryStream, obj); memoryStream.Seek(0, SeekOrigin.Begin); string serialized = new StreamReader(memoryStream).ReadToEnd(); memoryStream.Dispose(); var doc = new XmlDocument(); doc.LoadXml(serialized); await doc.SaveToFileAsync(file); */ MessageDialog dialog; // Declare Variables StorageFolder storageFolder = Windows.Storage.ApplicationData.Current.LocalFolder; StorageFile xmlFile = null; try { xmlFile = await storageFolder.GetFileAsync("filePathList.xml"); } catch (FileNotFoundException ex) { string message = ex.Message; } // If xml file doesn't exist, make it with initial setting if (xmlFile == null) { String xml = "<?xml version=\"1.0\" encoding=\"utf-8\" ?><files></files>"; var doc = new XmlDocument(); doc.LoadXml(xml); // save xml to a file xmlFile = await storageFolder.CreateFileAsync("filePathList.xml" , Windows.Storage.CreationCollisionOption.GenerateUniqueName); await doc.SaveToFileAsync(xmlFile); // Add permission to the files StorageApplicationPermissions.FutureAccessList.Add(xmlFile); } // Make XmlDom and init variable with the file XmlDocument xmlDoc = await XmlDocument.LoadFromFileAsync(xmlFile); XmlElement root = xmlDoc.DocumentElement; // Check duplicated name XmlNodeList fileNodeList = root.GetElementsByTagName("file"); if (!(fileNodeList.Count() == 0)) { foreach (XmlElement fileNode in fileNodeList) { string munoramaName = fileNode.GetAttribute("id"); if (filename.Equals(munoramaName)) { // Create the message dialog and set its content dialog = new Windows.UI.Popups.MessageDialog("이미 같은 이름의 파일이 있습니다. 다른 이름으로 만들어 주세요."); dialog.Commands.Add(new Windows.UI.Popups.UICommand("OK")); dialog.DefaultCommandIndex = 0; dialog.CancelCommandIndex = 1; await dialog.ShowAsync(); return; } } } // Get file element XmlElement file = xmlDoc.CreateElement("file"); file.SetAttribute("id", filename); // Get MyCanvas Element XmlElement newcanvas = xmlDoc.CreateElement("canvas"); Canvas canvas_save = obj as Canvas; var memoryStream = new MemoryStream(); UserDetail Stats = new UserDetail(); Type each_type; while (canvas_save.Children.Count!=0) { each_type = canvas_save.Children.First().GetType(); Stats.Type_of = each_type.ToString(); if (each_type == typeof(Line)) { Line thisline = canvas_save.Children.First() as Line; Stats.Points_X1 = thisline.X1; Stats.Points_Y1 = thisline.Y1; Stats.Points_X2 = thisline.X2; Stats.Points_Y2 = thisline.Y2; Brush brush = thisline.Stroke; Stats.Color_of_A = ((Color)brush.GetValue(SolidColorBrush.ColorProperty)).A; Stats.Color_of_G = ((Color)brush.GetValue(SolidColorBrush.ColorProperty)).G; Stats.Color_of_R = ((Color)brush.GetValue(SolidColorBrush.ColorProperty)).R; Stats.Color_of_B = ((Color)brush.GetValue(SolidColorBrush.ColorProperty)).B; //Stats.Brush_of = thisline.Stroke; //Stats.Stretch_of = thisline.Stretch; } else if (each_type == typeof(TextBox)) { TextBox thistextbox = canvas_save.Children.First() as TextBox; Stats.Points_X1 = Canvas.GetLeft(thistextbox); Stats.Points_Y1 = Canvas.GetTop(thistextbox); Stats.Points_X2 = Canvas.GetLeft(thistextbox) + thistextbox.Width; Stats.Points_Y2 = Canvas.GetTop(thistextbox) + thistextbox.Height; //Stats.Brush_of = thistextbox.Background; Stats.Name = thistextbox.Text; Stats.Id = int.Parse(thistextbox.Text); } //140517새벽 var dataContractSerializer = new DataContractSerializer(typeof(UserDetail)); dataContractSerializer.WriteObject(memoryStream, Stats); canvas_save.Children.RemoveAt(0); } memoryStream.Seek(0, SeekOrigin.Begin); string serialized = new StreamReader(memoryStream).ReadToEnd(); memoryStream.Dispose(); newcanvas.InnerText = serialized; // Add elements to file node file.AppendChild(newcanvas); // Add file node to Root root.AppendChild(file); // Flush xml elements to xml file await xmlDoc.SaveToFileAsync(xmlFile); // Create the message dialog and set its content dialog = new Windows.UI.Popups.MessageDialog("성공적으로 새 파일을 만들었습니다. 목록에서 확인하세요."); dialog.Commands.Add(new Windows.UI.Popups.UICommand("OK")); dialog.DefaultCommandIndex = 0; dialog.CancelCommandIndex = 1; await dialog.ShowAsync(); }
/// <summary> /// Final step, Import Data Into Database /// </summary> /// <param name="listRowImport">list needed import</param> /// <param name="actionForExistedData">3 option: skip, new, overwrite. default is null(new)</param> /// Create by: Hoai Phuong private void ImportDataIntoDatabase(List<ImportExportFields> listRowImport, string actionForExistedData = null) { //set status navigator bar: current active step = 3(import) SetStatusNavigationBar(3); //show please wait... popup //ScriptManager.RegisterStartupScript(this, this.GetType(), "popupWait", "document.getElementById('showProcessbar').click();", true); //lblErrorMess.Text = "Đang import vào sql db..."; divExistedData.Visible = false; memberLevel = MemberLevel; DateTime createdDate = DateTime.Now; ImportExportFields writedata; Membership userDB; UserDetail userDetail; PolinatorInformation polinatorInformation; Guid userId; int numImport = 0; int numSkipExist = 0; List<string> listAddUserName = new List<string>(); int numRecord = listRowImport.Count; for (int i = 0; i < numRecord; i++) { writedata = listRowImport.ElementAt(i); userDetail = new UserDetail(); polinatorInformation = new PolinatorInformation(); if (writedata.IsExistedData && actionForExistedData == "skip") { numSkipExist++; continue; } numImport++; if (!writedata.IsExistedData || actionForExistedData == "new") { if (!string.IsNullOrEmpty(writedata.Email)) { //generate new user //auto gen UserName, Password string userName = Utility.CreateRandomUserName(0); string password = Utility.CreateRandomPassword(10); listAddUserName.Add(userName); //Exec create userId = (Guid)System.Web.Security.Membership.CreateUser(userName, password, writedata.Email).ProviderUserKey; } else userId = Guid.NewGuid(); } else { //if (writedata.UserId != Guid.Empty) // userId = writedata.UserId; //else userId = writedata.ExistedUserId; if (!string.IsNullOrEmpty(writedata.Email)) { userDB = (from us in mydb.Memberships where us.UserId == userId select us).FirstOrDefault(); userDB.Email = writedata.Email; } userDetail = (from ud in mydb.UserDetails where ud.UserId == userId select ud).FirstOrDefault(); polinatorInformation = (from pi in mydb.PolinatorInformations where pi.UserId == userId select pi).FirstOrDefault(); } userDetail.UserId = userId; userDetail.FirstName = writedata.FirstName; userDetail.LastName = writedata.LastName; userDetail.MembershipLevel = memberLevel; userDetail.PhoneNumber = writedata.PhoneNumber; //Table 2: polinatorInformation polinatorInformation.UserId = userId; polinatorInformation.OrganizationName = writedata.OrganizationName; polinatorInformation.Description = writedata.OrganizationDescription; polinatorInformation.PollinatorSize = writedata.PollinatorSize; polinatorInformation.PollinatorType = writedata.PollinatorType; polinatorInformation.LandscapeStreet = writedata.LandscapeStreet; polinatorInformation.LandscapeCity = writedata.LandscapeCity; polinatorInformation.LandscapeState = writedata.LandscapeState; polinatorInformation.LandscapeZipcode = writedata.LandscapeZipcode; polinatorInformation.LandscapeCountry = writedata.LandscapeCountry; polinatorInformation.Website = writedata.Website; polinatorInformation.IsApproved = true; polinatorInformation.IsNew = false; polinatorInformation.CreatedDate = createdDate; polinatorInformation.LastUpdated = createdDate; if (writedata.Latitude.HasValue && writedata.Longitude.HasValue) { polinatorInformation.Latitude = (decimal)writedata.Latitude; polinatorInformation.Longitude = (decimal)writedata.Longitude; } else { SetLalngByAddress(writedata, polinatorInformation); } polinatorInformation.SourceData = sourceData; if (!writedata.IsExistedData || actionForExistedData == "new") { mydb.UserDetails.Add(userDetail); mydb.PolinatorInformations.Add(polinatorInformation); } } try { mydb.SaveChanges(); //show successfully panel lblMess.Visible = false; this.divImportSuccessful.Visible = true; this.lblTotalDataRecord.Text = TotalRecord.ToString(); this.lblNumImported.Text = numImport.ToString(); this.lblNumNotImported.Text = (TotalInvalidRecord + numSkipExist).ToString(); this.lblNumInvalid.Text = TotalInvalidRecord.ToString(); this.lblNumSkipExist.Text = numSkipExist.ToString(); //show/hide link download log file if (TotalInvalidRecord == 0) lnkFinishInvalidLog.Visible = false; else lnkFinishInvalidLog.Visible = true; if (numSkipExist == 0) lnkFinishSkipLog.Visible = false; else lnkFinishSkipLog.Visible = true; //Write log var logContent = new StringBuilder(); logContent.Append(string.Format("Total data records: {0}{1}", TotalRecord.ToString(), Environment.NewLine)); logContent.Append(string.Format("Records imported: {0}{1}", numImport.ToString(), Environment.NewLine)); logContent.Append(string.Format("Records ignored: {0}{1}", (TotalInvalidRecord + numSkipExist).ToString(), Environment.NewLine)); logContent.Append(string.Format(" - Invalid records: {0}{1}", TotalInvalidRecord.ToString(), Environment.NewLine)); logContent.Append(string.Format(" - Manually skipped: {0}{1}", numSkipExist.ToString(), Environment.NewLine)); string fileName = "ImportSuccessful" + System.DateTime.Now.ToString("_yyMMdd_hhmm") + ".txt"; ImportExportUltility.WriteFile(Request, fileName, logContent.ToString()); //set status navigator bar: current active step = 3(Finish) SetStatusNavigationBar(4); } catch (Exception e) { //Delete added udername try { for (int i = 0; i < listAddUserName.Count; i++) { System.Web.Security.Membership.DeleteUser(listAddUserName[i]); } } catch { } //Write log fie WriteImportFailLog(e); SetStatusNavigationBar(4); //show error panel this.divImportFail.Visible = true; } }
public void Insert(UserDetail userDetail) { db.UserDetails.Add(userDetail); db.SaveChanges(); }