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