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