Example #1
0
        public async Task <ApiResponse> CreateUpdate(OperatorRegistrationVM _vmOperatorRegistration)
        {
            ApiResponse apiResponse = new ApiResponse();

            _IOperatorRegistration = new OperatorRegisterRepo();
            try
            {
                Int32 Result = await _IOperatorRegistration.CreateUpdate(_vmOperatorRegistration);

                return(new ApiResponse {
                    IsValidUser = true, Message = string.Empty, MessageType = Result
                });
            }
            catch (Exception ex)
            {
                apiResponse = TaskUTL.GenerateExceptionResponse(ex, _pageName, true);
                return(apiResponse);
            }
        }
        public async Task <Int32> CreateUpdate(OperatorRegistrationVM _vmOperator)
        {
            try
            {
                using (SqlCommand dataCmd = new SqlCommand("OperatorRegistration", objCommonDB.con))
                {
                    dataCmd.CommandType = CommandType.StoredProcedure;
                    dataCmd.Parameters.AddWithValue("@OperatorID", _vmOperator._operatorID);
                    dataCmd.Parameters["@OperatorID"].Direction = ParameterDirection.InputOutput;
                    dataCmd.Parameters.Add(new SqlParameter("@OperatorName", _vmOperator._operatorName));
                    dataCmd.Parameters.Add(new SqlParameter("@EmailAddress", _vmOperator._emailAddress));
                    dataCmd.Parameters.Add(new SqlParameter("@Password", _vmOperator._password));
                    dataCmd.Parameters.Add(new SqlParameter("@ContactNo", _vmOperator._contactNo));
                    dataCmd.Parameters.Add(new SqlParameter("@UserName", _vmOperator._userName));
                    dataCmd.Parameters.Add(new SqlParameter("@IsActive", _vmOperator._isActive));
                    if (objCommonDB.con.State == ConnectionState.Closed)
                    {
                        objCommonDB.con.Open();
                    }
                    await dataCmd.ExecuteNonQueryAsync();

                    return(Convert.ToInt32(dataCmd.Parameters["@OperatorID"].Value));
                }
            }
            catch (Exception ex)
            {
                return(0);
            }
            finally
            {
                if (objCommonDB.con.State == ConnectionState.Open)
                {
                    objCommonDB.con.Close();
                }
            }
        }