public object SaveSignUpUserInfo(TruflUserInputDTO registerUserInfo) { bool res = _hostessBL.SaveSignUpUserInfo(registerUserInfo); try { return(Json(new JsonResponseResult { _ErrorCode = TruflConstants._ErrorCodeSuccess, _Data = res, _StatusCode = TruflConstants._StatusCodeOK, _StatusMessage = TruflConstants._StatusMessageSuccess })); } catch (Exception ex) { return(Json(new JsonResponseResult { _ErrorCode = TruflConstants._ErrorCodeFailed, _Data = ex.ToString(), _StatusCode = TruflConstants._StatusCodeFailed, _StatusMessage = TruflConstants._StatusMessageFailed })); } }
/// <summary> /// This method 'Save Register User' will save Register user data /// </summary> /// <param name="SaveSignUpUserInfo"></param> /// <returns>Returns 1 if Success, 0 for failure</returns> public bool SaveSignUpUserInfo(TruflUserInputDTO registerUserInfo) { try { var dtClient = new DataTable(); dtClient.Columns.Add("TruflUserID", typeof(Int32)); dtClient.Columns.Add("RestaurantID", typeof(Int32)); dtClient.Columns.Add("FullName", typeof(string)); dtClient.Columns.Add("Email", typeof(string)); dtClient.Columns.Add("pic", typeof(Byte[])); dtClient.Columns.Add("PhoneNumber", typeof(string)); dtClient.Columns.Add("Password", typeof(string)); //dtClient.Columns.Add("Salt", typeof(string)); dtClient.Columns.Add("DOB", typeof(DateTime)); dtClient.Columns.Add("ActiveInd", typeof(char)); dtClient.Columns.Add("RestaurantEmpInd", typeof(Int32)); dtClient.Columns.Add("TruflMemberType", typeof(string)); dtClient.Columns.Add("TruflRelationship", typeof(Int32)); dtClient.Columns.Add("TruflshareCode", typeof(string)); dtClient.Columns.Add("ReferTruflUserID", typeof(Int32)); dtClient.Columns.Add("ModifiedDate", typeof(DateTime)); dtClient.Columns.Add("ModifiedBy", typeof(Int32)); dtClient.Columns.Add("Waited", typeof(TimeSpan)); //dtClient.Columns.Add("LoggedInUserType", typeof(string)); dtClient.Rows.Add( DBNull.Value, DBNull.Value, registerUserInfo.FullName, registerUserInfo.Email, DBNull.Value, registerUserInfo.PhoneNumber, registerUserInfo.Password, //DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value ); string connectionString = ConfigurationManager.AppSettings["TraflConnection"]; using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); using (SqlCommand cmd = new SqlCommand("spSaveTruflUser", con)) { cmd.CommandType = CommandType.StoredProcedure; SqlParameter tvpParam = cmd.Parameters.AddWithValue("@TruflUserTY", dtClient); tvpParam.SqlDbType = SqlDbType.Structured; SqlParameter tvparam1 = cmd.Parameters.AddWithValue("@LoggedInUserType", registerUserInfo.LoggedInUserType); SqlParameter pvNewId = new SqlParameter(); pvNewId.ParameterName = "@RetVal"; pvNewId.DbType = DbType.Int32; pvNewId.Direction = ParameterDirection.Output; cmd.Parameters.Add(pvNewId); int status = cmd.ExecuteNonQuery(); if (status == 0) { return(false); } else { return(true); } } } } catch (Exception ex) { var s = ex.Message; ExceptionLogger.WriteToErrorLogFile(ex); return(false); } }
public bool SaveSignUpUserInfo(TruflUserInputDTO registerUserInfo) { return(_hostessDL.SaveSignUpUserInfo(registerUserInfo)); }