public ActionResult registerUser(string firstName, string lastName, string nickName, string dateOfBirth, string role, string userName, string password) { int valid = 1; var Jcon = new JsonContainer(); var objUserAccountHelper = new UserAccountHelper(); if (objUserAccountHelper.VerifyUserName(userName)) { Jcon.Result = -1; return Json(Jcon); } DateTime date; if (!DateTime.TryParse(dateOfBirth, out date)) { Jcon.Result = 0; return Json(Jcon); } var userDetails = new UserAccount { firstName = firstName, lastName = lastName, nickName = nickName, dateOfBirth = date, role = role, userName = userName, password = password }; try { objUserAccountHelper.InsertUserDetails(userDetails); } catch (Exception ex) { valid = 0; } Jcon.Result = valid; return Json(Jcon); }
public void InsertUserDetails(UserAccount userDetails) { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); var cmd = new SqlCommand("insertUserDetails", conn); cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@firstName", SqlDbType.NVarChar).Value = userDetails.firstName; cmd.Parameters.Add(new SqlParameter("@firstName", userDetails.firstName)); cmd.Parameters.Add(new SqlParameter("@lastName", userDetails.lastName)); cmd.Parameters.Add(new SqlParameter("@nickName", userDetails.nickName)); cmd.Parameters.Add(new SqlParameter("@dateOfBirth", userDetails.dateOfBirth)); cmd.Parameters.Add(new SqlParameter("@role", userDetails.role)); cmd.Parameters.Add(new SqlParameter("@userName", userDetails.userName)); cmd.Parameters.Add(new SqlParameter("@password", Cryptography.CreateHash(userDetails.password))); cmd.Parameters.Add(new SqlParameter("@isActive", 'Y')); cmd.ExecuteNonQuery(); conn.Close(); } }
public ActionResult updateUserDetails(string firstName, string lastName, string nickName, string dateOfBirth) { int valid = 1; var Jcon = new JsonContainer(); var objUserAccountHelper = new UserAccountHelper(); DateTime date; if (!DateTime.TryParse(dateOfBirth, out date)) { Jcon.Result = 0; return Json(Jcon); } var userDetails = new UserAccount { userId = long.Parse(Session["userId"].ToString()), firstName = firstName, lastName = lastName, nickName = nickName, dateOfBirth = date }; try { objUserAccountHelper.UpdateUserDetails(userDetails); } catch (Exception ex) { valid = 0; } Jcon.Result = valid; return Json(Jcon); }
public void UpdateUserDetails(UserAccount userDetails) { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); var cmd = new SqlCommand("updateUserDetails", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@userId", userDetails.userId)); cmd.Parameters.Add(new SqlParameter("@firstName", userDetails.firstName)); cmd.Parameters.Add(new SqlParameter("@lastName", userDetails.lastName)); cmd.Parameters.Add(new SqlParameter("@nickName", userDetails.nickName)); cmd.Parameters.Add(new SqlParameter("@dateOfBirth", userDetails.dateOfBirth)); cmd.ExecuteNonQuery(); conn.Close(); } }