private static User FillDataRecord(IDataRecord myDataRecord) { User user = new User(); user.Id = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Id")); user.UserName = myDataRecord.GetString(myDataRecord.GetOrdinal("username")); //TODO:Encrypt user.Password = myDataRecord.GetString(myDataRecord.GetOrdinal("password")); user.FirstName = myDataRecord.GetString(myDataRecord.GetOrdinal("firstname")); user.LastName = myDataRecord.GetString(myDataRecord.GetOrdinal("lastname")); user.Address = myDataRecord.GetString(myDataRecord.GetOrdinal("address")); user.ContactNumber = myDataRecord.GetInt64(myDataRecord.GetOrdinal("contactnumber")); user.DateOfBirth = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("dateofbirth")); user.EmailId = myDataRecord.GetString(myDataRecord.GetOrdinal("emailid")); user.SecurityQuestion = myDataRecord.GetString(myDataRecord.GetOrdinal("securityquestion")); user.Answer = myDataRecord.GetString(myDataRecord.GetOrdinal("answer")); byte[] addressProofBytes = (byte[])myDataRecord.GetValue(myDataRecord.GetOrdinal("addressproof")); string addressProofFile = Convert.ToString(DateTime.Now.ToFileTime()); FileStream fs = new FileStream(addressProofFile, FileMode.CreateNew, FileAccess.Write); fs.Write(addressProofBytes, 0, addressProofBytes.Length); fs.Flush(); fs.Close(); user.AddressProof = Image.FromFile(addressProofFile); byte[] photoIdentityBytes = (byte[])myDataRecord.GetValue(myDataRecord.GetOrdinal("photoidentity")); string photoIdentityFile = Convert.ToString(DateTime.Now.ToFileTime()); fs = new FileStream(photoIdentityFile, FileMode.CreateNew, FileAccess.Write); fs.Write(photoIdentityBytes, 0, photoIdentityBytes.Length); fs.Flush(); fs.Close(); user.PhotoIdentity = Image.FromFile(photoIdentityFile); user.Status = (UserStatus)myDataRecord.GetInt32(myDataRecord.GetOrdinal("status")); user.RewardPoints = myDataRecord.GetInt32(myDataRecord.GetOrdinal("rewardpoints")); return user; }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user try { //WebSecurity.CreateUserAndAccount(model.UserName, model.Password); OnePointTelecom.Models.Objects.User user = new OnePointTelecom.Models.Objects.User(model); UserManager.Insert(user); WebSecurity.Login(model.UserName, model.Password); return RedirectToAction("Index", "Home"); } catch (MembershipCreateUserException e) { ModelState.AddModelError("", ErrorCodeToString(e.StatusCode)); } } // If we got this far, something failed, redisplay form return View(model); }
public static int Insert(User user) { int result = 0; using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings[Connection.ConnectionName].ConnectionString)) { StringBuilder insertstmt = new StringBuilder("INSERT INTO [dbo].[User] ( [username], [password], [firstname], [lastname], [address], [contactnumber], [dateofbirth], [emailid], [securityquestion], [answer], [addressproof], [photoidentity], [status], [rewardpoints]) VALUES (@username,@password,@firstname,@lastname,@address,@contactnumber,@dateofbirth,@emailid,@securityquestion,@answer,@addressproof,@photoidentity,@status,@rewardpoints)"); //StringBuilder insertstmt = new StringBuilder("INSERT INTO [dbo].[User] ( [username], [password], [firstname], [lastname], [address], [contactnumber], [dateofbirth], [emailid], [securityquestion], [answer], [addressproof], [photoidentity], [status], [rewardpoints]) VALUES ( N'sunnyraj4', N'asd4', N'asd', N'asd', N'asd', CAST(12 AS Decimal(10, 0)), N'2012-12-12', N'ASD', N'ASD', N'ASD', 0, 0, 0, CAST(0 AS Decimal(18, 0)))"); SqlCommand command = new SqlCommand(insertstmt.ToString(), myConnection); command.CommandType = CommandType.Text; command.Parameters.Add("@username", SqlDbType.VarChar, 25).Value = user.UserName; command.Parameters.Add("@password", SqlDbType.VarChar, 100).Value = Crypter.ComputeHash(user.Password); command.Parameters.Add("@firstname", SqlDbType.VarChar, 20).Value = user.FirstName; command.Parameters.Add("@lastname", SqlDbType.VarChar, 20).Value = user.LastName; command.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = user.Address; command.Parameters.Add("@contactnumber", SqlDbType.Decimal,10).Value = user.ContactNumber; command.Parameters.Add("@dateofbirth", SqlDbType.Date).Value = user.DateOfBirth; command.Parameters.Add("@emailid", SqlDbType.VarChar, 50).Value = user.EmailId; command.Parameters.Add("@securityquestion", SqlDbType.VarChar, 200).Value = user.SecurityQuestion; command.Parameters.Add("@answer", SqlDbType.VarChar, 100).Value = user.Answer; MemoryStream ms = new MemoryStream(); user.AddressProof.Save(ms,System.Drawing.Imaging.ImageFormat.Jpeg); command.Parameters.Add("@addressproof", SqlDbType.Image).Value = ms.ToArray(); ms = new MemoryStream(); user.PhotoIdentity.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); command.Parameters.Add("@photoidentity", SqlDbType.Image).Value = ms.ToArray(); command.Parameters.Add("@status", SqlDbType.Int).Value = user.Status; command.Parameters.Add("@rewardpoints", SqlDbType.Decimal).Value = user.RewardPoints; DbParameter returnValue; returnValue = command.CreateParameter(); returnValue.Direction = ParameterDirection.ReturnValue; command.Parameters.Add(returnValue); myConnection.Open(); command.ExecuteNonQuery(); result = Convert.ToInt32(returnValue.Value); myConnection.Close(); } return result; }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user try { string extension = Path.GetExtension(model.AddressProof.FileName); if ((!extension.Equals(".jpg")) && (!extension.Equals(".jpeg"))) { ModelState.AddModelError("", "Invalid File for Address proof."); return View(model); } extension = Path.GetExtension(model.PhotoIdentityProof.FileName); if ((!extension.Equals(".jpg")) && (!extension.Equals(".jpeg"))) { ModelState.AddModelError("", "Invalid File for Identity proof."); return View(model); } OnePointTelecom.Models.Objects.User user = new OnePointTelecom.Models.Objects.User(model); int retval = UserManager.Insert(user); if (retval < 0) { ModelState.AddModelError("", MvcApplication.GetMessage()); return View(model); } TempData["message"] = "Registration Successful.Please wait while Administrator approves the registration."; MvcApplication.SetMessage("Registration Successful.Please wait while Administrator approves the registration."); return RedirectToAction("Login", "Account"); } catch (MembershipCreateUserException e) { ViewBag.Message = ErrorCodeToString(e.StatusCode); ModelState.AddModelError("", ErrorCodeToString(e.StatusCode)); } catch (Exception e) { ViewBag.Message = e.Message; } } // If we got this far, something failed, redisplay form return View(model); }