public void OpenAccount(string FirstName,String LastName,String Title,String EmailId,String Country, String DateOfBirth,String UserName,String Password,String AccountBaseCurrency,bool IsPromotionalSubcribed) { RegisterModel objRegisterModel = new RegisterModel(); UserAccountModels objUserAccountModels = new UserAccountModels(); objRegisterModel.FirstName = FirstName; objRegisterModel.LastName = LastName; objRegisterModel.Title = Title; objRegisterModel.Email = EmailId; objRegisterModel.Country = Country; objRegisterModel.DateOfBirth = DateOfBirth; objRegisterModel.UserName = UserName; objRegisterModel.Password = Password; objRegisterModel.AccountBaseCurrency = AccountBaseCurrency; objRegisterModel.IsPromotionalSubcribed = IsPromotionalSubcribed; objUserAccountModels.OpenAccount(objRegisterModel); }
public RegisterModel OpenAccount(RegisterModel objRegisterModel) { using (SqlConnection cnn = new SqlConnection(CommonCollection.ConnectionString)) { try { cnn.Open(); using (SqlCommand cmd = new SqlCommand("OpenAccount", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = objRegisterModel.FirstName; cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = objRegisterModel.LastName; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = objRegisterModel.Title; cmd.Parameters.Add("@EmailId", SqlDbType.NVarChar).Value = objRegisterModel.Email; cmd.Parameters.Add("@Country", SqlDbType.NVarChar).Value = objRegisterModel.Country; cmd.Parameters.AddWithValue("@DateOfBirth", objRegisterModel.DateOfBirth); cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = objRegisterModel.UserName; cmd.Parameters.Add("@Password", SqlDbType.NVarChar).Value = objRegisterModel.Password; cmd.Parameters.Add("@AccountBaseCurrency", SqlDbType.NVarChar).Value = objRegisterModel.AccountBaseCurrency; cmd.Parameters.Add("@IsPromotionalSubcribed", SqlDbType.Bit).Value = objRegisterModel.IsPromotionalSubcribed; cmd.Parameters.Add("@idOut", SqlDbType.Int).Value = null; cmd.Parameters["@idOut"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@GUID", SqlDbType.UniqueIdentifier).Value = ""; cmd.Parameters["@GUID"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); objRegisterModel.UserId = Convert.ToInt32(cmd.Parameters["@idOut"].Value.ToString()); if (objRegisterModel.UserId > 0) { MEmail.SendConfirmationEmail(objRegisterModel.Email, objRegisterModel.FirstName + " " + objRegisterModel.LastName, cmd.Parameters["@GUID"].Value.ToString()); } } } catch (Exception ex) { throw new Exception(ex.ToString(), ex); } finally { cnn.Close(); cnn.Dispose(); SqlConnection.ClearPool(cnn); } return objRegisterModel; } }
public Int32 OpenAccount(string FirstName, String LastName, String Title, String EmailId, String Country, String PhoneNo, String DateOfBirth, String UserName, String Password, String AccountBaseCurrency, bool IsPromotionalSubcribed) { try { RegisterModel objRegisterModel = new RegisterModel(); UserAccountModels objUserAccountModels = new UserAccountModels(); objRegisterModel.FirstName = FirstName; objRegisterModel.LastName = LastName; objRegisterModel.Title = Title; objRegisterModel.Email = EmailId; objRegisterModel.Country = Country; objRegisterModel.PhoneNo = PhoneNo; objRegisterModel.DateOfBirth = DateOfBirth; objRegisterModel.UserName = UserName; objRegisterModel.Password = Password; objRegisterModel.AccountBaseCurrency = AccountBaseCurrency; objRegisterModel.IsPromotionalSubcribed = IsPromotionalSubcribed; objRegisterModel = objUserAccountModels.OpenAccount(objRegisterModel); if (objRegisterModel.UserId > 0) { objUserAccountModels.ValidateUser(UserName, Password); Session["username"] = FirstName + " " + LastName; Session["user"] = objRegisterModel.UserId; StockModels objStockModels = new StockModels(); Session["TradeBalance"] = Math.Round(Convert.ToDouble(objStockModels.GetUserAccountBalance(Convert.ToInt32(Session["user"].ToString()))), 2); return 1; } else { return -2; } } catch (Exception ex) { throw ex; } }