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);
}
