Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public async Task<bool> CheckIfUserRegistered(string phoneNumber, DateTime dateOfBirth)
- {
- if (string.IsNullOrWhiteSpace(phoneNumber))
- {
- return false;
- }
- using (var cmd = _dbContext.Database.GetDbConnection().CreateCommand())
- {
- cmd.CommandText = "dbo.CheckIfUserRegistered";
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.Add(new SqlParameter("@phoneNumber", SqlDbType.NVarChar) { Value = phoneNumber });
- cmd.Parameters.Add(new SqlParameter("@dateOfBirth", SqlDbType.Date) { Value = dateOfBirth });
- cmd.Parameters.Add(new SqlParameter("@registered", SqlDbType.Bit) { Direction = ParameterDirection.Output });
- if (cmd.Connection.State != ConnectionState.Open)
- {
- cmd.Connection.Open();
- }
- await cmd.ExecuteNonQueryAsync();
- return (bool)cmd.Parameters["@registered"].Value;
- }
- }
- bool isOpen = cmd.Connection.State == ConnectionState.Open;
- if (!isOpen)
- {
- cmd.Connection.Open();
- }
- await cmd.ExecuteNonQueryAsync();
- if (!isOpen)
- {
- cmd.Connection.Close();
- }
- private SqlParameter BuildParamter(string name, SqlDbType type, object value, ParameterDirection? direction)
- {
- var parameter = new SqlParameter(name, type);
- if (value != null)
- {
- parameter.Value = value;
- }
- if (direction.HasValue)
- {
- parameter.Direction = direction.Value;
- }
- return parameter;
- }
- cmd.Parameters.Add(new SqlParameter("@phoneNumber", SqlDbType.NVarChar) { Value = phoneNumber });
- cmd.Parameters.Add(new SqlParameter("@dateOfBirth", SqlDbType.Date) { Value = dateOfBirth });
- cmd.Parameters.Add(new SqlParameter("@registered", SqlDbType.Bit) { Direction = ParameterDirection.Output });
- cmd.Parameters.Add(BuildParameter("@phoneNumber", SqlDbType.NVarChar, phoneNumber));
- cmd.Parameters.Add(BuildParameter("@dateOfBirth", SqlDbType.Date, dateOfBirth));
- cmd.Parameters.Add(BuildParameter("@registered", SqlDbType.Bit, null, ParameterDirection.Output));
- SetStoredProcedure("CheckIfUserRegistered", cmd):
- cmd.Parameters.Add(BuildParameter("@phoneNumber", SqlDbType.NVarChar, phoneNumber));
- cmd.Parameters.Add(BuildParameter("@dateOfBirth", SqlDbType.Date, dateOfBirth));
- cmd.Parameters.Add(BuildParameter("@registered", SqlDbType.Bit, null, ParameterDirection.Output));
- ExecuteStoredProcedure(cmd);
- return (bool)cmd.Parameters["@registered"].Value;
- public virtual int DeleteBusiness(Nullable<int> p_COMPID)
- {
- var p_COMPIDParameter = p_COMPID.HasValue ?
- new ObjectParameter("p_COMPID", p_COMPID) :
- new ObjectParameter("p_COMPID", typeof(int));
- return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("DeleteBusiness", p_COMPIDParameter);
- }
- DbContext.DeleteBusiness(compId);
Add Comment
Please, Sign In to add comment